Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 08-19-2008, 08:27 PM
Arman Dinarvand Arman Dinarvand is offline
 
Join Date: Nov 2007
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Code:
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
Reply With Quote
  #2  
Old 08-19-2008, 08:48 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Check the manual in future, Duplicate entry 'XXX'
Reply With Quote
  #3  
Old 08-20-2008, 06:05 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 08-20-2008, 08:00 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

:erm: Stoopid manual
Reply With Quote
  #5  
Old 08-20-2008, 08:44 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 08-20-2008, 11:52 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oh I see. Makes sense

So the "4294967295" is the next userid (I assume)? 4 billion users does seem a lot.
Reply With Quote
  #7  
Old 08-20-2008, 01:28 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes the '4294967295' is the new userid.
Reply With Quote
  #8  
Old 11-06-2010, 11:31 PM
DanielMaidment DanielMaidment is offline
 
Join Date: May 2010
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im having this problem with my forum currently - we dont know how to stop this happening ? - soooo annoying
Reply With Quote
  #9  
Old 11-07-2010, 12:28 AM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:37 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04004 seconds
  • Memory Usage 2,228KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete