Database Error: Unknown column 'links.rating'

[Peter Walker]

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

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?

[Brian]

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.

[abaum]

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.name) AGAINST ('+Autodesk*' IN BOOLEAN MODE) OR MATCH(links.description) AGAINST ('+Autodesk*' IN BOOLEAN MODE) OR MATCH(links.keywords) AGAINST ('+Autodesk*' IN BOOLEAN MODE)) AND  links.valid IN(0, 1, 2)
        ORDER BY links.rating ASC LIMIT 500;

MySQL-Fehler  : Unbekanntes Tabellenfeld 'links.rating' in order clause
Fehler-Nr.    : 1054
Fehler-Zeit   : Friday, 20.03.2009 @ 18:29:50
Datum         : Friday, 20.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