I have tried to upgrade (a copy of) our
site to 2.1, unsuccessfully.
I get an error during the upgrade, quite early on:
ORA-01400: cannot insert NULL into ("RESTOREDMOODLEDB"."MDBLOCK_POSITIONS"."SUBPAGE")
a little more digging suggests that Oracle's stellar approach to ansi means that
'' is interpreted as NULL in a varchar field
hence the ELSE clause is trying to put NULL into a NOT NULL field in the database
I am unsure what behaviour is looked for from
MDBLOCK_POSITIONS.SUBPAGE = ''
so I am not comfortable trying to replace this to see if it would move things along.
any thoughts gratefully received