[kronolith] Fwd: Re: [cvs] cvs commit: nag prefs.php

[Ilya]

Mike, I didnt have this table , and dont have structure for it.
I created the table, and run that grant query. now the error i get is:
object(db_error)(7) { ["error_message_prefix"]=> string(0) "" ["mode"]=>
int(1) ["level"]=> int(1024) ["code"]=> int(-19) ["message"]=> string(23)
"DB Error: no such field" ["userinfo"]=> string(104) "UPDATE
kronolith_events_seq SET id=LAST_INSERT_ID(id+1) [nativecode=Unknown column
'id' in 'field list']" ["callback"]=> NULL }


its seems i need at least two columns - id and userinfo
do you know what else need to be in that table? even these two are not
similar to just kronolith_events table.

----- Original Message -----
From: "Mike Hardy" <mhardy@h3c.com>
To: <kronolith@lists.horde.org>
Sent: Saturday, January 26, 2002 11:48 PM
Subject: Re: [kronolith] Fwd: Re: [cvs] cvs commit: nag prefs.php


>
> On Sat, 26 Jan 2002, Chuck Hagenbuch wrote:
>
> > Quoting Mike Hardy <mhardy@h3c.com>:
> >
> > > Tables that end in _seq in postgres (I'm assuming this is postgres?)
> >
> > It's kind of the same idea - it's a PEAR DB sequence. Maybe the Horde
user
> > doesn't have permissions to create tables?
>
> To generate an error like "user horde doesn't have permission to update"
> the sequence of events has to be something like "created schema with non
> horde user", "didn't grant horde user permissions"
>
> There could be infinite variations around it, but that's my hunch as to
> what it boils down to.
>
> Ilya - I realize you're using mysql instead of postgres, but could you try
> the grant I posted in the last message? "grant all on kronolith_events_seq
> to user 'horde@wherever.it.was.at'"?
>
> That really should do the trick. Again though - there may be other
> problems if the horde user didn't create the schema. Might be permissions
> lacking all over the place...but I'm not sure how the PEAR DB stuff works,
> so I can't help much - I can just guess around it.
>
> -Mike
>
>
>
> --
> Kronolith mailing list: http://horde.org/kronolith/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
>
>