-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
3.5.2
-
None
-
3.6.0
-
MOODLE_35_STABLE
When you try to import and execute this xml report in a Moodle 3.5.2 an error appears:
Debug info: ERROR: column "c.fullname" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT COUNT(l.id) hits, l.course courseId, c.fullname cours...
^
SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename
FROM mdl_log l INNER JOIN mdl_course c ON l.course = c.id
GROUP BY courseId
ORDER BY hits DESC LIMIT 5000
[array (
)]
Error code: dmlreadexception