PDA

View Full Version : BAD error! plz help me


ehsanix
09-15-2008, 04:10 PM
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
09-15-2008, 04:27 PM
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
09-15-2008, 04:46 PM
thanx dude :)

Eikinskjaldi
09-15-2008, 11:25 PM
The actual error is the "user not in ()"

Lynne
09-16-2008, 01:00 AM
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.