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

Inconsistent datatypes when upgrade DB in Oracle in mdl_analytics_moodle table.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.8
    • Fix Version/s: 3.8
    • Component/s: Analytics
    • Labels:

      Description

      We've got an error in the upgrade process and the site it can not be upgraded to 3.8dev+ (Build: 20191105) (2019110500.00)

      Error writing to databaseMore information about this error
       
      Debug info:  ORA-00932: inconsistent datatypes: expected - got CLOB
      UPDATE m_analytics_models set contextids = null
                             WHERE contextids = :o_zero or contextids = :o_null
      [array (
        'o_zero' => '0',
        'o_null' => 'null',
      )]
      Error code: dmlwriteexception
       
          
      Stack trace:  line 489 of /lib/dml/moodle_database.php: dml_write_exception thrownline 277 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()line 1076 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()line 3760 of /lib/db/upgrade.php: call to oci_native_moodle_database->execute()line 1817 of /lib/upgradelib.php: call to xmldb_main_upgrade()line 518 of /admin/index.php: call to upgrade_core()
      

      Previous version: 3.7.2+ (Build: 20191105) (2019102500.04)

      New version: 3.8dev+ (Build: 20191105) (2019110500.00)

      I've worked with https://github.com/moodlehq/moodle-docker to use Oracle and Apache.

      I've attached a screenshot of the error and another screenshot with the oracle configuration to test it.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dmonllao David Monllaó
              Reporter:
              cescobedo Carlos Escobedo
              Peer reviewer:
              Jake Dallimore
              Integrator:
              Jun Pataleta
              Tester:
              CiBoT
              Participants:
              Component watchers:
              Elizabeth Dalton, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours
                  3h