vBadvanced Forums  
Go Back   vBadvanced Forums > vBadvanced Products > vBadvanced Links Directory > vBa Links Directory v2.0 Support > Troubleshooting & Problems

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2007, 10:53 AM
Shelby Shelby is offline
Senior Member
 
Join Date: Nov 2005
Posts: 127
Default Unknown column 'links.rating' in 'order clause'

Having an error.

Code:
Database error in vBulletin 3.6.4:

Invalid SQL:

			SELECT  links.linkid
			FROM adv_links AS links 
			
			WHERE links.valid = 1
				AND links.suspended = 0
				 ORDER BY links.rating DESC LIMIT 20;

MySQL Error  : Unknown column 'links.rating' in 'order clause'
Error Number : 1054
Date         : Sunday, January 7th 2007 @ 06:08:37 AM
Script       : http://www.warhammeralliance.net/links/showlink.php?do=showdetails&l=5&goto=next&catid=poplinks
Referrer     : 
IP Address   : 66.249.72.133
Username     : Unregistered
Classname    : vB_Database

Last edited by Shelby; 01-08-2007 at 10:19 PM.
Reply With Quote
  #2  
Old 01-08-2007, 02:15 PM
Brian's Avatar
Brian Brian is offline
Administrator
 
Join Date: Jan 2004
Location: Georgia, USA
Posts: 34,240
Default Re: Unknown column 'links.rating' in 'order clause'

Before asking for support, the copyright notice in your adv_links_footer template either needs to be restored, or a branding free license purchased.
Reply With Quote
  #3  
Old 01-08-2007, 10:20 PM
Shelby Shelby is offline
Senior Member
 
Join Date: Nov 2005
Posts: 127
Default Re: Unknown column 'links.rating' in 'order clause'

The notice is still there, it's just not in the adv_links_footer.

Still reciving the error.

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT links.linkid
FROM adv_links AS links

WHERE links.valid = 1
AND links.suspended = 0
ORDER BY links.rating DESC LIMIT 20;

MySQL Error : Unknown column 'links.rating' in 'order clause'
Error Number : 1054
Date : Monday, January 8th 2007 @ 10:13:47 AM
Script : http://warhammeralliance.com/links/s...catid=poplinks
Referrer :
IP Address : 67.191.183.38
Username : Unregistered
Classname : vB_Database
Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT links.linkid
FROM adv_links AS links

WHERE links.valid = 1
AND links.suspended = 0
AND catid = 3 ORDER BY links.rating ASC;

MySQL Error : Unknown column 'links.rating' in 'order clause'
Error Number : 1054
Date : Tuesday, January 9th 2007 @ 11:51:19 AM
Script : http://www.warhammeralliance.com/lin...evious&catid=3
Referrer :
IP Address : 66.249.72.68
Username : Unregistered
Classname : vB_Database

Last edited by Shelby; 01-09-2007 at 04:03 PM.
Reply With Quote
  #4  
Old 01-09-2007, 04:54 PM
Brian's Avatar
Brian Brian is offline
Administrator
 
Join Date: Jan 2004
Location: Georgia, USA
Posts: 34,240
Default Re: Unknown column 'links.rating' in 'order clause'

Thank you for restoring that.

Have you modified your files in any way? There shouldn't be any way you would receive that error with the default files. I would suggest downloading the package again and replacing your current files with the ones in there just to be sure they are the most current ones. If you still receive the error after that, please submit a support ticket via the Members' Area here.
Reply With Quote
  #5  
Old 01-09-2007, 06:01 PM
Shelby Shelby is offline
Senior Member
 
Join Date: Nov 2005
Posts: 127
Default Re: Unknown column 'links.rating' in 'order clause'

The issue is with the issue is with the "next" and "previous" links.

I recieve this error.

Quote:
Sorry - no matches. Please try some different terms. %1$s
I redownloaded and uploaded the showlink.php and still get the same error.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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
Unknown column 'language.phrasegroup_adv_portal_cp' pennylessz28 Troubleshooting & Problems 4 10-13-2006 05:04 PM
DB Error: Unknown column 'phrasegroup_adv_links' Freesteyelz Troubleshooting & Problems 5 09-09-2006 08:18 AM
MySQL Error: 1052 : Column 'dateline' in order clause is ambiguous Bailx Troubleshooting & Problems 8 08-23-2006 04:55 PM
Column 'iconid' in from clause is ambiguous stitch Troubleshooting & Problems 2 11-16-2005 05:44 PM


All times are GMT -4. The time now is 02:17 AM.

Forums Powered by vBulletin, Copyright ©2000-2009, Jelsoft Enterprises Ltd.
Please note that vBadvanced is in no way affiliated with Jelsoft Enterprises Ltd, nor will Jelsoft be able to provide any support for our products.