-
Bug
-
Resolution: Fixed
-
Minor
-
2.2
-
MOODLE_22_STABLE
-
MOODLE_22_STABLE
-
MDL-30440-master -
Enter a URL something like this in your browser
http://yourmoodle/mod/scorm/report.php?id=36&mode=interactions&tifirst=A
Where 36 is the id of a scorm package
This generates following errors
Alternatively
- Goto Scorm > reports > interaction
- set Show to "all users"
- set page size in such a way that you get atleast 4-5 pages of results
- Select an option from the firstname/lastname (Any character A,B,C,D)
ERROR: Mixed types of sql query parameters!!
Stack trace:
line 711 of \lib\dml\moodle_database.php: dml_exception thrown
line 804 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->fix_sql_params()
line 1297 of \lib\dml\moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 345 of \mod\scorm\report\interactions\report.php: call to moodle_database->get_record_sql()
line 85 of \mod\scorm\report.php: call to scorm_interactions_report->display()
Reason of this is both "?" and ":varname" type of wildcards are used in the report
Note: the same changes should also be applied to basic report, so that it doesnt break when MDL-28588 will land.
Thanks