The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
  Learn how to remove ads

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost on GARS - database error also, please help Spiffy Geek Article and Review System 2 04-28-2007 06:41 PM
GARS causes vB database error indie Geek Article and Review System 4 04-06-2007 11:21 PM
Database Error!! PabloAM Geek Article and Review System 1 03-26-2006 08:11 PM
Error after upgrade RC1 Seeker Geek Advertising Banner System 2 02-13-2006 04:52 PM
GAB RC1 Error Site Down Michael-MI Geek Advertising Banner System 6 02-11-2006 09:19 PM


All times are GMT. The time now is 02:03 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.