[miket1234]

its possible to get this error because i have MySQL Version : 4.1.22?

Originally Posted by miket1234

Hi

I get this error on i push EXPERIENCE button from main menu:

Database error in vBulletin 4.0.5:

Invalid SQL:
SELECT
COUNT(*) AS cnt_ach,
i.achievementid,
a.title,
a.description,
a.imagebig
FROM _vB_xperience_achievements_issues AS i
INNER JOIN _vB_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 : Thursday, July 29th 2010 @ 08:40:04 AM
Error Date : Thursday, July 29th 2010 @ 08:40:04 AM