Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: 2.0.1
-
Fix Version/s: 2.0.2
-
Component/s: Installation
-
Labels:
-
Environment:Oracle 11g
-
Database:Oracle
-
Difficulty:Easy
-
Affected Branches:MOODLE_20_STABLE
-
Fixed Branches:MOODLE_20_STABLE
Description
The moodle upgrade uses an oracle reserved word as as a bind variable. The reserved word is "view". This is a reserved word in both 10g and 11g. The given error is below:
Debug info: ORA-01745: invalid host/bind variable name
UPDATE m_role_capabilities SET capability = :participate WHERE capability = :view
[array (
'participate' => 'moodle/course:participate',
'view' => 'moodle/course:view',
)]
Stack trace:
- line 394 of \lib\dml\moodle_database.php: dml_write_exception thrown
- line 268 of \lib\dml\oci_native_moodle_database.php: call to moodle_database->query_end()
- line 947 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
- line 2829 of \lib\db\upgrade.php: call to oci_native_moodle_database->execute()
- line 1309 of \lib\upgradelib.php: call to xmldb_main_upgrade()
- line 252 of \admin\index.php: call to upgrade_core()