-
Bug
-
Resolution: Fixed
-
Minor
-
2.1.9, 2.3.3
-
MOODLE_21_STABLE, MOODLE_23_STABLE
-
MOODLE_23_STABLE, MOODLE_24_STABLE
-
w51_
MDL-37254_m25_courseinfoas -
We encountered the following error in our logs:
<2012-12-20 14:27:15 JST moodle moodle2012 6371>DETAIL: parameters: $1 = '5474', $2 = '51802', $3 = 'course', $4 = 'section', $5 = '.'
<2012-12-20 14:27:15 JST moodle moodle2012 6371>: syntax error at or near "sectionid" at character 23
<2012-12-20 14:27:15 JST moodle moodle2012 6371>STATEMENT: SELECT DISTINCT cs.id sectionid FROM mdl_files f, mdl_course_sections cs
WHERE cs.course = $1
AND f.contextid = $2
AND f.component = $3
AND f.filearea = $4
AND f.itemid = cs.id
AND f.filename <> $5
Apparently "SELECT DISTINCT cs.id sectionid " should be "SELECT DISTINCT cs.id section". At least with this modification, the error goes away. The error was discovered in v. 2.1.9 but appears to still be present in 2.3.3.