Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001062

RE: [PHP-DB] MySQL Error??? From: Brian Grayless (bgrayless <email protected>)
Date: 06/28/01

Thanks guys. It was all very helpful and worked great!
Brian

-----Original Message-----
From: Christian Sandfeld [mailto:csa <email protected>]
Sent: Thursday, June 28, 2001 3:06 AM
To: 'Brian Grayless'; 'php-db <email protected>'
Subject: RE: [PHP-DB] MySQL Error???

Brian,

Sounds to me as if the field you have as primary key is set to type
'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when
set to 'unsigned' it accepts values from 0 to 255.

In your place I would concider changing that column to a 'SMALLINT' and set
it to 'unsigned'. This will allow for values from 0 to 65535 (depending ofc.
on how many digits you set as the max display size).

Hope I helped :)

/Christian

-----Original Message-----
From: Brian Grayless [mailto:bgrayless <email protected>]
Sent: 27. juni 2001 18:24
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 <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>

-- 
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>