MySQL Error : Duplicate entry '4294967295' for key 1 Error Number : 1062
 

Hi when i want to add a new user or one user want to register in my forum this message apear for me please help me how to solve it thank you

Check the manual in future, Duplicate entry 'XXX' ;)

That will not solve this situation. I suggest that you open a support ticket regarding this issue as it will be easier to resolve if a technician has access to your database.

:erm: Stoopid manual :mad: :D

That part of the manual is usefull in most cases with this error, but not in this specific case. The "out of the ordinary" in this specific issue is that it looks like the maximum value for this field is already reached and the database must first be inspected to see if there are any large gaps in userid numbering, then the auto_increment value must be reset to a suitable value and possibly some higher number accounts need to be renumbered or removed & recreated.

Oh I see. Makes sense ;)

So the "4294967295" is the next userid (I assume)? 4 billion users does seem a lot. :D

Yes the '4294967295' is the new userid.

im having this problem with my forum currently - we dont know how to stop this happening ? - soooo annoying

As Marco told the other guy you should open a support ticket if you can... for some reason your userid counter has reached the maximum allowed value but since you obviously don't have 4 billion users something went wrong... You (or someone qualified) will need to manually look at your users table in the database and see where your user id's jumped from normal values to the billions... The auto increment will need to be reset to the lower, correct value... Higher user ids, if they exist may have to be changed or deleted. How many users does your forum report you as having?