Wyatt James wrote:
>
> I am getting a misleading error message saying "duplicate key 127 at key 1" when
>trying to add an item to a table. There is no duplicate (I downloaded then uploaded
>to a new table and get the same error). The unique key is a smallint(4) with
>auto-increment. Is there some limit in MySQL on a Linux server on how many entries a
>table can contain? Each row is only about 1K in size and I read somewhere that you
>can go up to 2gig on a table size.
>
Are you sure key is not a tinyint?
127 is the largest value for a tinyint.
---------------------------------------------------------------------
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
