Index: upgrade.php =================================================================== RCS file: /cvsroot/moodle/moodle/lib/db/upgrade.php,v retrieving revision 1.415 diff -u -r1.415 upgrade.php --- upgrade.php 22 May 2010 13:10:06 -0000 1.415 +++ upgrade.php 25 May 2010 09:58:26 -0000 @@ -1931,6 +1931,10 @@ if ($result && $oldversion < 2009050615) { $table = new xmldb_table('block_instances'); + /// Arrived here, any block_instances record without blockname is one + /// orphan block coming from 1.9. Just delete them. MDL-22503 + $DB->delete_records_select('block_instances', 'blockname IS NULL'); + /// Changing nullability of field blockname on table block_instances to not null $field = new xmldb_field('blockname', XMLDB_TYPE_CHAR, '40', null, XMLDB_NOTNULL, null, null, 'id'); $dbman->change_field_notnull($table, $field);