Posted by davek on 07/14/06 22:12

me:
> Error updating database: Duplicate entry '127' for key 1
>
> ie, for some reason, the INSERT query is trying to enter the new row
> with the same primary key as an already existing row, which it
> shouldn't be as it's set to auto_increment.

I've just worked out why it's doing it - the primary key is a
TINYINT...

Doh!

I'll go away and leave you all in peace now (until I have another
stupid question...)

David

• Next in forum: tracking / help desk software (free)
• Prev in forum: Re: popup or not?
• Thread view: Re: "call to undefined function" mysql_error when adding new rows to table

[Reply to this message]