Throws an SQL error due to ill formed SQL

See line 200 approx of /course/report/participation/index.php

SELECT userid, COUNT(action) actioncount FROM

{log} WHERE cmid = :instanceid AND time > :timefrom AND $actionsql GROUP BY userid

should read as follows for Postgres

SELECT userid, COUNT(action) AS actioncount FROM {log}

WHERE cmid = :instanceid AND time > :timefrom AND $actionsql GROUP BY userid