Results 1 to 3 of 3

Thread: Database Error: Unknown column 'links.rating'

  1. #1

    Default Database Error: Unknown column 'links.rating'

    Hi,
    I upgraded to the latest links directory, now I am getting this error via Email:

    Code:
    Database error in vBulletin 3.8.1:
    
    Invalid SQL:
    
    				SELECT  links.linkid
    				FROM rife_adv_links AS links
    				
    				WHERE links.valid = 1
    					 AND userid = 1
    				ORDER BY links.rating DESC;
    
    MySQL Error   : Unknown column 'links.rating' in 'order clause'
    Error Number  : 1054
    Request Date  : Friday, February 13th 2009 @ 01:42:03 AM
    Error Date    : Friday, February 13th 2009 @ 01:42:03 AM
    Script        : http://www.rifeforum.com/links/showlink.php?l=22&goto=next&catid=member&orderby=directory&linkuserid=1
    Referrer      : 
    IP Address    : 77.88.25.27
    Username      : Unregistered
    Classname     : vB_Database_MySQLi
    MySQL Version :
    How do I fix this?

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

    Default

    Thank you for pointing this out. I'm guessing somebody followed an old link to produce that error. I've updated the forum/includes/vba_links_plugin_sf.php file here to add some code that will prevent that error, so if you'll download the files from here again and update that one on your server, that should take care of the issue.

  3. #3
    Join Date
    Apr 2005
    Posts
    6

    Default

    Bug in search.php:
    PHP Code:
    Database error in vBulletin 3.8.1:

    Invalid SQL:

                
    SELECT links.linkid
                FROM adv_links 
    AS links
                
                
                WHERE 
    MATCH(links.nameAGAINST ('+Autodesk*' IN BOOLEAN MODE) OR MATCH(links.descriptionAGAINST ('+Autodesk*' IN BOOLEAN MODE) OR MATCH(links.keywordsAGAINST ('+Autodesk*' IN BOOLEAN MODE)) AND  links.valid IN(012)
            
    ORDER BY links.rating ASC LIMIT 500;

    MySQL-Fehler  Unbekanntes Tabellenfeld 'links.rating' in order clause
    Fehler
    -Nr.    : 1054
    Fehler
    -Zeit   Friday20.03.2009 18:29:50
    Datum         
    Friday20.03.2009 18:29:50
    Skript        
    http://www.3dmaxforum.net/links/search.php?do=searchresults&string=Autodesk&catid=0&quicksearch=1&tag=1
    Referrer      http://www.3dmaxforum.net/links/showlink.php?l=1
    IP-Adresse    77.179.12.73
    Benutzername  
    Andreas
    Klassenname   
    vB_Database
    MySQL
    -Version 5.0.32-Debian_7etch8-log 

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MySQL Error: Unknown column 'dodeleted'
    By natas in forum Bugs From 3.0.0
    Replies: 3
    Last Post: 09-12-2008, 11:36 AM
  2. Unknown column error
    By Pingu in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 09-29-2007, 07:34 AM
  3. Unknown column 'links.rating' in 'order clause'
    By Shelby in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 01-09-2007, 06:01 PM
  4. DB Error: Unknown column 'phrasegroup_adv_links'
    By Freesteyelz in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 09-09-2006, 08:18 AM
  5. database error when rating
    By thorzzzten in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 09-22-2004, 01:14 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
  •