-
Bug
-
Resolution: Fixed
-
Major
-
4.3.2
-
Oracle
-
MOODLE_403_STABLE
-
MOODLE_402_STABLE, MOODLE_403_STABLE
-
MDL-80523-403 -
- 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
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
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
