database error on email confirm

[Xencored]

Hi i get this error when someone clicks the email confirm link in the email

PHP Code:

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]

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

PHP Code:

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]

Originally Posted by Lynne

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

PHP Code:

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 [DATE]1241451509[/DATE] at [TIME]1241451509[/TIME] ---------------

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

Thanks again lynne my hero