From daae98e118e2bca08e97293208bf1b0dffe4022e Mon Sep 17 00:00:00 2001 From: jamiesensei Date: Thu, 24 Jul 2008 16:10:26 +0000 Subject: [PATCH] MDL-14216 "change query to work on Postgres." - some adjustments to make it work on mysql again too. --- mod/quiz/report/overview/report.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mod/quiz/report/overview/report.php b/mod/quiz/report/overview/report.php index 2f43c34914..c058677386 100644 --- a/mod/quiz/report/overview/report.php +++ b/mod/quiz/report/overview/report.php @@ -601,7 +601,7 @@ class quiz_overview_report extends quiz_default_report { if ($attemptids){ //make sure we fetch all attempts for users to calculate grade. //not just those that have changed. - $sql = "SELECT qa2.* FROM {quiz_attempts} qa2 WHERE qa2.userid IN (SELECT DISTINCT userid FROM {quiz_attempts} qa WHERE $attemptsql)"; + $sql = "SELECT qa2.* FROM {quiz_attempts} qa2 WHERE qa2.userid IN (SELECT DISTINCT userid FROM {quiz_attempts} WHERE $attemptsql)"; } else { $sql = "SELECT * FROM {quiz_attempts} WHERE $attemptsql"; } -- 2.39.5