[Riccardo83]

I updated from 4.0.0 to 4.1.6. i get this error below... tried to follow all the steps in the how to...

http://www.alizee-forum.com/media.php?

Database error

Database error in vBulletin 4.0.8:

Invalid SQL:

			SELECT media.*, media_service.*, media_category.*, IF(NOT ISNULL(user.userid), user.username, media.username) AS username
			FROM media AS media
			LEFT JOIN media_service AS media_service ON(media_service.serviceID = media.serviceID)
			LEFT JOIN media_category AS media_category ON(media_category.categoryID = media.categoryID)
			LEFT JOIN user AS user ON(user.userid = media.userID)
			WHERE media_category.catOrder != '0'
			ORDER BY media.favorites DESC, media.comments DESC, media.views DESC
			LIMIT 3;

MySQL Error   : Unknown column 'media.favorites' in 'order clause'
Error Number  : 1054
Request Date  : Saturday, October 23rd 2010 @ 01:49:50 PM
Error Date    : Saturday, October 23rd 2010 @ 01:49:50 PM
Script        : http://www.alizee-forum.com/media.php
Referrer      : http://www.alizee-forum.com/forum.php
IP Address    : 178.25.26.37
Username      : Riccardo
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.91-community