broke my new user email registration activation code system. 3.7.3. new user would get this error page on clicking the activation link in the email, but not be moved into Registered Users group
Database error in vBulletin 3.7.3:
Invalid SQL:
INSERT INTO vb_userlist (userid, relationid, type, friend) VALUES (, 1, 'buddy', 'yes');
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 'buddy', 'yes')' at line 1
Error Number : 1064
Request Date : Monday, October 27th 2008 @ 12:41:54 PM
Error Date : Monday, October 27th 2008 @ 12:41:55 PM
Script :
http://cleanboxentertainment.com/vb/...229&i=84073303
MySQL Version : 4.1.21-Max-log
disabling the plugin fixed it