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

Inconsistent datatypes when upgrade DB in Oracle in mdl_analytics_moodle table.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.8
    • 3.8
    • Analytics

      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.

            dmonllao David Monllaó
            cescobedo Carlos Escobedo
            Jake Dallimore Jake Dallimore
            Jun Pataleta Jun Pataleta
            CiBoT CiBoT
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

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

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