Log in

View Full Version : Database Error


PHILLYFAN
01-17-2009, 06:55 AM
Out of the blue, when people register to my site they fill out everything and hit send the white data base error screen comes up and then i get this in my email

Database error in vBulletin 3.7.3:

Invalid SQL:
INSERT INTO userlist (userid, relationid, type, friend) VALUES (420, , '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 ' 'buddy', 'yes')' at line 1
Error Number : 1064
Request Date : Friday, January 16th 2009 @ 09:42:06 PM
Error Date : Friday, January 16th 2009 @ 09:42:07 PM
Classname : vB_Database
MySQL Version :

Anyone know what I can do to fix this?
Thanks!

vbplusme
01-17-2009, 11:24 AM
Looks like a field data point is missing or an extra comma is in the query. You got this from the registration form? Are you running the hack that automatically adds a friend ? If so, try to disable it and see if the problem goes away. In any event, sounds like it might be a hack that is causing the problem. You can also disable hooks to see if the problem goes away. If it does then you just need to find out which one by diabling them all and re-enabling them one at a time until you find the badboy. HTH

Dismounted
01-17-2009, 11:45 AM
Please place this at the end of your config.php to disable all modifications:
define('DISABLE_HOOKS', true);

PHILLYFAN
01-17-2009, 04:16 PM
Looks like a field data point is missing or an extra comma is in the query. You got this from the registration form? Are you running the hack that automatically adds a friend ? If so, try to disable it and see if the problem goes away.

That fixed it right there! Thanks for the help! Also, thanks dismounted for also trying to help!
Again Thanks!
philly