Duplicate entry '127' for key 1
I have no idea what it means, or how i should go about fixing it.
If you have any ideas i would appritiate it.
Thank you Anthony
exactly what it says on the tin...
you have a duplicate entry on line 127.
Sounds like someone used a tiny int for their key field and now it's all full up.
Could it be somethign else causing the problem? I don't seem to have any tinyint in my sql database.
Thank you for your help.
It seems that the problem is my id.. It is row 127 and it seems to be breaking when trying to make another one.
Any ideas on how to fix this problem?
What type of field is the primary key from that table?
I set it as tinyint... When i encounterd this problem i changed it to varchar.. NOw it is back to tinyint and nothign has fixed it.
This is also my id field.
Change it to int or bigint. tinyint can only hold 127 numbers
INteresting, i never knew that it did fix my problem.
Do you know how many bigint can hold?
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Numeric_types
