This is the error i am getting... How can I fix this?
Warning: chdir(): No such file or directory (errno 2) in /home/jaydabh/public_html/forum/vbindex.php on line 144
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.dateline DESC
LIMIT 0
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: Saturday 12th of March 2005 04:47:25 PM
|