[sigh]

Running vB 4.0.7, just upgraded the mod from 4.0.4 to 4.1.6 and getting this error on media.php:

Database error in vBulletin 4.0.7:

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  : Friday, October 1st 2010 @ 06:31:48 AM
Error Date    : Friday, October 1st 2010 @ 06:31:48 AM
Script        : xxx
Referrer      : xxx
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.91-community-log

Add this error when running rebuild media information:

Database error in vBulletin 4.0.7:

Invalid SQL:

		SELECT mediaID, title, subscriptions FROM media as media
		WHERE mediaID >= 0 AND mediaID < 100
		ORDER BY mediaID;

MySQL Error   : Unknown column 'subscriptions' in 'field list'
Error Number  : 1054
Request Date  : Friday, October 1st 2010 @ 06:35:59 AM
Error Date    : Friday, October 1st 2010 @ 06:35:59 AM
Script        : xxx
Referrer      : xxx
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.91-community-log