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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.5.2
    • Fix Version/s: None
    • Labels:
      None
    • Plugin Version:
      3.6.0
    • Affected Branches:
      MOODLE_35_STABLE

      Description

      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

        Attachments

          Activity

            People

            • Votes:
              3 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: