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

SQL error in Detailed statistics report of Hotpot module

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9.11
    • Fix Version/s: None
    • Component/s: Module: HotPot
    • Labels:
      None
    • Affected Branches:
      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

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: