Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-3964

Oracle Error AJAX MARKING BLOCK -

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.3.2
    • Fix Version/s: None
    • Component/s: Block: AJAX Marking
    • Labels:
      None
    • Affected Branches:
      MOODLE_23_STABLE

      Description

      Installed Block 2.3 successfully
      No error messages displayed when logged in as Admin
      Login as a teacher and receive the following Oracle error message in the block.

      ORA-00923: FROM keyword not found where expected SELECT SQL_NO_CACHE countwrapperquery.id AS courseid, countwrapperquery.itemcount, countwrapperquery.timestamp, countwrapperquery.recentcount, countwrapperquery.mediumcount, countwrapperquery.overduecount, course.shortname AS name, course.fullname AS tooltip, countwrapperquery.display, countwrapperquery.groupsdisplay FROM (SELECT moduleunion.course AS id, MAX(moduleunion.timestamp) AS timestamp, COUNT(moduleunion.userid) AS itemcount, SUM(CASE WHEN (moduleunion.timestamp > 1349595412) THEN 1 ELSE 0 END) AS recentcount, SUM(CASE WHEN (moduleunion.timestamp < 1349595412 AND moduleunion.timestamp > 1349077012) THEN 1 ELSE 0 END) AS mediumcount, SUM(CASE WHEN moduleunion.timestamp < 1349077012 THEN 1 ELSE 0 END) AS overduecount, courseconfig.display, courseconfig.groupsdisplay FROM (SELECT sub.userid, sub.timemodified AS timestamp, course_modules.id AS coursemoduleid, moduletable.course, sub.id AS subid, 'assign' AS modulename FROM m_assign moduletable INNER JOIN m_assign_submission sub ON sub.assignment = moduletable.id LEFT JOIN m_assign_grades assign_grades ON assign_grades.assignment = moduletable.id AND assign_grades.userid = sub.userid AND assign_grades.grader = :o_assigngraderid INNER JOIN m_course_modules course_modules ON course_modules.instance = moduletable.id AND course_modules.module = 361 INNER JOIN m_course course ON course.id = moduletable.course WHERE dbms_lob.substr(sub.status, 32,1) = 'submitted' AND assign_grades.grade IS NULL AND EXISTS ( SELECT NULL FROM m_enrol enrol INNER JOIN m_user_enrolments user_enrolments ON user_enrolments.enrolid = enrol.id WHERE enrol.enrol IN (:o_enrolassign0011,:o_enrolassign0012,:o_enrolassign0013,:o_enrolassign0014,:o_enrolassign0015,:o_enrolassign0016,:o_enrolassign0017) AND enrol.courseid = moduletable.course AND user_enrolments.userid != :o_enrolassigncurrentuser AND user_enrolments.userid = sub.userid) AND course_modules.visible = 1 AND course.visible = 1 AND moduletable.course IN (:o_assigncourseid000038,:o_assigncourseid000039,:o_assigncourseid000040,:o_assigncourseid000041,:o_assigncourseid000042,:o_assigncourseid000043,:o_assigncourseid000044,:o_assigncourseid000045,:o_assigncourseid000046,:o_assigncourseid000047,:o_assigncourseid000048,:o_assigncourseid000049,:o_assigncourseid000050,:o_assigncourseid000051,:o_assigncourseid000052,:o_assigncourseid000053,:o_assigncourseid000054,:o_assigncourseid000055,:o_assigncourseid000056,:o_assigncourseid000057,:o_assigncourseid000058,:o_assigncourseid000059,:o_assigncourseid000060,:o_assigncourseid000061,:o_assigncourseid000062,:o_assigncourseid000063) UNION ALL SELECT sub.userid, sub.timemodified AS timestamp, course_modules.id AS coursemoduleid, moduletable.course, sub.id AS subid, 'assignment' AS modulename FROM m_assignment moduletable INNER JOIN m_assignment_submissions sub ON sub.assignment = moduletable.id INNER JOIN m_course_modules course_modules ON course_modules.instance = moduletable.id AND course_modules.module = 1 INNER JOIN m_course course ON course.id = moduletable.course WHERE ( (sub.grade = -1 AND dbms_lob.substr(sub.submissioncomment, 32,1) = '') /* Never marked / OR ( ( moduletable.resubmit = 1 OR (dbms_lob.substr(moduletable.assignmenttype, 32,1) = 'upload' AND moduletable.var4 = 1) ) / Resubmit allowed / AND (sub.timemodified > sub.timemarked) / Resubmit happened / ) ) / Not in draft state */ AND ( dbms_lob.substr(moduletable.assignmenttype, 32,1) != 'upload' OR ( dbms_lob.substr(moduletable.assignmenttype, 32,1) = 'upload' AND dbms_lob.substr(sub.data2, 32,1) = 'submitted')) AND dbms_lob.substr(moduletable.assignmenttype, 32,1) != 'offline' AND EXISTS ( SELECT NULL FROM m_enrol enrol INNER JOIN m_user_enrolments user_enrolments ON user_enrolments.enrolid = enrol.id WHERE enrol.enrol IN (:o_enrolassignment00164,:o_enrolassignment00165,:o_enrolassignment00166,:o_enrolassignment00167,:o_enrolassignment00168,:o_enrolassignment00169,:o_enrolassignment00170) AND enrol.courseid = moduletable.course AND user_enrolments.userid != :o_enrolassignmentcurrentuser AND user_enrolments.userid = sub.userid) AND course_modules.visible = 1 AND course.visible = 1 AND moduletable.course IN (:o_assignmentcourseid0000101,:o_assignmentcourseid0000102,:o_assignmentcourseid0000103,:o_assignmentcourseid0000104,:o_assignmentcourseid0000105,:o_assignmentcourseid0000106,:o_assignmentcourseid0000107,:o_assignmentcourseid0000108,:o_assignmentcourseid0000109,:o_assignmentcourseid0000110,:o_assignmentcourseid0000111,:o_assignmentcourseid0000112,:o_assignmentcourseid0000113,:o_assignmentcourseid0000114,:o_assignmentcourseid0000115,:o_assignmentcourseid0000116,:o_assignmentcourseid0000117,:o_assignmentcourseid0000118,:o_assignmentcourseid0000119,:o_assignmentcourseid0000120,:o_assignmentcourseid0000121,:o_assignmentcourseid0000122,:o_assignmentcourseid0000123,:o_assignmentcourseid0000124,:o_assignmentcourseid0000125,:o_assignmentcourseid0000126) UNION ALL SELECT sub.userid, sub.modified AS timestamp, course_modules.id AS coursemoduleid, moduletable.course, sub.id AS subid, 'forum' AS modulename FROM m_forum_posts sub INNER JOIN m_forum_discussions discussions ON sub.discussion = discussions.id INNER JOIN m_forum moduletable ON discussions.forum = moduletable.id INNER JOIN m_course_modules forumcoursemodules ON moduletable.id = forumcoursemodules.instance AND forumcoursemodules.module = 5 INNER JOIN m_context forumcontext ON forumcoursemodules.id = forumcontext.instanceid AND forumcontext.contextlevel = 70 INNER JOIN m_course_modules course_modules ON course_modules.instance = moduletable.id AND course_modules.module = 5 INNER JOIN m_course course ON course.id = moduletable.course WHERE sub.userid <> :o_forumuserid AND moduletable.assessed > 0 AND NOT EXISTS (SELECT 1 FROM m_rating rating WHERE rating.component = 'mod_forum' AND rating.contextid = forumcontext.id AND rating.ratingarea = 'post' AND rating.itemid = sub.id AND rating.userid != :o_forumratinguserid ) AND ( (moduletable.assesstimestart = 0) OR (sub.created >= moduletable.assesstimestart) ) AND ( (moduletable.assesstimefinish = 0) OR (sub.created <= moduletable.assesstimefinish) ) AND EXISTS ( SELECT NULL FROM m_enrol enrol INNER JOIN m_user_enrolments user_enrolments ON user_enrolments.enrolid = enrol.id WHERE enrol.enrol IN (:o_enrolforum001127,:o_enrolforum001128,:o_enrolforum001129,:o_enrolforum001130,:o_enrolforum001131,:o_enrolforum001132,:o_enrolforum001133) AND enrol.courseid = moduletable.course AND user_enrolments.userid != :o_enrolforumcurrentuser AND user_enrolments.userid = sub.userid) AND course_modules.visible = 1 AND course.visible = 1 AND moduletable.course IN (:o_forumcourseid0000164,:o_forumcourseid0000165,:o_forumcourseid0000166,:o_forumcourseid0000167,:o_forumcourseid0000168,:o_forumcourseid0000169,:o_forumcourseid0000170,:o_forumcourseid0000171,:o_forumcourseid0000172,:o_forumcourseid0000173,:o_forumcourseid0000174,:o_forumcourseid0000175,:o_forumcourseid0000176,:o_forumcourseid0000177,:o_forumcourseid0000178,:o_forumcourseid0000179,:o_forumcourseid0000180,:o_forumcourseid0000181,:o_forumcourseid0000182,:o_forumcourseid0000183,:o_forumcourseid0000184,:o_forumcourseid0000185,:o_forumcourseid0000186,:o_forumcourseid0000187,:o_forumcourseid0000188,:o_forumcourseid0000189) UNION ALL SELECT sub.userid, sub.timecreated AS timestamp, course_modules.id AS coursemoduleid, moduletable.course, sub.id AS subid, 'quiz' AS modulename FROM m_quiz moduletable INNER JOIN m_quiz_attempts quiz_attempts ON moduletable.id = quiz_attempts.quiz INNER JOIN m_question_attempts question_attempts ON question_attempts.questionusageid = quiz_attempts.uniqueid INNER JOIN m_question_attempt_steps sub ON question_attempts.id = sub.questionattemptid INNER JOIN m_question question ON question_attempts.questionid = question.id INNER JOIN m_course_modules course_modules ON course_modules.instance = moduletable.id AND course_modules.module = 12 INNER JOIN m_course course ON course.id = moduletable.course WHERE quiz_attempts.timefinish > 0 AND quiz_attempts.preview = 0 AND dbms_lob.substr(question_attempts.behaviour, 32,1) = 'manualgraded' AND sub.state = 'needsgrading' AND NOT EXISTS( SELECT 1 FROM m_question_attempt_steps st WHERE st.state IN (:o_quizq001190,:o_quizq001191,:o_quizq001192,:o_quizq001193,:o_quizq001194,:o_quizq001195) AND st.questionattemptid = question_attempts.id) AND EXISTS ( SELECT NULL FROM m_enrol enrol INNER JOIN m_user_enrolments user_enrolments ON user_enrolments.enrolid = enrol.id WHERE enrol.enrol IN (:o_enrolquiz001196,:o_enrolquiz001197,:o_enrolquiz001198,:o_enrolquiz001199,:o_enrolquiz001200,:o_enrolquiz001201,:o_enrolquiz001202) AND enrol.courseid = moduletable.course AND user_enrolments.userid != :o_enrolquizcurrentuser AND user_enrolments.userid = sub.userid) AND course_modules.visible = 1 AND course.visible = 1 AND moduletable.course IN (:o_quizcourseid0000233,:o_quizcourseid0000234,:o_quizcourseid0000235,:o_quizcourseid0000236,:o_quizcourseid0000237,:o_quizcourseid0000238,:o_quizcourseid0000239,:o_quizcourseid0000240,:o_quizcourseid0000241,:o_quizcourseid0000242,:o_quizcourseid0000243,:o_quizcourseid0000244,:o_quizcourseid0000245,:o_quizcourseid0000246,:o_quizcourseid0000247,:o_quizcourseid0000248,:o_quizcourseid0000249,:o_quizcourseid0000250,:o_quizcourseid0000251,:o_quizcourseid0000252,:o_quizcourseid0000253,:o_quizcourseid0000254,:o_quizcourseid0000255,:o_quizcourseid0000256,:o_quizcourseid0000257,:o_quizcourseid0000258) ) moduleunion LEFT JOIN m_groups_members gmember_members ON gmember_members.userid = moduleunion.userid LEFT JOIN m_groups gmember_groups ON gmember_groups.id = gmember_members.groupid AND gmember_groups.courseid = moduleunion.course AND gmember_groups.courseid IN (:o_param259,:o_param260,:o_param261,:o_param262,:o_param263,:o_param264,:o_param265,:o_param266,:o_param267,:o_param268,:o_param269,:o_param270,:o_param271,:o_param272,:o_param273,:o_param274,:o_param275,:o_param276,:o_param277,:o_param278,:o_param279,:o_param280,:o_param281,:o_param282,:o_param283,:o_param284) LEFT JOIN ( SELECT gviscoursemodulesettingsgroups.groupid, gviscoursemodulesettings.instanceid AS coursemoduleid FROM m_block_ajax_marking gviscoursemodulesettings INNER JOIN m_block_ajax_marking_groups gviscoursemodulesettingsgroups ON gviscoursemodulesettingsgroups.configid = gviscoursemodulesettings.id WHERE gviscoursemodulesettingsgroups.display = 0 AND gviscoursemodulesettings.userid = :o_gvis1user2 AND gviscoursemodulesettings.tablename = 'course_modules' UNION SELECT gviscoursesettingsgroups.groupid, gviscoursemodules.id AS coursemoduleid FROM m_course_modules gviscoursemodules INNER JOIN m_block_ajax_marking gviscoursesettings ON gviscoursemodules.course = gviscoursesettings.instanceid AND gviscoursesettings.tablename = 'course' AND gviscoursesettings.userid = :o_gvis1user1 INNER JOIN m_block_ajax_marking_groups gviscoursesettingsgroups ON gviscoursesettingsgroups.configid = gviscoursesettings.id AND gviscoursesettingsgroups.display = 0 WHERE NOT EXISTS (SELECT 1 FROM m_block_ajax_marking checknosettings INNER JOIN m_block_ajax_marking_groups checknogroups ON checknogroups.configid = checknosettings.id WHERE checknosettings.instanceid = gviscoursemodules.id AND checknosettings.tablename = 'course_modules' AND checknosettings.userid = :o_gvis1user3 AND checknogroups.display IS NOT NULL)) gvis ON (gvis.groupid = gmember_groups.id OR (gvis.groupid = 0 AND gmember_groups.id IS NULL)) AND gvis.coursemoduleid = moduleunion.coursemoduleid LEFT JOIN m_block_ajax_marking cmconfig ON cmconfig.tablename = 'course_modules' AND cmconfig.instanceid = moduleunion.coursemoduleid AND cmconfig.userid = :o_confuserid1 LEFT JOIN m_block_ajax_marking courseconfig ON courseconfig.tablename = 'course' AND courseconfig.instanceid = moduleunion.course AND courseconfig.userid = :o_confuserid2 WHERE ((gmember_groups.id = gmember_members.groupid) OR (gmember_groups.id IS NULL AND gmember_members.groupid IS NULL)) AND gvis.groupid IS NULL AND NOT EXISTS ( SELECT 1 FROM m_groups_members gmax_members INNER JOIN m_groups gmax_groups ON gmax_groups.id = gmax_members.groupid WHERE NOT EXISTS (SELECT 1 FROM ( SELECT gviscoursemodulesettingsgroups.groupid, gviscoursemodulesettings.instanceid AS coursemoduleid FROM m_block_ajax_marking gviscoursemodulesettings INNER JOIN m_block_ajax_marking_groups gviscoursemodulesettingsgroups ON gviscoursemodulesettingsgroups.configid = gviscoursemodulesettings.id WHERE gviscoursemodulesettingsgroups.display = 0 AND gviscoursemodulesettings.userid = :o_gvis2user2 AND gviscoursemodulesettings.tablename = 'course_modules' UNION SELECT gviscoursesettingsgroups.groupid, gviscoursemodules.id AS coursemoduleid FROM m_course_modules gviscoursemodules INNER JOIN m_block_ajax_marking gviscoursesettings ON gviscoursemodules.course = gviscoursesettings.instanceid AND gviscoursesettings.tablename = 'course' AND gviscoursesettings.userid = :o_gvis2user1 INNER JOIN m_block_ajax_marking_groups gviscoursesettingsgroups ON gviscoursesettingsgroups.configid = gviscoursesettings.id AND gviscoursesettingsgroups.display = 0 WHERE NOT EXISTS (SELECT 1 FROM m_block_ajax_marking checknosettings INNER JOIN m_block_ajax_marking_groups checknogroups ON checknogroups.configid = checknosettings.id WHERE checknosettings.instanceid = gviscoursemodules.id AND checknosettings.tablename = 'course_modules' AND checknosettings.userid = :o_gvis2user3 AND checknogroups.display IS NOT NULL)) gmax_vis WHERE gmax_vis.groupid = gmax_groups.id AND gmax_vis.coursemoduleid = moduleunion.coursemoduleid) AND gmax_members.userid = moduleunion.userid AND gmax_groups.courseid = moduleunion.course AND gmax_members.groupid > gmember_members.groupid AND gmax_groups.courseid IN (:o_param285,:o_param286,:o_param287,:o_param288,:o_param289,:o_param290,:o_param291,:o_param292,:o_param293,:o_param294,:o_param295,:o_param296,:o_param297,:o_param298,:o_param299,:o_param300,:o_param301,:o_param302,:o_param303,:o_param304,:o_param305,:o_param306,:o_param307,:o_param308,:o_param309,:o_param310) ) AND COALESCE(cmconfig.display, courseconfig.display, 1) = 1 GROUP BY moduleunion.course, courseconfig.display, courseconfig.groupsdisplay ) countwrapperquery INNER JOIN m_course course ON countwrapperquery.id = course.id ORDER BY course.shortname ASC [array ( 'o_assigngraderid' => '45595', 'o_enrolassign0011' => 'manual', 'o_enrolassign0012' => 'guest', 'o_enrolassign0013' => 'self', 'o_enrolassign0014' => 'cohort', 'o_enrolassign0015' => 'database', 'o_enrolassign0016' => 'meta', 'o_enrolassign0017' => 'category', 'o_enrolassigncurrentuser' => '45595', 'o_assigncourseid000038' => 1681, 'o_assigncourseid000039' => 1701, 'o_assigncourseid000040' => 1721, 'o_assigncourseid000041' => 1941, 'o_assigncourseid000042' => 2162, 'o_assigncourseid000043' => 2241, 'o_assigncourseid000044' => 2261, 'o_assigncourseid000045' => 2281, 'o_assigncourseid000046' => 2461, 'o_assigncourseid000047' => 2481, 'o_assigncourseid000048' => 2501, 'o_assigncourseid000049' => 2521, 'o_assigncourseid000050' => 2541, 'o_assigncourseid000051' => 2561, 'o_assigncourseid000052' => 2581, 'o_assigncourseid000053' => 2621, 'o_assigncourseid000054' => 2741, 'o_assigncourseid000055' => 2801, 'o_assigncourseid000056' => 2821, 'o_assigncourseid000057' => 2861, 'o_assigncourseid000058' => 2881, 'o_assigncourseid000059' => 2901, 'o_assigncourseid000060' => 2941, 'o_assigncourseid000061' => 3021, 'o_assigncourseid000062' => 3281, 'o_assigncourseid000063' => 3521, 'o_enrolassignment00164' => 'manual', 'o_enrolassignment00165' => 'guest', 'o_enrolassignment00166' => 'self', 'o_enrolassignment00167' => 'cohort', 'o_enrolassignment00168' => 'database', 'o_enrolassignment00169' => 'meta', 'o_enrolassignment00170' => 'category', 'o_enrolassignmentcurrentuser' => '45595', 'o_assignmentcourseid0000101' => 1681, 'o_assignmentcourseid0000102' => 1701, 'o_assignmentcourseid0000103' => 1721, 'o_assignmentcourseid0000104' => 1941, 'o_assignmentcourseid0000105' => 2162, 'o_assignmentcourseid0000106' => 2241, 'o_assignmentcourseid0000107' => 2261, 'o_assignmentcourseid0000108' => 2281, 'o_assignmentcourseid0000109' => 2461, 'o_assignmentcourseid0000110' => 2481, 'o_assignmentcourseid0000111' => 2501, 'o_assignmentcourseid0000112' => 2521, 'o_assignmentcourseid0000113' => 2541, 'o_assignmentcourseid0000114' => 2561, 'o_assignmentcourseid0000115' => 2581, 'o_assignmentcourseid0000116' => 2621, 'o_assignmentcourseid0000117' => 2741, 'o_assignmentcourseid0000118' => 2801, 'o_assignmentcourseid0000119' => 2821, 'o_assignmentcourseid0000120' => 2861, 'o_assignmentcourseid0000121' => 2881, 'o_assignmentcourseid0000122' => 2901, 'o_assignmentcourseid0000123' => 2941, 'o_assignmentcourseid0000124' => 3021, 'o_assignmentcourseid0000125' => 3281, 'o_assignmentcourseid0000126' => 3521, 'o_forumuserid' => '45595', 'o_forumratinguserid' => '45595', 'o_enrolforum001127' => 'manual', 'o_enrolforum001128' => 'guest', 'o_enrolforum001129' => 'self', 'o_enrolforum001130' => 'cohort', 'o_enrolforum001131' => 'database', 'o_enrolforum001132' => 'meta', 'o_enrolforum001133' => 'category', 'o_enrolforumcurrentuser' => '45595', 'o_forumcourseid0000164' => 1681, 'o_forumcourseid0000165' => 1701, 'o_forumcourseid0000166' => 1721, 'o_forumcourseid0000167' => 1941, 'o_forumcourseid0000168' => 2162, 'o_forumcourseid0000169' => 2241, 'o_forumcourseid0000170' => 2261, 'o_forumcourseid0000171' => 2281, 'o_forumcourseid0000172' => 2461, 'o_forumcourseid0000173' => 2481, 'o_forumcourseid0000174' => 2501, 'o_forumcourseid0000175' => 2521, 'o_forumcourseid0000176' => 2541, 'o_forumcourseid0000177' => 2561, 'o_forumcourseid0000178' => 2581, 'o_forumcourseid0000179' => 2621, 'o_forumcourseid0000180' => 2741, 'o_forumcourseid0000181' => 2801, 'o_forumcourseid0000182' => 2821, 'o_forumcourseid0000183' => 2861, 'o_forumcourseid0000184' => 2881, 'o_forumcourseid0000185' => 2901, 'o_forumcourseid0000186' => 2941, 'o_forumcourseid0000187' => 3021, 'o_forumcourseid0000188' => 3281, 'o_forumcourseid0000189' => 3521, 'o_quizq001190' => 'gradedwrong', 'o_quizq001191' => 'gradedpartial', 'o_quizq001192' => 'gradedright', 'o_quizq001193' => 'mangrwrong', 'o_quizq001194' => 'mangrpartial', 'o_quizq001195' => 'mangrright', 'o_enrolquiz001196' => 'manual', 'o_enrolquiz001197' => 'guest', 'o_enrolquiz001198' => 'self', 'o_enrolquiz001199' => 'cohort', 'o_enrolquiz001200' => 'database', 'o_enrolquiz001201' => 'meta', 'o_enrolquiz001202' => 'category', 'o_enrolquizcurrentuser' => '45595', 'o_quizcourseid0000233' => 1681, 'o_quizcourseid0000234' => 1701, 'o_quizcourseid0000235' => 1721, 'o_quizcourseid0000236' => 1941, 'o_quizcourseid0000237' => 2162, 'o_quizcourseid0000238' => 2241, 'o_quizcourseid0000239' => 2261, 'o_quizcourseid0000240' => 2281, 'o_quizcourseid0000241' => 2461, 'o_quizcourseid0000242' => 2481, 'o_quizcourseid0000243' => 2501, 'o_quizcourseid0000244' => 2521, 'o_quizcourseid0000245' => 2541, 'o_quizcourseid0000246' => 2561, 'o_quizcourseid0000247' => 2581, 'o_quizcourseid0000248' => 2621, 'o_quizcourseid0000249' => 2741, 'o_quizcourseid0000250' => 2801, 'o_quizcourseid0000251' => 2821, 'o_quizcourseid0000252' => 2861, 'o_quizcourseid0000253' => 2881, 'o_quizcourseid0000254' => 2901, 'o_quizcourseid0000255' => 2941, 'o_quizcourseid0000256' => 3021, 'o_quizcourseid0000257' => 3281, 'o_quizcourseid0000258' => 3521, 'o_param259' => 1681, 'o_param260' => 1701, 'o_param261' => 1721, 'o_param262' => 1941, 'o_param263' => 2162, 'o_param264' => 2241, 'o_param265' => 2261, 'o_param266' => 2281, 'o_param267' => 2461, 'o_param268' => 2481, 'o_param269' => 2501, 'o_param270' => 2521, 'o_param271' => 2541, 'o_param272' => 2561, 'o_param273' => 2581, 'o_param274' => 2621, 'o_param275' => 2741, 'o_param276' => 2801, 'o_param277' => 2821, 'o_param278' => 2861, 'o_param279' => 2881, 'o_param280' => 2901, 'o_param281' => 2941, 'o_param282' => 3021, 'o_param283' => 3281, 'o_param284' => 3521, 'o_gvis1user2' => '45595', 'o_gvis1user1' => '45595', 'o_gvis1user3' => '45595', 'o_confuserid1' => '45595', 'o_confuserid2' => '45595', 'o_gvis2user2' => '45595', 'o_gvis2user1' => '45595', 'o_gvis2user3' => '45595', 'o_param285' => 1681, 'o_param286' => 1701, 'o_param287' => 1721, 'o_param288' => 1941, 'o_param289' => 2162, 'o_param290' => 2241, 'o_param291' => 2261, 'o_param292' => 2281, 'o_param293' => 2461, 'o_param294' => 2481, 'o_param295' => 2501, 'o_param296' => 2521, 'o_param297' => 2541, 'o_param298' => 2561, 'o_param299' => 2581, 'o_param300' => 2621, 'o_param301' => 2741, 'o_param302' => 2801, 'o_param303' => 2821, 'o_param304' => 2861, 'o_param305' => 2881, 'o_param306' => 2901, 'o_param307' => 2941, 'o_param308' => 3021, 'o_param309' => 3281, 'o_param310' => 3521, )] 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 592 of \blocks\ajax_marking\classes\query_base.class.php: call to oci_native_moodle_database->get_records_sql() * line 145 of \blocks\ajax_marking\filters\base.class.php: call to block_ajax_marking_query_base->execute() * line 145 of \blocks\ajax_marking\filters\base.class.php: call to block_ajax_marking_query_decorator_base->execute() * line 188 of \blocks\ajax_marking\classes\nodes_builder_base.class.php: call to block_ajax_marking_query_decorator_base->execute() * line 60 of \blocks\ajax_marking\actions\ajax_nodes.php: call to block_ajax_marking_nodes_builder_base::unmarked_nodes()

      Here is a web link on how to solve the issue http://www.dba-oracle.com/t_ora_00923_from_keyword_not_found_where_expected.htm

        Attachments

          Activity

            People

            • Assignee:
              mattgibson Matt Gibson
              Reporter:
              moodlecvqo CLAIRE BROWNE
              Participants:
              Component watchers:
              Matt Gibson
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: