Log in

View Full Version : database error on email confirm


Xencored
05-04-2009, 01:30 PM
Hi i get this error when someone clicks the email confirm link in the email



Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO 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, May 4th 2009 @ 07:24:09 AM
Error Date : Monday, May 4th 2009 @ 07:24:09 AM
Script : http://www.************ister.php?a=act&u=2&i=aadaf16363f5aaf18784e6db67ef5659896888ff
Referrer : http://bl132w.bl*********/mail/InboxLight.aspx?FolderID=00000000-0000-0000-0000-000000000001&InboxSortAscending=False&InboxSortBy=Date&n=174586079
IP Address : ****
Username : ***
Classname : vB_Database
MySQL Version :

Lynne
05-04-2009, 02:18 PM
I don't think that is a default vb query (there are several like that, but not exactly like that). Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Don't forget that for vbseo, disabling the modification means to also get rid of anything extra you added to your htaccess file.

Xencored
05-04-2009, 02:27 PM
I don't think that is a default vb query (there are several like that, but not exactly like that). Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Don't forget that for vbseo, disabling the modification means to also get rid of anything extra you added to your htaccess file.

Yea Didnt get the error with mods off :erm:
Thanks

edit is there any way to pin point to which one it is ?

--------------- Added 1241451509 at 1241451509 ---------------

Found it so if anyone gets this error the mod causing it is (Automatically Added Friend)

Thanks again lynne my hero ;)