The Itchy One
11-10-2006, 10:24 PM
Hi, i recently upgraded the system to 3.6.2 and upgraded Vba Along with it, i am now seeing this error
Database error in vBulletin 3.6.3:
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
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) 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 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 user AS user ON (user.userid = post.userid)
LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
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 = '47')
WHERE thread.threadid IN(19876,19848,19844,19828,19822)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 5;
MySQL Error : Table 'ultimate_forums.post_parsed' doesn't exist
Error Number : 1146
Date : Friday, November 10th 2006 @ 06:20:18 PM
Script : http://www.nurseserver.com/
Referrer :
IP Address : 82.153.196.115
Username : shortbus
Classname : vb_database
Any help would be greatly appreciated
Database error in vBulletin 3.6.3:
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
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(filedata) 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 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 user AS user ON (user.userid = post.userid)
LEFT JOIN usertextfield AS usertextfield ON (post.userid = usertextfield.userid)
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 = '47')
WHERE thread.threadid IN(19876,19848,19844,19828,19822)
GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline DESC
LIMIT 5;
MySQL Error : Table 'ultimate_forums.post_parsed' doesn't exist
Error Number : 1146
Date : Friday, November 10th 2006 @ 06:20:18 PM
Script : http://www.nurseserver.com/
Referrer :
IP Address : 82.153.196.115
Username : shortbus
Classname : vb_database
Any help would be greatly appreciated