Page 1 of 1

#1062 - Duplicate entry '127' for key 1

Posted: Sun Mar 28, 2004 8:13 pm
by warriors2003
Hey guys, I'm going along inserting data in a table,,then I get this error out of nowhere in mysql

#1062 - Duplicate entry '127' for key 1

I did some searching, can't quite figure out the problem. Now I can't get past the point of enerting more data. Their are no dupcliate field names or ID's. (ID was auto, but didn;t give me any problems before this)
How can I fxi this??

Thanks in Advance

Posted: Sun Mar 28, 2004 8:19 pm
by danyprundus
Didn't you by any changes already added some data in thad database?
Check your sql quesry and your database.

Posted: Sun Mar 28, 2004 9:07 pm
by markl999
Your column type is a tinyint which only allows values from -127 to 127, change it to an int and all will be well ;)