Results 1 to 2 of 2

Thread: SQL search error

  1. #1
    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 04:40 PM.

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SQL error with search.php
    By Moonz0r in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 10-22-2008, 12:22 PM
  2. search error
    By BWJ in forum Bugs From 3.0 Beta 2
    Replies: 5
    Last Post: 06-02-2008, 05:18 PM
  3. Search Error On VB 3.7
    By snerd in forum Troubleshooting & Problems
    Replies: 0
    Last Post: 01-31-2008, 09:43 PM
  4. Search SQL Error
    By ManagerJosh in forum Bugs From 1.0 RC1
    Replies: 17
    Last Post: 08-25-2007, 01:57 PM
  5. Search Error
    By absolutepunknet in forum Troubleshooting & Problems
    Replies: 0
    Last Post: 03-22-2006, 06:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •