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

ORA error: Errors when restoring a zipped course

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.1, 1.8
    • Fix Version/s: 1.7.4, 1.8.4, 1.9, 2.0
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Solaris 10,
      Oracle 10g,
      Firefox 2.0.0.2,
      Developer messages on
    • Database:
      Oracle
    • URL:
      /backup/restore.php
    • Affected Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      We have made a course backup on a 1.7.1-mysql-windows-system and uploaded the zip file to our new 1.7.1-oracle-solaris-system!

      We started the restore process and got some ora errors (take a look at the screenshot)

      The process doesn't stop and in the end finishes successfully...but isn't there a problem?!

      Here are the better readable error messages:

      1. Creating groups
        ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe A' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149
      ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe E' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149
      ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe B' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149
      ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe C' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149
      ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe D' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149
      ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe F' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149
      ORA-00932: nicht übereinstimmende Datentypen

      SELECT * FROM m_groups WHERE courseid = '6' AND name = 'Gruppe G' AND description = ''

      Notice: Undefined index: MEMBERS in /moodle/apache/2.2.4/htdocs/moodle/backup/restorelib.php on line 2149

      1. . Creating events

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              protzek D P
              Tester:
              Nobody
              Participants:
              Component watchers:
              Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Jan/08