[rule0]

When I click a user link in media.php it gives the following sql error:

Invalid SQL:

		SELECT user.*, media.userID, COUNT(media.mediaID) AS count
		FROM vb_user AS user 
		LEFT JOIN vb_media AS media ON(media.userID = user.userid)
		WHERE user.userid = '1';

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140

vb 4.0.3

ps: thanks, we've been waiting for this, was keeping 3.x plugin since 4.x upgrade. nominated and appreciated