SQL Error When Sorting

[MThornback]

Anyone else getting an SQL error when you try and sort by installs?

[Shazz]

Same here
Nice catch

[Ntfu2]

same here

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT thread.threadid


FROM thread AS thread


WHERE forumid = 194
AND sticky = 0
AND visible = 1




ORDER BY sticky DESC, installs DESC
LIMIT 0, 25;

MySQL Error : Unknown column 'installs' in 'order clause'
Error Number : 1054
Date : Monday, January 8th 2007 @ 12:49:18 AM
Script : https://vborg.vbsupport.ru/forumdisplay.php?f=194&daysprune=-1&order=desc&sort=installs
Referrer : https://vborg.vbsupport.ru/forumdisplay.php?f=194
IP Address :
Username : Ntfu2
Classname : vB_Database
-->

[Paul M]

Hmm, I'd better have a look at that.

[Paul M]

Should be ok now.