Duplicate entry '127' for key 1

brandis

I get this error message when i try to insert a new record into a table in my MySQL database.

"MySQL Said: Duplicate entry '127' for key 1"

The last record I entered received the Primary Key ID 127 by autoincrement. Now I cannot add another record. If I delete the record 127 I can add one record then start recieving the error again.

When inserting I am not giving each record an ID , I leave that to MySQL to do via the autoincrement. I am baffled. Any ideas?

trippyd

I am willing to bet that the autoincrement field is a tinyint type, which has a top value of 127. Change the column type on the autoincrement field to a regular int and see if that works.

brandis

That was it. I am stupid. I remember reading that now that you have reminded me, but it never even occured to me.

Thanks!

Anon

I had the same pb, you're the master,
Thanks a lot.

Anon

I too had the same problem, my usual method of solving inexplicable problems is to enter the error message into google (http://www.google.com) and hope for the best. It brought me straight to this thread.

A-mazing. Thanks alot.

Anon

Praise All Mighty Google & PHPBuilder.

Thanks guys.

Anon

Praise All Mighty Google & PHPBuilder.
Praise All Mighty Google & PHPBuilder.
Praise All Mighty Google & PHPBuilder.
Praise All Mighty Google & PHPBuilder.
Praise All Mighty Google & PHPBuilder.

Anon

I did that google thing too..

Praise All Mighty Google & PHPBuilder.

Anon

funny - i did the exact same thing as you guys google -> this thread

greets louis

Anon

(I got to this through Google as well - amazing!)

HOWEVER, my issue is a bit different! If I add a record in mySQL directly, it increments to the next number no problem. However, from my page, it assigns.. of all numbers.. '1246576928' ?!?!?

When you try to add another record using the same script - kaboom. No can do.

Thoughts?

Fingers Crossed

Drew

[deleted]

It may be time for you to check your tables for corruption using myisamchk. Read the MySQL manual for more information about that.

Anon

Google rulez!!! Thanks for the great help... 🙂

Anon

Thank you! Thank you!

I struggled with this for days!

Anon

Should we put "INT" instead of TINY INT, or MEDIUM , what are the maximum fields for each please ?
what does it do if i use INT ? Is it slowly ?

Brian wrote:

Google rulez!!! Thanks for the great help... 🙂

[deleted]

TINYINT takes only one byte of harddiskspace, INT takes four. But, TINYINT can hold -127 through 127 or 0 through 255,
INT can hold -2147483648 to 2147483647, or to 0 through 4294967295

If you are absolutely sure that you will never need more than 127/255 numbers, then you can use tinyint. But it is generally much safer to just use INT.

http://www.mysql.com/doc/N/u/Numeric_types.html

Anon

hey,
well i got like the same problem, but the solution not working for me:
my error message is:
Duplicate entry '27028' for key 1

my primary key is an INT(10) unsigned auto_increment

and i got 26974 rows
last one is ID=27061

i got the error when i try to add a field to this table.

[deleted]

Is it possible that you are really just trying to insert a duplicate value?

Anon

not really!

i got the error message when i try to change some field property of the table... not when trying to add a new line.
and i always trust mysql for the automatic id assignment (auto increment)

even if i add a duplicate value, there not suppose to have the same id, since i don't specify an id.

maybe i got some corrupted index or something
i try to check with isamchk, and it seem ok.

is there a query for finding duplicate rows??

Anon

ok it seem that i had a duplicate id!
don't ask me why!!
i did check yesterdy (select * from mytable where id = 27028) and got 1 answer
and today i got 2 answers and i deleted one of the two and now it work

[deleted]

Strange..... very strange.. how did you get a table with en auto_increment that was not a primary key?