vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=175516

Error each time a new user register
by desmomax
08 Apr 2008 14:29

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

snakes1100 08 Apr 2008 14:35

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

MoT3rror 08 Apr 2008 14:56

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

snakes1100 08 Apr 2008 15:16

This is a typical issue after using impex to import a forum, the repair should fix the issue for you.


All times are GMT. The time now is 12:16.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.