Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1
AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, post.title, thread.replycount, postusername,
postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost,
IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid,
pagetext, allowsmilie
,thread.iconid AS threadiconid, iconpath AS threadiconpath
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN post_parsed AS post_parsed ON (post_parsed.postid =
post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND
post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
WHERE thread.threadid IN(1841,1840,1839,1842,1838,1836)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 6;
Get this error after playing a tournament.
Any idea What caused this problem
|