From ad26248c3a8f732456f6ce37e95ec6d845e0a97c Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Fri, 5 Nov 2010 07:29:24 +0000 Subject: [PATCH] MDL-25053 invalid SQL syntax postgresql requires AS when defining column aliases, credit goes to Alan Peter Carter --- 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 c0d9fe80493..bb460b8bf65 100644 --- a/course/report/participation/index.php +++ b/course/report/participation/index.php @@ -197,7 +197,7 @@ FROM (SELECT * FROM {role_assignments} WHERE contextid $relatedcontexts AND roleid = :roleid ) ra JOIN {user} u ON u.id = ra.userid LEFT JOIN ( - SELECT userid, COUNT(action) actioncount FROM {log} WHERE cmid = :instanceid AND time > :timefrom AND $actionsql GROUP BY userid + SELECT userid, COUNT(action) AS actioncount FROM {log} WHERE cmid = :instanceid AND time > :timefrom AND $actionsql GROUP BY userid ) l ON (l.userid = ra.userid)"; $params['roleid'] = $roleid; $params['instanceid'] = $instanceid; -- 2.43.0