database error :( please help
 

Hi all here?s what I?m trying to do I have created a usergroup that is for questioning before banned. This usergroup has only permissions to view a pacific hidden section the rest of the forum permissions are set to no. this was working fine for many months now I found that any user on this usergroup receives DB error.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT u.username,u.userid,t.title,t.threadid
FROM thread AS t
LEFT JOIN user AS u ON (t.postuserid=u.userid)
WHERE forumid IN()
ORDER BY dateline DESC
LIMIT 10;

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 ')
ORDER BY dateline DESC
LIMIT 10' at line 4

I've already made a post on vb.com and been asked to disable all hooks and I've tried disabling plugins. I hope some can help me here :)

Error Number : 1064

So you're sure that disabling all plugins doesn't make the error go away? Do you have any custom php files? I can't find that query anywhere in the code (I'm assuming you pasted it into your post and didn't retype it with different spacing or anything), so I think it would have to be a mod of some kind.

ETA: does it only happen on a certain page?

No custom PHP files. Basically any user on this usergroup when they login receive database error

--------------- Added [DATE]1379102371[/DATE] at [TIME]1379102371[/TIME] ---------------

so sorry buddy just noticed this Please don't PM me - post your questions in the appropriate forum.
Please don't PM me to ask me to read your thread.