jzewatsky
04-22-2005, 08:16 PM
Hi all. Just wondering if anyone can help me track down this SQL error. I think it's comming from my CMPS page. No users have complained so I dont think their seeing the error and I have no additional way to track it down. I'm hopeing that someone recognizes the code. Thanks in advance for your help.
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND
votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, thread.replycount, postusername,
postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount,
thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
FROM thread as thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid
= deletionlog.primaryid AND type = 'thread')
WHERE open <> '10' AND thread.visible = 1 AND
thread.forumid NOT IN(27,52,55,54,13,14,26,33,51,38) Array AND
deletionlog.primaryid IS NULL
ORDER BY lastpost 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 'Array
AND deletionlog.primaryid IS NULL
ORDER BY lastpost D
mysql error number: 1064
Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND
votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, thread.replycount, postusername,
postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount,
thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
FROM thread as thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid
= deletionlog.primaryid AND type = 'thread')
WHERE open <> '10' AND thread.visible = 1 AND
thread.forumid NOT IN(27,52,55,54,13,14,26,33,51,38) Array AND
deletionlog.primaryid IS NULL
ORDER BY lastpost 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 'Array
AND deletionlog.primaryid IS NULL
ORDER BY lastpost D
mysql error number: 1064