From 15a18acddcfce4a0bc09a5359c04016a529d8c1c Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Mon, 8 Nov 2010 01:26:10 +0000 Subject: [PATCH] MDL-25053 invalid SQL syntax postgresql requires AS when defining column aliases, credit goes to Alan Peter Carter and Brett Wilkins --- course/report/participation/index.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/course/report/participation/index.php b/course/report/participation/index.php index 27dfe63affd..0644ac37305 100644 --- a/course/report/participation/index.php +++ b/course/report/participation/index.php @@ -186,7 +186,7 @@ FROM (SELECT * FROM {$CFG->prefix}role_assignments WHERE contextid $relatedcontexts AND roleid = $roleid ) ra JOIN {$CFG->prefix}user u ON u.id = ra.userid LEFT JOIN ( - SELECT userid, COUNT(action) actioncount FROM {$CFG->prefix}log WHERE cmid = $instanceid AND time > $timefrom AND $actionsql GROUP BY userid + SELECT userid, COUNT(action) AS actioncount FROM {$CFG->prefix}log WHERE cmid = $instanceid AND time > $timefrom AND $actionsql GROUP BY userid ) l ON (l.userid = ra.userid)"; -- 2.11.4.GIT