Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Apr 2008, 14:29
desmomax desmomax is offline
 
Join Date: Mar 2008
Error each time a new user register

I moved my database from snitz to vbulletin with the soft provided with vbulletin

but i receive an error report EACH time a new user register to my forum,
the problem is that the forum report an error and the registering procedure stop so i dont receive notification etc..

here is the error:
Database error in vBulletin 3.6.9:


Invalid SQL:
INSERT INTO userfield
(field2, userid)
VALUES
('roccella jonica', 1510);


MySQL Error : Duplicate entry '1510' for key 1
Error Number : 1062
Date : Tuesday, April 8th 2008 @ 12:11:06 PM
Script : http://www.ilbraccoitaliano.net/foru...p?do=addmember
Referrer : http://www.ilbraccoitaliano.net/foru...p?do=addmember
IP Address : 79.3.115.80
Username : cris
Classname : vB_Database_MySQLi




can some one help me?

thanx
Reply With Quote
  #2  
Old 08 Apr 2008, 14:35
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Use phpmyadmin and run a repair a couple times.

or

If you have ssh access to run mysql commands as the above remedy didnt work:
cd to you db folder - typically /var/lib/mysql/dbfoldernamehere
myisamchk -r *
myisamchk -o *
then run a repair using phpmyadmin
Reply With Quote
  #3  
Old 08 Apr 2008, 14:56
MoT3rror MoT3rror is offline
 
Join Date: Mar 2007
It looks like your autoincrement values are off. You can use phpmyadmin to examine the database and set the appropriate autoincrement value for the user table. Or the vbulletin team can do this for you if you submit a trouble ticket with a URL and login to phpmyadmin:

http://members.vbulletin.com/members...ontactform.php
Reply With Quote
  #4  
Old 08 Apr 2008, 15:16
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
This is a typical issue after using impex to import a forum, the repair should fix the issue for you.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 14:38.

Layout Options | Width: Wide Color: