stuarttunstall
Sat 19th Aug '06, 6:51pm
I have just upgrades my forum to 3.6.0, but get the following message
Database error in vBulletin 3.6.0:
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
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
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)
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(1720,1619,1618,1528,1492,1464,1409,1408,1263,12 52,1251,1204)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 12;
MySQL Error : Unknown column 'post_parsed.styleid_code' in 'on clause'
Error Number : 1054
Date : Saturday, August 19th 2006 @ 10:46:46 PM
Script : http://www.vwaudiforum.co.uk/?
Referrer : http://www.vwaudiforum.co.uk/forum/index.php
IP Address : 84.71.67.3
Username : stuart
Classname : vb_database
I had another error, relating to renaming the postparsed to post_parsed but noe get this error.
My forum works OK if i go direct to it, but my home page fails to show, I am using vbadvanced
Database error in vBulletin 3.6.0:
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
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
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)
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
WHERE thread.threadid IN(1720,1619,1618,1528,1492,1464,1409,1408,1263,12 52,1251,1204)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 12;
MySQL Error : Unknown column 'post_parsed.styleid_code' in 'on clause'
Error Number : 1054
Date : Saturday, August 19th 2006 @ 10:46:46 PM
Script : http://www.vwaudiforum.co.uk/?
Referrer : http://www.vwaudiforum.co.uk/forum/index.php
IP Address : 84.71.67.3
Username : stuart
Classname : vb_database
I had another error, relating to renaming the postparsed to post_parsed but noe get this error.
My forum works OK if i go direct to it, but my home page fails to show, I am using vbadvanced