| rob01 |
12-23-2008 10:55 PM |
Code:
Database error in vBulletin 3.8.0 Release Candidate 2:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
, allowsmilie, pagetext_html, postparsed.hasimages, thread.iconid AS threadiconid, iconpath AS threadiconpath, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vbb_thread AS thread
LEFT JOIN vbb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vbb_user AS user ON (user.userid = post.userid)
LEFT JOIN vbb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1) LEFT JOIN vbb_icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN vbb_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vbb_customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN vbb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(41,39,38,36,34,33,32,24,22,21)
AND thread.dateline > 1222304002
any idea? |
More Information