-
Bug
-
Resolution: Duplicate
-
Minor
-
2.3.2
-
MOODLE_23_STABLE
-
MOODLE_23_STABLE
My Moodle site runs upon Oracle database. After upgrade to 2.3.2, I cann't visit my home page. Debug info like this:
Debug info: ORA-00923: FROM keyword not found where expected
|
SELECT a.id AS assignment, a.nosubmissions AS offline, g.timemodified AS timemarked, g.grader AS grader, g.grade AS grade, s.status AS status
|
FROM m_assign a LEFT JOIN m_assign_grades g ON g.assignment = a.id AND g.userid = :o_param1 LEFT JOIN m_assign_submission s ON s.assignment = a.id AND s.userid = :o_param2
|
AND a.id = :o_param3
|
[array (
|
'o_param1' => '21',
|
'o_param2' => '21',
|
'o_param3' => '23',
|
)]
|
Error code: dmlreadexception
|
Stack trace:
|
|
line 407 of /lib/dml/moodle_database.php: dml_read_exception thrown
|
line 274 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
|
line 1101 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
|
line 263 of /mod/assign/lib.php: call to oci_native_moodle_database->get_records_sql()
|
line 847 of /course/lib.php: call to assign_print_overview()
|
line 107 of /blocks/course_overview/block_course_overview.php: call to print_overview()
|
line 281 of /blocks/moodleblock.class.php: call to block_course_overview->get_content()
|
line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
|
line 935 of /lib/blocklib.php: call to block_base->get_content_for_output()
|
line 987 of /lib/blocklib.php: call to block_manager->create_block_contents()
|
line 314 of /lib/blocklib.php: call to block_manager->ensure_content_created()
|
line 1043 of /lib/outputrenderers.php: call to block_manager->get_content_for_region()
|
line 148 of /my/index.php: call to core_renderer->blocks_for_region()
|
- duplicates
-
MDL-34660 SQL error in assignments module with Oracle Database I
-
- Closed
-