Get an error message during upgrading from Moodle 198 to Moodle 2.0 / Moodle 2.0.1

System

Error writing to database

More information about this error

Debug info: Column 'itemid' cannot be null
UPDATE mdl_role_assignments
SET itemid = (SELECT MIN(mdl_enrol.id)
FROM mdl_enrol
JOIN mdl_context ON (mdl_context.contextlevel = 50 AND mdl_context.instanceid = mdl_enrol.courseid)
WHERE mdl_role_assignments.component = CONCAT('enrol_', mdl_enrol.enrol) AND mdl_context.id = mdl_role_assignments.contextid)
WHERE component <> 'enrol_manual' AND component LIKE 'enrol_%'
[array (
)]
Stack trace:
line 394 of \lib\dml\moodle_database.php: dml_write_exception thrown
line 682 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 4419 of \lib\db\upgrade.php: call to mysqli_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()