also getting this error as well
PHP Code:
Database error in vBulletin 4.0.6:
Invalid SQL:
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM vb3_xperience_achievements_issues AS i
INNER JOIN vb3_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