I have an SQL error on my forum index page and havent a clue what to do.

The rest of the site works fine, but the index page - www.clubbers-united.com/forums - leads me to this...

Database error in vBulletin 3.0.7:
Invalid SQL: SELECT thread.threadid,thread.title,thread.postusername,t hread.postuserid,thread.replycount,thread.views FROM thread AS thread WHERE forumid NOT IN () ORDER BY replycount 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 replycount DESC LIMIT 10' at line 1
mysql error number: 1064
Date: Tuesday 03rd of May 2005 12:44:55 PM
Script: http://www.clubbers-united.com/forums/index.php?

Which points to a thread problem, but the thread pages are all working normally. I'm not too clued up on it all but thought this could be a good place to ask for help.

I've installed a couple of hacks in the last couple of days.
Sunday -> Who Was Online Today = successfully
Today, around an hour before the error came -> Who Has Viewed This Thread = unsuccessfully, taken off and data changed back.

I added one query also on Sunday for the hack above.

Everything has been working fine, and the last action taken on any staff level was the member group changing of one member.

I'm stumped. Any help is much appreciated. Thanks.

What ever it is, its an error in your index.php file. So what ever hack you added that edited the index.php file is the problem.

-Moved to correct forum-

hmm you forgot the WHERE forumid NOT IN ()

there ya must enter the forumid where not counting the query

like
WHERE forumid NOT IN (1,2,3)