After upgrading to RC1 (reimported product and used the count re-sync tool) got following db error on the forumdisplay:
PHP Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
SELECT IF(ga.synopsis, ga.synopsis,post.pagetext) AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, ga.header_image, ga.synopsis, ga.byline, ga.feature_untill, round((ga.overall_rating/10),0) author_rating, ga.rating_count, ga.overall_rating author_rating_percent,round((ga.avg_rating/10),0) member_rating, ga.avg_rating member_rating_percent, ga.pagecount, ga.custom2
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb3_gars as ga ON(ga.threadid = thread.threadid)
WHERE thread.threadid IN (0,971,966,914,902,869,871,870,868,850,833)
ORDER BY sticky DESC, thread.lastpost DESC;
[B]MySQL Error : Unknown column 'ga.rating_count' in 'field list'[/B]
Error Number : 1054
The thread display is fine. And need to say there's the same error on a forum where no ratings are given.