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 12-12-2006, 05:50 PM
Scribbller Scribbller is offline
Junior Member
 
Join Date: Dec 2006
Posts: 27
Geek Article and Review System License Holder 
Default SQL error

I installed GARS and it worked fine but when I setup the GARS VBA module made by The Geek I am getting this error on my cmps page

Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT g.threadid,g.header_image image, p.title, g.byline, IF(g.synopsis, g.synopsis, p.pagetext) synopsis ,g.pagecount, g.custom2 1 FROM
            vb3_gars g
             INNER JOIN vb3_gars_custom_values gsv ON gcv.custom_threadid = g.threadid 
                        INNER JOIN vb3_thread t ON g.threadid = t.threadid
            INNER JOIN vb3_post p ON t.firstpostid = p.postid
            WHERE t.visible = 1 AND t.open != 10
             AND t.forumid in (1) 
            
            ORDER BY RAND() LIMIT 3;

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '1 FROM
            vb3_gars g
             INNER JOIN vb3_gars_
Error Number : 1064
Date         : Tuesday, December 12th 2006 @ 12:48:42 PM
Script       : http://www.nauman.info/cmps_index.php
Referrer     : 
IP Address   : 203.81.199.24
Username     : Nauman
Classname    : vb_database
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
SQL Error JonnyF Geek Article and Review System 4 07-09-2007 09:50 PM
SQL error trana Geek Article and Review System 1 12-12-2006 11:49 PM
Big SQL error after reinstall utw-Mephisto Geek Article and Review System 1 07-14-2006 07:46 AM
Weird SQL Error when trying to go to "Next Article" Mithan Geek Article and Review System 2 07-11-2006 06:55 PM
GAB Issue Mark All Forums Read SQL Error Michael-MI Geek Advertising Banner System 2 02-12-2006 05:07 PM


All times are GMT. The time now is 11:20 AM.


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