This is a great mod but it does not work with Vbadvance. I got a mysql error message when i went to visit my front page.
I installed product, did the template edits, then i went to go to my front page and got the following error.
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, showsignature, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usertextfield.signature, 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 thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 9 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON (sigparsed.userid = user.userid AND sigparsed.styleid = 9 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON (sigpic.userid = post.userid)
LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid) LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(41,4,3)
AND thread.dateline > 1222907756
ORDER BY thread.dateline DESC
LIMIT 10;
MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 30th 2008 @ 06:35:56 PM
Error Date : Tuesday, December 30th 2008 @ 06:35:56 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
I then wanted to make sure that this was because of this mod so i disabled the product still got the error, i then went to uninstall it and that corrected everything.
I'm loving this mod! Thanks for it. I'd having one bug with it using Vbulletin 3.8.2.... for some reason my stats won't show on the home page. I'm able to vote on profiles but not see who the top rated person is.
This is a great mod but it does not work with Vbadvance. I got a mysql error message when i went to visit my front page.
I installed product, did the template edits, then i went to go to my front page and got the following error.
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, showsignature, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usertextfield.signature, 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 thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 9 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON (sigparsed.userid = user.userid AND sigparsed.styleid = 9 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON (sigpic.userid = post.userid)
LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid) LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(41,4,3)
AND thread.dateline > 1222907756
ORDER BY thread.dateline DESC
LIMIT 10;
MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 30th 2008 @ 06:35:56 PM
Error Date : Tuesday, December 30th 2008 @ 06:35:56 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
I then wanted to make sure that this was because of this mod so i disabled the product still got the error, i then went to uninstall it and that corrected everything.
I am using the latest version of vb 3.8
Please help.
Yes confirmed as well. I just removed the mod and the problem is gone. Quite simply do not use this mod if you have vbadvanced installed