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

Question upgrade failure in Oracle and SQL Server

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker 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.

      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.

        1. screenshot-1.png
          screenshot-1.png
          92 kB
        2. Screenshot from 2018-10-02 17-16-30.png
          Screenshot from 2018-10-02 17-16-30.png
          104 kB

            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

              Created:
              Updated:
              Resolved:

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