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

Using Oracle reserved word as Bind variable in upgrade.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: 2.0.2
    • Component/s: Installation
    • Labels:
    • Environment:
      Oracle 11g

      Description

      The moodle upgrade uses an oracle reserved word as as a bind variable. The reserved word is "view". This is a reserved word in both 10g and 11g. The given error is below:

      Debug info: ORA-01745: invalid host/bind variable name
      UPDATE m_role_capabilities SET capability = :participate WHERE capability = :view
      [array (
      'participate' => 'moodle/course:participate',
      'view' => 'moodle/course:view',
      )]
      Stack trace:

      • line 394 of \lib\dml\moodle_database.php: dml_write_exception thrown
      • line 268 of \lib\dml\oci_native_moodle_database.php: call to moodle_database->query_end()
      • line 947 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      • line 2829 of \lib\db\upgrade.php: call to oci_native_moodle_database->execute()
      • line 1309 of \lib\upgradelib.php: call to xmldb_main_upgrade()
      • line 252 of \admin\index.php: call to upgrade_core()

        Attachments

          Activity

            People

            • Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              melkiador Michael Gonzales
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                21/Feb/11