-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
2.3.3
-
MOODLE_23_STABLE
Installed new 2.3 version and still get the button refreshing it never displays the work which needs to be marked.
Also this error has appeared.
A Moodle error occurred:
Error reading from database
Debug info:
ORA-00907: missing right parenthesis SELECT groups.id, groups.courseid AS courseid, groups.name, settings.display FROM m_groups groups INNER JOIN m_course course ON course.id = groups.courseid LEFT JOIN (SELECT coursesettings.instanceid AS courseid, groupsettings.groupid, groupsettings.display FROM m_block_ajax_marking_groups AS groupsettings INNER JOIN m_block_ajax_marking coursesettings ON (coursesettings.tablename = 'course' AND coursesettings.id = groupsettings.configid) WHERE coursesettings.userid = :o_userid ) settings ON (groups.courseid = settings.courseid AND groups.id = settings.groupid) WHERE groups.courseid IN (:o_param57,:o_param58,:o_param59,:o_param60,:o_param61,:o_param62,:o_param63,:o_param64,:o_param65,:o_param66,:o_param67,:o_param68,:o_param69,:o_param70,:o_param71,:o_param72,:o_param73,:o_param74,:o_param75,:o_param76,:o_param77,:o_param78,:o_param79,:o_param80,:o_param81,:o_param82) AND ( course.groupmode != 1 OR EXISTS ( SELECT 1 FROM m_groups_members teachermemberships WHERE teachermemberships.groupid = groups.id AND teachermemberships.userid = :o_teacheruserid ) ) [array ( 'o_userid' => '45595', 'o_param57' => '2621', 'o_param58' => '2162', 'o_param59' => '2561', 'o_param60' => '2281', 'o_param61' => '2501', 'o_param62' => '2241', 'o_param63' => '2461', 'o_param64' => '2261', 'o_param65' => '2541', 'o_param66' => '2881', 'o_param67' => '2861', 'o_param68' => '1681', 'o_param69' => '2481', 'o_param70' => '3021', 'o_param71' => '3281', 'o_param72' => '1701', 'o_param73' => '2521', 'o_param74' => '1721', 'o_param75' => '2741', 'o_param76' => '2941', 'o_param77' => '2901', 'o_param78' => '2801', 'o_param79' => '2821', 'o_param80' => '1941', 'o_param81' => '2581', 'o_param82' => '3521', 'o_teacheruserid' => '45595', )] Error code: dmlreadexception
Stacktrace:
- 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 588 of \blocks\ajax_marking\classes\nodes_builder_base.class.php: call to oci_native_moodle_database->get_records_sql() * line 510 of \blocks\ajax_marking\classes\nodes_builder_base.class.php: call to block_ajax_marking_nodes_builder_base::attach_groups_to_course_nodes() * line 58 of \blocks\ajax_marking\actions\ajax_nodes.php: call to block_ajax_marking_nodes_builder_base::get_config_nodes()