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-02-2006, 01:07 AM
Sykoi Sykoi is offline
Junior Member
 
Join Date: Jun 2006
Posts: 2
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default Not unique table/alias: 'ga'

Hi first off I'd just like to say that I love GAR, I just bought a license and loving it.
However, since I followed the instructions for upgrading it (I was using free version), I have been getting the following MySQL error whenever I try to view an article forum.

Quote:
Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
IF(ga.synopsis, ga.synopsis,post.pagetext) AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
,thread.vbp_titledisplayflags,thread.vbp_titletext color,thread.vbp_titleglowcolor,thread.vbp_titlesh adowcolor,thread.vbp_titlefonttype, ga.header_image, ga.synopsis, ga.byline, ga.feature_untill, ga.pagecount, ga.custom2, ga.header_image, ga.synopsis, ga.byline, ga.feature_untill, ga.pagecount, ga.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 = 1 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) LEFT JOIN vb3_gars as ga ON(ga.threadid = thread.threadid)
WHERE thread.threadid IN (0,20)
ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Not unique table/alias: 'ga'
Error Number : 1066

Date : Thursday, June 1st 2006 @ 07:59:14 PM

- Hide quoted text -
Any help would be appreciated, thanks
Reply With Quote
  #2  
Old 06-02-2006, 06:08 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

do you have another table called ga?
Reply With Quote
  #3  
Old 06-03-2006, 12:01 AM
Sykoi Sykoi is offline
Junior Member
 
Join Date: Jun 2006
Posts: 2
Geek Article and Review System License Holder Geek Advertising Banner License Holder 
Default

Nope sure don't... Like I said, I just installed pay version over top of free version...
Reply With Quote
  #4  
Old 06-03-2006, 08:17 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

do you have gars table there?
Reply With Quote
  #5  
Old 06-06-2006, 02:14 PM
WAR's Avatar
WAR WAR is offline
Member
 
Join Date: Oct 2005
Posts: 34
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder 
Default

Quote:
LEFT JOIN vb3_gars as ga ON(ga.threadid = thread.threadid) LEFT JOIN vb3_gars as ga ON(ga.threadid = thread.threadid)
WHERE thread.threadid IN (0,20)
ORDER BY sticky DESC, thread.lastpost DESC;
Can you use the same alias twice in the same query? It seems to me like that is what the error is referring to. (I marked the section in the snippet above.)
Reply With Quote
  #6  
Old 06-06-2006, 05:23 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

Thats wrong!

For whatever reason, the join has repeated itself twice.

You dont have 2 versions of GARS installed do you?
Reply With Quote
  #7  
Old 06-07-2006, 07:28 PM
gasxtreme gasxtreme is offline
Junior Member
 
Join Date: Jun 2006
Posts: 1
Default

I am getting this error as well, on the one forum I have setup for the MOD.

Any help would be greatly appreciated

EDIT: I think that The Geek is right..... I disabled the plugin (Thus disabling one of the GARS installations), and its working now.

-steve

Last edited by gasxtreme; 06-07-2006 at 07:31 PM..
Reply With Quote
  #8  
Old 06-07-2006, 07:29 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

do you guys have GARS LITE installed by chance?
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
Gars table ? miyukichii Geek Article and Review System 3 06-25-2008 06:17 PM
Table doesn't exist iogames Geek Article and Review System 1 01-09-2008 12:10 AM
Removing table ND4SPD Geek Advertising Banner System 1 02-10-2007 02:28 PM
Table of Contents blackhat Geek Article and Review System 1 01-04-2006 07:45 PM
BUG - Table Borders benFF Geek Article and Review System 4 11-08-2005 09:09 AM


All times are GMT. The time now is 08:42 AM.


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