I am having a Mysql db problem with the vbindex.php file, everything else works just fine. This is on a fresh install with only some changes made. I get:
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,
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM elitedue_thread AS thread
LEFT JOIN elitedue_user AS user ON (thread.postuserid = user.userid)
LEFT JOIN elitedue_post AS threadpost ON (thread.firstpostid = threadpost.postid)
LEFT JOIN elitedue_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN elitedue_customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN elitedue_avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN elitedue_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
WHERE forumid IN (Announcements)
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 6
mysql error: Unknown column 'Announcements' in 'where clause'
When I visit the page...Help?
|