View Single Post
  #1  
Old 06-22-2006, 12:40 AM
Ramses Ramses is offline
Senior Member
 
Join Date: Dec 2005
Posts: 265
Geek Article and Review System License Holder Geek Gazette License Holder 
Default Help GARS RC1 database error

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.synopsisga.synopsis,post.pagetext) AS preview,
            
thread.threadidthread.title AS threadtitlethread.forumidpollidopenreplycountpostusernamepostuseridthread.iconid AS threadiconid,
            
thread.lastpostlastposterthread.dateline, IF(views<=replycountreplycount+1views) AS viewsnotesthread.visiblestickyvotetotalthread.attach,
            
hiddencount
            
NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
            
deletionlog.userid AS del_useriddeletionlog.username AS del_usernamedeletionlog.reason AS del_reason
            
ga.header_imagega.synopsisga.bylinega.feature_untillround((ga.overall_rating/10),0author_ratingga.rating_countga.overall_rating author_rating_percent,round((ga.avg_rating/10),0member_ratingga.avg_rating member_rating_percentga.pagecountga.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 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 DESCthread.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.

Last edited by Ramses; 06-22-2006 at 12:45 AM..
Reply With Quote