Hi, could you check to make absolutely sure that your taskId column isn't tinyint, which should explain it as it's max ( being signed ) is 127.
/Johan
mel list_php wrote:
Hi list,
I have a very strange (and worrying..!!!) problem with my tables.
I'm running a 4.0.9 gamma (no choice for that) adn I had a MyIsam table with an auto-increment field.
Everything worked fine friday, and today the "auto-increment" field is just not working anymore.
When I want to insert a new value, the auto-index is blocked on number 127.
Then it complains: duplicate entry for key 127.
I deleted thatrecord, re insert a new row, and again same problem....
My table is basic taskId (int auto-increment) ownerId (int) targetId(int) date (date)
My insert is just insert into tableTask (`ownerId`,`targetId`,`date`) values ($ownerId,$targetId,'$date')
I think this syntax is correct, the auto_increment field should be generated automatically (it has always been until today)
Does anybody ever had such a problem?
I put a backup from friday on line it works fine, but of course I lost a few data.
Can it come from a table corruption? any other ideas?I'm just worrying how I could know that kind of error, because it's one of my users who warned me "I have a problem" or I wouldn't have noticed it.
Thanks a lot for your help.
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
