1062: Duplicate entry '1221' for key 1

[juggie]

i am getting the following error when a new user tries to register
1062: Duplicate entry '1221' for key 1???
plzz help
regards
thx in advance
-mysql
-php

[aspiers]

It says it all in the message. You are trying to do an insert and have a duplicate key value - 1221 in this case, which probably means you have setup your key as unique !!!

How have you set your key value up ? Do you have it as autoincrement ? Does your key need to be unique ?

Andrew

[juggie]

i have autoincrement...

Yes my key need to be unique(this is to register new users on my site)
your help is very much appreciated
regards
dj

[aspiers]

Everything sounds correct.

Can you post the code you are using to do the insert ?

[Anon]

I had a similar problem. I was using small int as the type. I changed it to int and everything worked.... My count was only up to 127 so I don't know exactly why it fixed it but it did.

-alocurto