[EscortCossie]

I have read a lot of the pages in this thread and I still can't see one single answer to the database error many people suffer from.

Here it is once again.. Please help.

Database error in vBulletin 3.0.6:

Invalid SQL: 
		## GET NEWS ##
		SELECT thread.*,thread.iconid AS threadiconid, threadpost.pagetext AS pagetext,
		threadpost.attach AS attachcount,
		avatarpath, NOT ISNULL(avatardata) AS customavatar, user.avatarrevision, customavatar.dateline AS customdateline,
		
		IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
		FROM thread AS thread
		LEFT JOIN user AS user ON (thread.postuserid = user.userid)
		LEFT JOIN post AS threadpost ON (thread.firstpostid = threadpost.postid)
		LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
		
		LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
		LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
		
		WHERE forumid IN ()
		AND deletionlog.primaryid IS NULL
		AND forumid NOT IN (0)
		AND thread.open <> 10
		AND thread.visible = '1'
		
		
		ORDER BY thread.sticky DESC, thread.dateline DESC
		LIMIT 5
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 ')
		AND deletionlog.primaryid IS NULL
		AND forumid NOT IN (0

mysql error number: 1064

Date: Wednesday 23rd of March 2005 02:38:15 PM
Script: http://www.escortpower.net/vbindex.php?
Referer: http://www.escortpower.net/vbindex.php?styleid=6