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

[Arman Dinarvand]

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

Database error in vBulletin 3.7.2:

Invalid SQL:
INSERT INTO user
	(salt, passworddate, password, options, adminoptions, usertitle, customtitle, username, email, languageid, homepage, birthday_search, birthday, showbirthday, icq, aim, yahoo, msn, skype, parentemail, referrerid, ipaddress, posts, usergroupid, reputationlevelid, reputation, warnings, infractions, ipoints, pmpopup, autosubscribe, threadedmode, showvbcode, styleid, timezoneoffset, daysprune, joindate, lastactivity, lastpost, membergroupids, displaygroupid, lastvisit, maxposts, startofweek)
VALUES
	('b4<', FROM_UNIXTIME(1219180045), '567cec123cbad7cdfabb5cdc16626834', 11541879, 0, 'کاربر تازه وارد', 0, 'arman3', 'arman3@itech2.net', 0, '', '', '', 0, '', '', '', '', '', '', 0, '', 0, 2, 5, 10, 0, 0, 0, 1, 0, 0, 2, 0, '3.5', -1, 1219179960, 1219179960, 0, '', '', 1219180045, -1, -1);

MySQL Error   : Duplicate entry '4294967295' for key 1
Error Number  : 1062
Request Date  : Tuesday, August 19th 2008 @ 03:07:25 PM
Error Date    : Tuesday, August 19th 2008 @ 03:07:25 PM
Script        : http://www.itech2.net/admincp/user.php?do=update
Referrer      : http://www.itech2.net/admincp/user.php?do=add
IP Address    : 213.207.221.198
Username      : Arman
Classname     : vB_Database
MySQL Version : 5.0.45-community-log

[Opserty]

Check the manual in future, Duplicate entry 'XXX'

[Marco van Herwaarden]

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.

[Opserty]

:erm: Stoopid manual

[Marco van Herwaarden]

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.

[Opserty]

Oh I see. Makes sense

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

[Marco van Herwaarden]

Yes the '4294967295' is the new userid.

[DanielMaidment]

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

[BirdOPrey5]

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?