[ehsanix]

How can I fix this error:

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT
u.username,
u.userid,
u.joindate,
u.reputation,
u.usergroupid,
u.ipoints, u.post_thanks_user_amount,
u.posts
FROM user as u
WHERE xperience_done=0 AND userid NOT IN();

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 ')' at line 10
Error Number : 1064
Request Date : Monday, September 15th 2008 @ 09:51:27 PM
Error Date : Monday, September 15th 2008 @ 09:51:28 PM
Script : http://www.****.com/cron.php?rand=396652
Referrer : http://www.****.com/forumdisplay.php?f=125
IP Address : 78.109.204.180
Username : unregister
Classname : vB_Database
MySQL Version :

[Lynne]

This is an error from a modification you have installed. Default vbulletin does not have a field called "xperience_done" You'll need to find out which modification it is and then post in the modification thread for help fixing the error.

[ehsanix]

thanx dude

[Eikinskjaldi]

The actual error is the "user not in ()"

[Lynne]

Originally Posted by Eikinskjaldi

The actual error is the "user not in ()"

Sure, but none of that query exists in default vb. That whole query is from a modification, so he needs to talk to the author and get it fixed.