Hi Petr,

Experienced this issue when upgrading a site from 1.9.10 -> 2.0 RC1.

Debug info: Column 'pagetype' cannot be null

INSERT INTO mdl_block_positions (blockinstanceid, contextid, pagetype, subpage, visible, region, weight)
SELECT id, contextid,
CASE WHEN pagetypepattern = 'course-view-*' THEN
(SELECT CONCAT('course-view-', format)
FROM mdl_course
JOIN mdl_context ON mdl_course.id = mdl_context.instanceid
WHERE mdl_context.id = contextid)
ELSE pagetypepattern END,
CASE WHEN subpagepattern IS NULL THEN ''
ELSE subpagepattern END,
0, defaultregion, defaultweight
FROM mdl_block_instances WHERE visible = 0 AND pagetypepattern <> 'admin-*'
[array (
)]

Stack trace:

• line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
• line 645 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
• line 1858 of /lib/db/upgrade.php: call to mysqli_native_moodle_database->execute()
• line 1309 of /lib/upgradelib.php: call to xmldb_main_upgrade()
• line 264 of /admin/index.php: call to upgrade_core()