Jitsu
02-09-2008, 02:22 PM
Hello guys, I'm sorry my first post is to report an error but nevertheless . . .
I get the following Database error after setting the Thread Display Order in the News Module to Rating.
When reverting back to Date Created all is in order, only with this setting everything breaks.
Is this my fault or what? I did a clean install of the vBadvanced.
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, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb_thread AS thread
LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_user AS user ON (user.userid = post.userid)
LEFT JOIN vb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 6 AND postparsed.languageid = 1) LEFT JOIN vb_icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '11')
WHERE thread.threadid IN(977,982,868,964)
ORDER BY thread.voteavg DESC
LIMIT 7;
MySQL Error : Unknown column 'thread.voteavg' in 'order clause'
Error Number : 1054
I get the following Database error after setting the Thread Display Order in the News Module to Rating.
When reverting back to Date Created all is in order, only with this setting everything breaks.
Is this my fault or what? I did a clean install of the vBadvanced.
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, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb_thread AS thread
LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_user AS user ON (user.userid = post.userid)
LEFT JOIN vb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 6 AND postparsed.languageid = 1) LEFT JOIN vb_icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '11')
WHERE thread.threadid IN(977,982,868,964)
ORDER BY thread.voteavg DESC
LIMIT 7;
MySQL Error : Unknown column 'thread.voteavg' in 'order clause'
Error Number : 1054