Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-35387

ORA-00923: FROM keyword not found where expected when upgraded to 2.3.2

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • 2.3.3
    • 2.3.2
    • Assignment
    • 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()

            damyon Damyon Wiese
            luyanfei Yanfei Lu
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.