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 10-06-2006, 06:17 PM
Ramses Ramses is offline
Senior Member
 
Join Date: Dec 2005
Posts: 265
Geek Article and Review System License Holder Geek Gazette License Holder 
Default Link directory db error

On one link directory forum (vb 3.5) if I sort threads by author or memberrating, get this error, on another forum vb 3.6 it's fine, can you give me a hint? Thanks
Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

		SELECT  threadid
			
		FROM vb3_thread AS thread
		 LEFT JOIN vb3_gars as ga ON(ga.threadid = thread.threadid) 
		WHERE forumid = 424
			AND sticky = 0
			 AND visible IN (0,1,2)
			
			
			
			
		ORDER BY sticky DESC, ga.overall_rating DESC
		LIMIT 0, 20;

MySQL Error  : Column 'threadid' in field list is ambiguous
Error Number : 1052
Date         : Friday, October 6th 2006 @ 08:13:24 PM
Script       : http://www.mydomain.de/forum/forumdisplay.php?f=424&daysprune=-1&order=desc&sort=authorrating
Referrer     : http://www.mydomain.de/forum/forumdisplay.php?f=424
IP Address   : 
Username     : me
Classname    : vb_database
memberrating was same only, ORDER BY sticky DESC, ga.avg_rating DESC

Last edited by Ramses; 10-06-2006 at 06:20 PM..
Reply With Quote
  #2  
Old 10-07-2006, 10:50 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 a vb3.5 limitation. Check this out->http://www.thevbgeek.com/showthread.php?t=2047
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
Link Directory popowich Geek Article and Review System 3 07-17-2007 08:01 PM
Link Directory and Filter Tigratrus Geek Article and Review System 6 06-14-2007 03:18 AM
How do i get GARS Link Directory wrang Geek Article and Review System 1 03-08-2007 05:15 PM
Link directory? vnjporg Geek Article and Review System 11 10-10-2006 04:02 PM
Link Directory jwashburn Geek Article and Review System 1 08-29-2006 09:48 PM


All times are GMT. The time now is 09:28 AM.


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