Date index for Jul 2003

At 10:14 PM 7/2/2003 +0200, you wrote:
> Hello,
>
> Kevin Gittens wrote:
>
> > I see that the default value for "id" in the mysql project table is set 
> > to 0, but I assume that Achievo takes care of incrementing this number to 
> > whatever the current highest ID number is + 1, and this is where it goes wrong.
>
> Yes, Achievo uses the db_sequence table to generate unique id's for 
> projects. By any chance, does Mandrake to 9.1 perhaps use MySQL 4.0, 
> whereas the previous version used MySQL 3?
>
> If that is the case, then you must make sure the database user has the 
> global 'lock tables' privilege. In MySQL 3 this wasn't necessary.
>
> Greetings,
> Ivo
Hi Ivo,

Yes, that is exactly the case, Mandrake uses 4.0 of MySQL in 9.1
If that is the case, then you must make sure the database user has the 
global 'lock tables' privilege. In MySQL 3 this wasn't necessary.

And it certainly fixed the problem as well, thanks a lot! ( And sorry for 
omitting the version numbers in the first email )


--
Regards,
Kevin Gittens
Computer & Network Consulting Services Ltd.