[Zadvantage]

Just installed the 4.10 version - I am getting an SQL error when I try to run the awards counter and a database error when I click on "Insight Experience" - this is what I'm seeing:

Database error in vBulletin 4.2.0:

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

I'm not really sure where to look for how to fix this... any advice?