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.

This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 01-03-2008, 10: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:

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( = 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

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 05:43 PM
Database error? cookiepants Geek Article and Review System 3 10-20-2006 07:46 PM
Database error vitoreis Geek Article and Review System 5 10-01-2006 09:29 PM
Database error good2laugh Geek Article and Review System 1 08-27-2006 07:35 AM
database error agiacosa Geek Auto-Linker 7 10-15-2005 05:19 PM

All times are GMT. The time now is 10:59 AM.

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