Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.9.11
-
None
-
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()