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

SQL error in Detailed statistics report of Hotpot module

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.9.11
    • None
    • Module: HotPot
    • None
    • MOODLE_19_STABLE

    Description

      1. Created a new JCross hotpot activity
      2. Completed the activity with one student
      3. As a teacher, attempted to generate a report with the following params:
      a. Detailed statistic
      b. Enrolled students (I have separate groups set up for this course)
      c. Best attempt
      d. Format: HTML
      e. Wrap data: yes
      f. Show legend: no

      This error does not occur if I select "All users" or "All participants":

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY clickreportid' at line 1

      SELECT clickreportid, MAX(CONCAT(timefinish,'_',id)) AS joinedvalues FROM mdl_hotpot_attempts a WHERE a.clickreportid IN () GROUP BY clickreportid

      • line 686 of lib\dmllib.php: call to debugging()
      • line 944 of lib\dmllib.php: call to get_recordset_sql()
      • line 654 of mod\hotpot\report.php: call to get_records_sql()
      • line 204 of mod\hotpot\report.php: call to hotpot_get_records_groupby()

      Attachments

        Activity

          People

            xxxxxxx Gordon Bateson
            nicolasconnault Nicolas Connault
            Gordon Bateson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: