From 17312b83c5264dfbae08da03cd65e6a0411c2d19 Mon Sep 17 00:00:00 2001
From: tjhunt <tjhunt>
Date: Mon, 14 Jul 2008 15:57:49 +0000
Subject: [PATCH] Change group-by. I know what was there was equivalent, but
 Postgres is pedantic about these thigns, and was reporting an error.

---
 mod/quiz/report/reportlib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/quiz/report/reportlib.php b/mod/quiz/report/reportlib.php
index a65353ea9c..e50cf74cfb 100644
--- a/mod/quiz/report/reportlib.php
+++ b/mod/quiz/report/reportlib.php
@@ -98,7 +98,7 @@ function quiz_get_average_grade_for_questions($quiz, $userids){
                         "($qmfilter) AND " .
                         "qa.userid $usql AND " .
                         "qa.quiz = ? ".
-                        "GROUP BY qs.question";
+                        "GROUP BY qns.questionid";
     return $DB->get_records_sql_menu($questionavgssql, $params);
 }
 
-- 
2.39.5