[Phalynx]

Originally Posted by Phoenixgal

OK I saw where someone else had this problem but after reading through 34 pages didn't see where it was "talked" about.

PHP Code:

Database error in vBulletin 4.0.4:

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  : Wednesday, July 14th 2010 @ 11:58:59 AM
Error Date    : Wednesday, July 14th 2010 @ 11:59:00 AM
Script        : [url]http://www.xxxxxxx.org/forums/xperience.php[/url]
Referrer      : [url]http://www.xxxxxx.org/forums/showgroups.php[/url]
IP Address    : xxxxxxxxxxx
Username      : xxxxxxxxxx
Classname     : vB_Database
MySQL Version : 4.1.22-standard-log 


That is because you have MySQL 4.1 installed. "Order by" with "Group by" is a no-go. I'm already working on a version that is compatible to that very old MySQL.