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
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 01-03-2008, 11:48 AM
jiggle jiggle is offline
Junior Member
 
Join Date: Jan 2008
Posts: 14
Geek Article and Review System License Holder 
Default Database Error

after upgrade from gars lite i get this:

Datenbankfehler in vBulletin 3.6.8:

Quote:
Invalid SQL:

SELECT 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, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, ga.header_image, ga.synopsis, ga.byline, ga.feature_untill, ga.pagecount, ga.custom2, ga.header_image, ga.synopsis, ga.byline, ga.feature_untill, round((ga.overall_rating/10),0) author_rating, ga.rating_count, ga.overall_rating author_rating_percent, round((ga.avg_rating/10),0) member_rating, ga.avg_rating member_rating_percent, ga.pagecount, ga.custom2
FROM forumthread AS thread
LEFT JOIN forumdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN forumsubscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN forumpost AS post ON(post.postid = thread.firstpostid)

LEFT JOIN forumthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN forumgars as ga ON(ga.threadid = thread.threadid) LEFT JOIN forumgars as ga ON(ga.threadid = thread.threadid)
WHERE thread.threadid IN (0,31278,31272,31270,31163)
ORDER BY sticky DESC, lastpost DESC;

MySQL-Fehler : Not unique table/alias: 'ga'
Fehler-Nr. : 1066
Reply With Quote
  #2  
Old 01-03-2008, 11:54 AM
jiggle jiggle is offline
Junior Member
 
Join Date: Jan 2008
Posts: 14
Geek Article and Review System License Holder 
Default

fixed, i deactivated gars lite
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
database error beduino Geek Gazette 1 06-24-2008 06:43 PM
Database error? cookiepants Geek Article and Review System 3 10-20-2006 08:46 PM
Database error vitoreis Geek Article and Review System 5 10-01-2006 10:29 PM
Database error good2laugh Geek Article and Review System 1 08-27-2006 08:35 AM
database error agiacosa Geek Auto-Linker 7 10-15-2005 06:19 PM


All times are GMT. The time now is 04:47 AM.


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