RE: [PHP-DB] MySQL Error???

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:bgrayless@Premier-Resorts.com] 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net