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

Question upgrade failure in Oracle and SQL Server

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • 3.5.3
    • 3.5.2
    • Questions
    • Microsoft SQL, Oracle
    • MOODLE_35_STABLE
    • MOODLE_35_STABLE
    • MDL-63493-master
    • Hide

      Note: Test on PostgreSQL, SQL Server and Oracle.

      1. Open your terminal and go to your Moodle instance's root folder.
      2. Checkout Moodle 3.4.5: 

        git checkout  v3.4.5

      3. Install your Moodle instance.
        • For other databases, if you have MDK, 

          mdk install -e [DBENGINE]

          Where "[DBENGINE]" can be either "pgsql" (for PostgreSQL) or "sqlsrv" for (SQL Server)

        • For Oracle, since MDK doesn't support Oracle yet, you'll have to install manually, probably better to do this on the web browser.
      4. Checkout the latest Moodle codebase with this patch applied:
        • For master 

          git checkout master

        • For 3.5 

          git checkout MOODLE_35_STABLE

      5. Run an upgrade: 

         php admin/cli/upgrade.php --non-interactive --allow-unstable

      6. Confirm that the upgrade process completes successfully and that you don't get any error messages.
      Show
      Note: Test on PostgreSQL, SQL Server and Oracle. Open your terminal and go to your Moodle instance's root folder. Checkout Moodle 3.4.5: git checkout v3.4.5 Install your Moodle instance. For other databases, if you have MDK, mdk install -e [DBENGINE] Where " [DBENGINE] " can be either " pgsql " (for PostgreSQL) or " sqlsrv " for (SQL Server) For Oracle, since MDK doesn't support Oracle yet, you'll have to install manually, probably better to do this on the web browser. Checkout the latest Moodle codebase with this patch applied: For master git checkout master For 3.5 git checkout MOODLE_35_STABLE Run an upgrade: php admin/cli/upgrade.php --non-interactive --allow-unstable Confirm that the upgrade process completes successfully and that you don't get any error messages.

    Description

      To reproduce:

      1. Have a Moodle installation before the patch in MDL-62708 landed.
      2. Upgrade to the latest Moodle version.
      3. Expected: Upgrade will continue successfully.
      4. Actual: Upgrade fails with the error below.

      Weird, I didn't encounter this on PostgreSQL. I encountered this on Oracle.

      Attachments

        Issue Links

          is a regression caused by

          Improvement - An enhancement to an existing Moodle feature. MDL-36941 Create new tables for messages and notifications and convert existing API to use these

          • Major - Major loss of function, incorrect output
          • Closed

          Improvement - An enhancement to an existing Moodle feature. MDL-62708 Add idnumbers to question and question category

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              jpataleta Jun Pataleta
              jpataleta Jun Pataleta
              Michael Hawkins Michael Hawkins
              Andrew Lyons Andrew Lyons
              Peter Dias Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                12/Nov/18