Hello, i've read through the thread but cant find a solution to this error that i am getting...
Database error in vBulletin 3.0.0:
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,32)
AND thread.open <> 10
AND thread.visible = '1'
ORDER BY thread.sticky DESC, thread.dateline DESC
LIMIT 10
mysql error: You have an error in your SQL syntax near ')
AND deletionlog.primaryid IS NULL
AND forumid NOT IN (0,32)
AND threa' at line 16
mysql error number: 1064
Date: Tuesday 04th of May 2004 11:55:15 PM
Script: x
Referer: x
Username: x
IP Address: x
Hope you can help.
|