Wow....I think I can finally help somebody on this list.
Ok. I bet that you have your column set up as "tinyint". I presume it
would be the "id" column that you have. "tinyint" is the following:
Signed values: -128 to 127
Unsigned values: 0 to 255
I ran into the problem before too. So if you want to go past 127, you
either need to set it as an Unsigned value, but that will only let you go
to 255, or set it to another int. smallint will go to 65535 (Unsigned),
mediumint will go to 16777215 (Unsigned), etc.....
Happy to finally be able to help. :)
Steve Buehler
At 07:38 AM 4/19/2002, Henning Olsen wrote:
>Hey - can anyone help?
>I have a MySql-db in which I can only have 127 records.
>Using phpmyadmin to insert record number 128 (autoincrement) gets this
>message:
>
>INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,
>`telefon`, `kommentar`) VALUES ('', 'fsd', 'sfdg', 'sg', 'fdsg', 'sfg', 'sg');
>
>MySQL returnerede:
>
>Duplicate entry '127' for key 1
>
>
>No matter what table or desing of table - the result is the same. Using
>other interfaces than phpmyadmin gives the same result too.
>
>Thanks for helping
>
>Henning
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
