Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-7628

Configurable Reports: Error importing "most active courses.xml"

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor 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

            jleyva Juan Leyva
            icsbcn Iban Cardona i Subiela
            Votes:
            3 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.