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

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2006, 01: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 01:45 AM..
Reply With Quote
  #2  
Old 06-22-2006, 08:04 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Check out the release thread, I have posted a patch for this issue.

Thanks!
Reply With Quote
  #3  
Old 06-22-2006, 04:54 PM
attroll's Avatar
attroll attroll is offline
Senior Member
 
Join Date: Oct 2005
Posts: 155
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Has this patch been put in the download file yet? I am going to download it tonight after work and try it out. I don't want to download it if there is a patch that needs to go in it.
Reply With Quote
  #4  
Old 06-22-2006, 05:12 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Yes, its in the package (but also attached to the first post in the release thread).

Its a script that runs the database changes that vB skips over thanks to its pants versioning system.

Its in the root of the package (with the readme, license and product.xml). Upload it into your forums directory, broswe to it and then delete it.
Reply With Quote
  #5  
Old 06-22-2006, 05:19 PM
attroll's Avatar
attroll attroll is offline
Senior Member
 
Join Date: Oct 2005
Posts: 155
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Quote:
Originally Posted by The Geek
Yes, its in the package (but also attached to the first post in the release thread).

Its a script that runs the database changes that vB skips over thanks to its pants versioning system.

Its in the root of the package (with the readme, license and product.xml). Upload it into your forums directory, broswe to it and then delete it.
I went and read that after I made the post. Thank you.

I have one concern now though.

Seeing we have to run this script to get this to work. I am wonding now if we wish to remove GARS from our sites how do we remove this script. Is there a way to remove this change it does to the database?
Reply With Quote
  #6  
Old 06-22-2006, 05:25 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

It will run the uninstall, its just the order that vB thinks the execution of the install code steps should be in.

Worst case scenario you will have to manually remove 1 table (or just ignore it).
Reply With Quote
  #7  
Old 06-22-2006, 05:28 PM
attroll's Avatar
attroll attroll is offline
Senior Member
 
Join Date: Oct 2005
Posts: 155
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Quote:
Originally Posted by The Geek
It will run the uninstall, its just the order that vB thinks the execution of the install code steps should be in.

Worst case scenario you will have to manually remove 1 table (or just ignore it).
Thank You.
Reply With Quote
Reply

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 07:41 PM
GARS causes vB database error indie Geek Article and Review System 4 04-07-2007 12:21 AM
Database Error!! PabloAM Geek Article and Review System 1 03-26-2006 09:11 PM
Error after upgrade RC1 Seeker Geek Advertising Banner System 2 02-13-2006 05:52 PM
GAB RC1 Error Site Down Michael-MI Geek Advertising Banner System 6 02-11-2006 10:19 PM


All times are GMT. The time now is 12:54 PM.


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