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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.3.2
    • Fix Version/s: 2.3.3
    • Component/s: Assignment
    • Labels:
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_23_STABLE

      Description

      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()

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  12/Nov/12