[horde] horde user can't update horde_datatree_seq

[Peter Wood]

An update:

I just upgraded MySQL from 3.23.58 to 4.1.8. Suddenly, DataTree
support is working. I haven't made any other changes to my system and
certainly not to my Horde configuration.

Is it possible that Horde or the Pear DB is using a feature that was
introduced to MySQL between 3.23.58 and 4.1.8? And therefore it wasn't
able to automatically create these tables, etc?

Peter


On Thu, 23 Dec 2004 21:45:52 -0500, Peter Wood <peter.r.wood at gmail.com> wrote:
> > I suppose I could try manually inserting a row into mysql.tables_priv
> > to get around the fact that the table doesn't exist.
> 
> Just for kicks, I tried this:
> 
> mysql> insert into tables_priv (Host, Db, User, Table_name, Grantor,
> Table_priv) values
> ('localhost','horde3','horde','horde_datatree_seq','root at localhost','Select,Insert,Update,Delete');
> 
> But, still no dice:
> 
> Dec 23 21:42:52 HORDE [error] [mnemo] 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
> "/usr/local/apache2/htdocs/horde/lib/Horde/DataTree/sql.php"]
> 
> ...
> --
> Peter R. Wood | email: peter.r.wood at gmail.com | blog: http://prwdot.org/
> 


-- 
Peter R. Wood | email: peter.r.wood at gmail.com | blog: http://prwdot.org/