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

Error upgrading label "ORA-00932: inconsistent datatypes: expected - got CLOB"

    XMLWordPrintable

Details

    • Oracle
    • MOODLE_403_STABLE
    • MOODLE_402_STABLE, MOODLE_403_STABLE
    • MDL-80523-402
    • MDL-80523-403
    • Hide
      1. Ensure testing with Oracle
      2. Copy mdl-78010-generator.php (from MDL-78010) to your DIRROOT
      3. Log in as admin
      4. Manually navigate to the following URL:

        WWWROOT/mdl-78010-generator.php
        

        • Tick/select Downgrade label module to force the upgrade process execution
        • Leave everything else as default
        • Press Generate
      5. Navigate to Site administration to trigger upgrade
      6. Confirm you see the following progress:

        Upgrading label activity names - 5/5.
        100%
        

      7. Confirm upgrade succeeds without exceptions
      8. Manually navigate back to the following URL:

        WWWROOT/mdl-78010-generator.php
        

      9. Confirm you see Number of labels with PLUGINFILE: 0
      Show
      Ensure testing with Oracle Copy mdl-78010-generator.php (from MDL-78010 ) to your DIRROOT Log in as admin Manually navigate to the following URL: WWWROOT/mdl-78010-generator.php Tick/select Downgrade label module to force the upgrade process execution Leave everything else as default Press Generate Navigate to Site administration to trigger upgrade Confirm you see the following progress: Upgrading label activity names - 5/5. 100% Confirm upgrade succeeds without exceptions Manually navigate back to the following URL: WWWROOT/mdl-78010-generator.php Confirm you see Number of labels with PLUGINFILE: 0

    Description

      Actualizando la versión

      mod_label

      Error al leer de la base de datos

      Más información sobre este error
      Información de depuración: ORA-00932: inconsistent datatypes: expected - got CLOB
      SELECT * FROM n_label WHERE name LIKE :o_tofind ESCAPE '\' ORDER BY id, name, intro
      [array (
      'o_tofind' => '%@@PLUGINFILE@@%',
      )]
      Error code: dmlreadexception

       

       

      al momento de actualizars moodle 311 al 432 aparece este error con oracle 19 impidiendo la actualizacion

      Stacktrace in English

      Upgrading to new version
      mod_label
       
      Error reading from database
       
      More information about this error
      Debug info: ORA-00932: inconsistent datatypes: expected - got CLOB
      SELECT * FROM m_label WHERE name LIKE :o_tofind ESCAPE '\' ORDER BY id, name, intro
      [array (
      'o_tofind' => '%@@PLUGINFILE@@%',
      )]
      Error code: dmlreadexception
      Stack trace:
       
          line 494 of /lib/dml/moodle_database.php: dml_read_exception thrown
          line 272 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
          line 1096 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
          line 1406 of /lib/dml/moodle_database.php: call to oci_native_moodle_database->get_recordset_sql()
          line 58 of /mod/label/db/upgrade.php: call to moodle_database->get_recordset_select()
          line 953 of /lib/upgradelib.php: call to xmldb_label_upgrade()
          line 696 of /lib/upgradelib.php: call to upgrade_plugins_modules()
          line 1983 of /lib/upgradelib.php: call to upgrade_plugins()
          line 726 of /admin/index.php: call to upgrade_noncore()
      

      The problem is the ... ORDER BY ..., intro line, which can't work on Oracle because it can't sort text fields

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              noesis Alberto
              Andrew Lyons Andrew Lyons
              Mathew May Mathew May
              Kim Jared Lucas Kim Jared Lucas
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours, 50 minutes
                  3h 50m

                  Clockify

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