Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-10575

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 1.8.3
    • 1.7.1, 1.8.2
    • None
    • Solaris 10,
      Oracle 10,
      Firefox 2.0.0.2,
      Developer messages on
    • Oracle
    • MOODLE_17_STABLE, MOODLE_18_STABLE
    • MOODLE_18_STABLE

      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

            stronk7 Eloy Lafuente (stronk7)
            protzek D P
            Nobody Nobody
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.