Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
2.4
-
MOODLE_24_STABLE
-
MOODLE_24_STABLE
-
m24_
MDL-36142_Incorrect_query_returns_HTTP_404 -
-
Description
When $sco->launch = '' a SQL exception is triggered:
Debug info: 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 'scorm_scoes', 'launch', false, true).' AND id > '179' ORDER BY id ASC' at line 1
|
SELECT * FROM mdl_scorm_scoes WHERE scorm = ? AND '.('scorm_scoes', 'launch', false, true).' AND id > ? ORDER BY id ASC
|
[array (
|
0 => '7',
|
1 => '179',
|
)]
|
Error code: dmlreadexception
|
Stack trace:
|
|
line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
|
line 1014 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
|
line 1189 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
|
line 82 of /mod/scorm/loadSCO.php: call to moodle_database->get_records_select()
|
This issue has seen the light starting from MDL-35418 due to the fact that when attending a Learning Package it tries to deliver those items of the TOC being just a folder (no manifest//resource@href i.e. $sco->launch = ''): sniffing the traffic between client and server will show these HTTP 404 errors, on GETting mod/scorm/loadSCO.php?a=<activity_id>&scoid=<sco_id_being_an_item_not_launch-able>¤torg=&attempt=<attempt_id>.
Attachments
Issue Links
- Testing discovered
-
MDL-35840 A typo prevents to correctly impose the focus
-
- Closed
-