Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

Re: [PHP-DB] MySQL Error??? From: Dobromir Velev (diadomraz <email protected>)
Date: 06/28/01

Hi,
This error occurs when your auto_increment index field is of type TINYINT.
This field type can accept values form -128 to 127 so you cannot add records
with index value greater than 127.
I recommend you change it to INT(11) UNSIGNED which can accept values from 0
to 4294967295.

If you expect to have more records you may consider using BIGINT type

For more info check the MySQL language reference.

Dobromir Velev

-----Original Message-----
From: Brian Grayless <bgrayless <email protected>>
To: PHP DB list (E-mail) <php-db <email protected>>
Date: Thursday, June 28, 2001 9:29 AM
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 <email protected>
>For additional commands, e-mail: php-db-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>