We are getting the following message from the top users results module. Everything else seem to be working great. Any thoughts on why? This does not appear to be using any of the groups tables from Joomla core which would point to a JACL issue.

Invalid use of group function SQL=SELECT Q.QuizName, QSI.UserScore, (MAX(QSI.UserScore / QSI.MaxScore) * 100) AS PercentScore FROM jos_ariquizstatisticsinfo QSI INNER JOIN jos_ariquiz Q ON QSI.QuizId = Q.QuizId WHERE UserId = 83 AND QSI.Status = "Finished" AND Q.Status = 1 GROUP BY QSI.QuizId ORDER BY MAX(QSI.UserScore / QSI.MaxScore) DESC LIMIT 0,5No Pending Actions

What MySQL version are you using?

We're using MySQL 4.1.22

Could you please try using MySQL 4.2 and above since it looks like MySQL 4.1.22 does not support this type of GROUP operator.

Did it solve the problem? (MySQL 4.2)

Now, ARI Quiz works fine with MySQL 4.1.22

Regards,
ARI Soft