vBadvanced Forums  
Go Back   vBadvanced Forums > vBadvanced Products > vBadvanced Links Directory > vBa Links Directory v3.0 Support > Bugs & Issues > Bugs From 3.1.0

Reply
 
Thread Tools Display Modes
  #1  
Old 04-08-2009, 03:21 PM
tupeu tupeu is offline
Junior Member
 
Join Date: Aug 2007
Posts: 10
Default SQL search error

Hi, i get emails on my server about SQL errors with vBadvanced Links Directory

My server is a VPS running on Fedora 7
I use vBulletin 3.8.2

It seems when a search is done there is an SQL error:

Database error in vBulletin 3.8.2:

Code:
Invalid SQL:

                        SELECT links.linkid
                        FROM adv_links AS links
                       
                       
                        WHERE ( MATCH(links.name) AGAINST ('+linux*' IN BOOLEAN MODE) OR MATCH(links.description) AGAINST ('+linux*' IN BOOLEAN MODE) OR MATCH(links.keywords) AGAINST ('+linux*' IN BOOLEAN MODE)) AND  links.valid = 1
                ORDER BY links.rating ASC LIMIT 500;

MySQL Error   : Unknown column 'links.rating' in 'order clause'
Error Number  : 1054
Request Date  : Wednesday, April 8th 2009 @ 05:46:08 PM
Error Date    : Wednesday, April 8th 2009 @ 05:46:09 PM
Script        : http://site.com/links/search.php?do=...search=1&tag=1
Referrer      : http://site.com/links/e-learning-5/linuxtracker--328/
IP Address    : xx.xxx.xxx.xx
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
PS I tried to read some similar topics but is seems i don`t have permission:

http://www.vbadvanced.com/forum/showthread.php?t=23824

http://www.vbadvanced.com/forum/showthread.php?t=32052

Last edited by tupeu; 04-08-2009 at 03:40 PM.
Reply With Quote
  #2  
Old 04-08-2009, 05:29 PM
Brian's Avatar
Brian Brian is offline
Administrator
 
Join Date: Jan 2004
Location: Georgia, USA
Posts: 32,349
Default

Thank you for pointing this out. It looks like there was a small issue that could occur when searching tags if you have your 'Default Links Order' option set to 'Rating'. I've just updated the links/search.php file in the download package here to include the fix, so if you will download the files again and upload that file to your server over the existing one, that should take care of the issue.
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
SQL error with search.php Moonz0r Troubleshooting & Problems 5 10-22-2008 11:22 AM
search error BWJ Bugs From 3.0 Beta 2 5 06-02-2008 04:18 PM
Search Error On VB 3.7 snerd Troubleshooting & Problems 0 01-31-2008 08:43 PM
Search SQL Error ManagerJosh Bugs From 1.0 RC1 17 08-25-2007 12:57 PM
Search Error absolutepunknet Troubleshooting & Problems 0 03-22-2006 05:06 PM


All times are GMT -4. The time now is 03:55 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.