yellowchaser
05-27-2005, 10:55 PM
Has anyone ever seen these errors? I get them like 10 times a day for some reason:
Invalid SQL:
SELECT
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
, post.pagetext AS preview
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
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(9,36,38,95,23,24,8,44,87,88,89,46,52,53,45,60,6 1,73,74,82,75,76,77,79,80,13,4 7,48,5,14,93,21,18,20,66,69,70,90,91,92) 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 DE
mysql error number: 1064
Invalid SQL:
SELECT
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
, post.pagetext AS preview
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
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(9,36,38,95,23,24,8,44,87,88,89,46,52,53,45,60,6 1,73,74,82,75,76,77,79,80,13,4 7,48,5,14,93,21,18,20,66,69,70,90,91,92) 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 DE
mysql error number: 1064