registration database error please help me!!!

[jackbanny173]

every time a member registers i get a email sent to me with the database error

i get this email sent to me,

Database error in vBulletin 3.6.5:

Invalid SQL:
INSERT INTO userfield
(field7, userid)
VALUES
('Male', 1695);

MySQL Error : Duplicate entry '1695' for key 1
Error Number : 1062
Date : Saturday, March 10th 2007 @ 01:53:30 PM
Script :
http://www.music-driveby.co.uk/forum/register.php?do=addmember
Referrer :
http://www.music-driveby.co.uk/forum/register.php?do=register
IP Address : 81.97.98.208
Username : testing12
Classname : vb_database






when a member registers this after they fill in there details and press register they get this error message,

Database error
The Music-DriveBy Forum database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.music-driveby.co.uk home page, then try to open another page.
Click the Back button to try another link.

The www.music-driveby.co.uk forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.



Please can some one help me out if some one help me i will pay you money ?10 please let me know thank you

[TTG]

You'll find the answer here (http://www.vbulletin.com/docs/html/mysql_duplicatekey)

[jackbanny173]

i ran all the queries in vbulletin took me about 15 mins. i then signed out and registered again and it worked perfect! BUT after about 5 min i registered again just to make sure i got the exact same message. :( i didnt remove all my plugins tho should i remove them all i really dont want to do this tho. thanks for your reply

[Marco van Herwaarden]

What has happened before these problems started?

I suspect you restored one or more tables at a time, instead of restoring the full database.