(ORA) errors with database upgrading from 1.7(.1) to 1.8(.2)

Hey Eloy,
are you back to normal business?

I would like to upgrade our moodle site from 1.7.1 to 1.8.2 and did a first quick test
I encountered some issues with the upgrading of the database structures.
Right on the first upgrade step seems to be a problem with some "context creations".
There were many more errors like that, but with different levels and instances...

Snippet no. 1:
Processing context relations (125/127)
Error: Invalid context creation request for level "80", instance "3".

• line 3877 of lib/accesslib.php: call to debugging()
• line 3918 of lib/accesslib.php: call to insert_context_rel()
• line 527 of lib/db/upgrade.php: call to build_context_rel()
• line 322 of admin/index.php: call to xmldb_main_upgrade()

Error: Invalid context creation request for level "80", instance "4".

• line 3877 of lib/accesslib.php: call to debugging()
• line 3918 of lib/accesslib.php: call to insert_context_rel()
• line 527 of lib/db/upgrade.php: call to build_context_rel()
• line 322 of admin/index.php: call to xmldb_main_upgrade()

----------------------------------------------------------------------------------------------------------------------------------------------

Then at a later step, I did get some ORA errors (ORA-01400: cannot insert NULL into...) apparently coming from some of our group stuff:

Snippet No.2
upgrading database
group

(oci8po): SELECT * FROM m_groups_members_temp

stdClass Object
(
[courseid] => 2
[name] => Gruppe A
[description] =>
[password] =>
[lang] => de
[theme] =>
[picture] => 0
[hidepicture] => 0
[timecreated] => 1133178615
[timemodified] => 1134986852
[id] => 1
)

(oci8po): INSERT INTO m_groups (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified) VALUES ('1','Gruppe A','', '','de', '','0','0', '1133178615','1134986852')
Warning: ociexecute() [function.ociexecute]: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich in /moodle/apache/2.2.4/htdocs/moodle182/lib/adodb/drivers/adodb-oci8.inc.php on line 1017
1400: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich

ADOConnection._Execute(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
..., false) % line 769, file: adodb-oci8.inc.php
ADODB_oci8.Execute(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
...) % line 89, file: dmllib.php
execute_sql(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
...) % line 331, file: dbbasicgrouplib.php
groups_db_upgrade_group(2, Object:stdClass) % line 155, file: upgrade.php
groups_transfer_db() % line 39, file: upgrade.php

ErrorScroll to next warning

stdClass Object
(
[courseid] => 2
[name] => Gruppe E
[description] =>
[password] =>
[lang] => de
[theme] =>
[picture] => 0
[hidepicture] => 0
[timecreated] => 1133718608
[timemodified] => 1136324634
[id] => 2
)

(oci8po): INSERT INTO m_groups (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified) VALUES ('2','Gruppe E','', '','de', '','0','0', '1133718608','1136324634')
Warning: ociexecute() [function.ociexecute]: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich in /moodle/apache/2.2.4/htdocs/moodle182/lib/adodb/drivers/adodb-oci8.inc.php on line 1017
1400: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich

ADOConnection._Execute(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
..., false) % line 769, file: adodb-oci8.inc.php
ADODB_oci8.Execute(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
...) % line 89, file: dmllib.php
execute_sql(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
...) % line 331, file: dbbasicgrouplib.php
groups_db_upgrade_group(2, Object:stdClass) % line 155, file: upgrade.php
groups_transfer_db() % line 39, file: upgrade.php

Scroll to previous warningErrorScroll to next warning

stdClass Object
(
[courseid] => 2
[name] => Gruppe B
[description] =>
[password] =>
[lang] => de
[theme] =>
[picture] => 0
[hidepicture] => 0
[timecreated] => 1133718615
[timemodified] => 1134564997
[id] => 3
)

(oci8po): INSERT INTO m_groups (id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified) VALUES ('3','Gruppe B','', '','de', '','0','0', '1133718615','1134564997')
Warning: ociexecute() [function.ociexecute]: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich in /moodle/apache/2.2.4/htdocs/moodle182/lib/adodb/drivers/adodb-oci8.inc.php on line 1017
1400: ORA-01400: Einfügen von NULL in ("BOCHUM"."M_GROUPS"."ENROLMENTKEY") nicht möglich

ADOConnection._Execute(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
..., false) % line 769, file: adodb-oci8.inc.php
ADODB_oci8.Execute(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
...) % line 89, file: dmllib.php
execute_sql(INSERT INTO m_groups
(id,name,description, enrolmentkey,lang,theme,picture,hidepicture, timecreated,timemodified)
...) % line 331, file: dbbasicgrouplib.php
groups_db_upgrade_group(2, Object:stdClass) % line 155, file: upgrade.php
groups_transfer_db() % line 39, file: upgrade.php

Scroll to previous warningErrorScroll to next warning

stdClass Object
(
[courseid] => 2
[name] => Gruppe C
[description] =>
[password] =>
[lang] => de
[theme] =>
[picture] => 0
[hidepicture] => 0
[timecreated] => 1133718622
[timemodified] => 1135953543
[id] => 4
)

I will test the upgrading a bit more in the coming weeks with a bigger database