[CaptainAwesome]

I haven't made the changes you mentioned ozzy as i thought i would post the error first. I'm a total newbie at this stuff and want to avoid creating more problems.

I went and set up the error reporting thing (told you i was a newbie!) and recreated the problem. This is what i was emailed. I removed my IP and site address, but everything else is everything i got sent to me:

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO userfield
(field7, field8, userid)
VALUES
('Yes', 'Yes', 50966);

MySQL Error : Duplicate entry '50966' for key 'PRIMARY'
Error Number : 1062
Request Date : Saturday, August 23rd 2014 @ 05:56:20 PM
Error Date : Saturday, August 23rd 2014 @ 05:56:21 PM
Script : http://<site>/forum/newsignup.php?do=addmember
Referrer : http://<site>/forum/newsignup.php?do=checkdate
IP Address : <IP address>
Username : test4
Classname : vB_Database
MySQL Version :