|
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 |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL Error | JonnyF | Geek Article and Review System | 4 | 07-09-2007 08:50 PM |
SQL error | trana | Geek Article and Review System | 1 | 12-12-2006 10:49 PM |
Big SQL error after reinstall | utw-Mephisto | Geek Article and Review System | 1 | 07-14-2006 06:46 AM |
Weird SQL Error when trying to go to "Next Article" | Mithan | Geek Article and Review System | 2 | 07-11-2006 05:55 PM |
GAB Issue Mark All Forums Read SQL Error | Michael-MI | Geek Advertising Banner System | 2 | 02-12-2006 04:07 PM |