Duplicate Entry Number

Anon

Hi,
We are having a problem getting new entries into a MySql table. It keeps giving me an error message saying it is a duplicate entry number. It is set for auto increment and it does not matter if we insert a number or not, we always get the same message. We have quite a few entries already in this table, so my first question would be, is there a max number of rows a table will accept. Second, if we have not reached a max number, does anyone have any ideas what can be causing this conflict.

In addition to our php script, we also have PHPMYADMIN, and I have even tried to make new entries direct, and it will not let us.
Thanks for any ideas.
FTW

thinsoapy

I had the exact same problem. I had my id column in my db set to 'tinyint' - which is supposed to allow you entries that are up to 255 characters - at least that is my understanding from the mysql documentation. When I tried to enter record number 256 - I got the 'duplicate entry' error. It looks like, at least for the primary id column, that the number 255 is the max. just change your column to 'int' and everything should work...

Dave

phlow

there should be no maximum of rows. the only problem i can think of is that you have limited the number of rows by making your primary key e.g. an tinyint with the maxium length of for example 1, which would mean that you can only make 9 entries.

if this is not the solution (which is very likely), why don't you just post a structure-only database dump (using phpMyadmin) so that the people here can look for your mistake.

good luck, Phlow.

Anon

Hi,

Thanks for the input. You guys were right, I changed from Tinyint to INT plus changed the max length and it works fine now.

I appreciate your help.
FTW