PDA

View Full Version : [fixed] Voteavg Database Error


Philipp
Thu 17th May '01, 7:21am
Got the follow email from the board:

Database error in vBulletin: Invalid SQL:
SELECT thread.threadid
FROM thread
WHERE thread.forumid='8' AND thread.visible=1 AND lastpost >= 987468925 AND sticky=0
ORDER BY sticky DESC, voteavg DESC
LIMIT 0,25
mysql error: Unknown column 'voteavg' in 'order clause'
mysql error number: 1054
Date: Thursday 17th of May 2001 02:55:25 AM
Script: /vb/forumdisplay.php?forumid=8&daysprune=30&pagenumber=1&perpage=25&sortorder=desc&sortfield=voteavg
Referer:

It seem like someone used &sortfield=voteavg but the rating column is current disabled.

Can you please add a error message like "The rating column is disabled" instead of a database error :)

John
Thu 17th May '01, 12:10pm
The user is not able to select that sort order by default - they have to type it into the URL manually. But I have added another check in anyway, and it will default to sorting by last post.

John