Registration MySQL error
 

Example error:

***(I added underscores to prevent the URL here getting crawled.)***

I have recently (past day or so) been getting MySQL 1062 errors when a user attempts to register (using intergrated VB3). I just shut off new registrations because I have about 90 of these errors (starting to average 45+ new registrations a day).

About 5 days ago I started to run my PhotoPost along side my forum, but everything had been working fine. The majorty of my users had registered on my previous board (DBM Ikonboard).

In my db, I show the following:

User: 2322 records

Userfield: 3504 records

Usertextfield: 3504 records

The User table appears to have the correct userid, but the Userfield and Usertextfield tables seem to have extra rows and the userid doesn't always correspond the the userid in the User table (but the information appears correctly in the user's profile).

What is the best way to rectify this?

(A new row is added for every registration in the User table.)

I have not altered registration.php (but reuploaded it for good measure). I am running VB 3.0.1, and will upgrade to 3.0.7, but wanted to take care of this first.

Any help is appriciated.

-e

You might do best asking on the Vbulletin support forum for your Vbulletin questions. We support our product here on these forums.