I CC-ed the mailing list by accident. Below is my original reply to Brian.
-----Original Message-----
From: Jonathan Hilgeman
Sent: Thursday, June 28, 2001 8:14 AM
To: 'Brian Grayless'
Cc: PHP-DB (E-mail)
Subject: RE: [PHP-DB] MySQL Error???
Hi Brian,
Sounds like you have a tinyint field. Change it to something like int(4) or
bigger, like int(6) or something. TinyInt fields can only hold up to 127, so
when you add another record, the auto-incrementing field you're using cannot
go any higher, so it tries to assign 127, but 127 is already taken. Thats
why you get that error.
- Jonathan
-----Original Message-----
From: Brian Grayless [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:24 AM
To: PHP DB list (E-mail)
Subject: [PHP-DB] MySQL Error???
Is anyone familiar with this MySQL error?
"1062: Duplicate entry '127' for key 1"
I wrote a great bookmark management program that works fine, but everytime I
insert bookmarks, I insert somewhere over 120 and I start getting this
error, and it won't add them anymore. Any suggestions???
Thanks,
B R I A N G R A Y L E S S
Web Administrator
Premier Resorts
www.premier-resorts.com
P: 435-655-4812
F: 413-618-1518
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
