PDA

View Full Version : Database Error: Unknown column 'links.rating'


Peter Walker
02-13-2009, 09:15 PM
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
02-14-2009, 12:53 PM
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.

Our Sponsors
 

abaum
03-20-2009, 02:38 PM
Bug in search.php: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