[Kayden]

Curious: will MySQL 4 work with this mod?

I ask because I get the following error when visiting xperience.php -

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT
		COUNT(*) AS cnt_ach,
		i.achievementid,
		a.title,
		a.description,
		a.imagebig
		FROM xperience_achievements_issues AS i
		INNER JOIN xperience_achievements AS a ON a.achievementid=i.achievementid
		GROUP BY achievementid
		ORDER BY COUNT(*) DESC
		LIMIT 1;

MySQL Error   : Invalid use of group function
Error Number  : 1111
Request Date  : Monday, June 28th 2010 @ 09:45:35 PM
Error Date    : Monday, June 28th 2010 @ 09:45:36 PM
Script        : http://***/xperience.php
Referrer      : http://***/forum.php