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

Question upgrade failure in Oracle and SQL Server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.5.2
    • Fix Version/s: 3.5.3
    • Component/s: Questions
    • Labels:
    • Database:
      Microsoft SQL, Oracle
    • Testing Instructions:
      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.
    • Affected Branches:
      MOODLE_35_STABLE
    • Fixed Branches:
      MOODLE_35_STABLE
    • Pull 3.5 Branch:
    • Pull Master Branch:
      MDL-63493-master

      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

            Activity

              People

              Assignee:
              jpataleta Jun Pataleta
              Reporter:
              jpataleta Jun Pataleta
              Peer reviewer:
              Michael Hawkins
              Integrator:
              Andrew Nicols
              Tester:
              Peter Dias
              Participants:
              Component watchers:
              Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

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