Space problem?

[Wyatt James]

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.  

Wyatt James
http://www./britcastles.com