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

Inconsistent datatypes when upgrade DB in Oracle in mdl_analytics_moodle table.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.8
    • 3.8
    • Analytics

    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

              dmonllao David Monllaó
              cescobedo Carlos Escobedo
              Jake Dallimore Jake Dallimore
              Jun Pataleta Jun Pataleta
              CiBoT CiBoT
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                18/Nov/19

                Time Tracking

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