H3-RC1 Problem: Add Item Was: [kronolith] H3-RC1 Problems: Calendar Load/Add Item

[Brandon Knitter]

Found it! :)  I finally went through the config line by line and realized that I
had logging turned on (by default)...DUH!!!! :)

Nov 21 20:30:18 HORDE [error] [kronolith] DB Error: unknown error: UPDATE
horde_datatree_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1142 ** update
command denied to user: 'horde at localhost' for table 'horde_datatree_seq'] [on
line 334 of "/var/www/html/horde-3.0-rc1/lib/Horde/DataTree/sql.php"]


>From here I checked out the base horde create.mysql.sql:

-- If you choose to grant permissions manually, note that with MySQL, PEAR DB
-- emulates sequences by automatically creating extra tables ending in _seq,
-- so the MySQL "horde" user must have CREATE privilege on the "horde"
-- database.

I noticed that the script doesn't grant CREATE to the horde user, do this means
that the sequence creation will fail.

Please let me know if I missed the boat there! ;-)

-- 
-bk


Quoting Brandon Knitter <knitterb at blandsite.org>:

> Okay, all of my errors are gone (did a fresh install), but now I'm still
> getting
> redirected to the Calendar Month view when I click Add Event.
> 
> Is there a way I can debug this to see what's going on?
> 
> -- 
> -bk
> 
> 
> Quoting Chuck Hagenbuch <chuck at horde.org>:
> 
> > Quoting Brandon Knitter <knitterb at blandsite.org>:
> > 
> > > Hmmm, I don't recall setting one up at all.  Is there a default?  
> > > Maybe I need to configure one?
> > 
> > Yes you do.
> > 
> > -chuck
> > 
> > -- 
> > "But she goes not abroad in search of monsters to destroy." - John 
> > Quincy Adams
> > -- 
> > Kronolith mailing list - Join the hunt:
> http://horde.org/bounties/#kronolith
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
> > 
> > 
> 
> 
> -- 
> Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org
> 
>