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

ORA error: Errors when restoring a zipped course

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.1, 1.8
    • 1.7.4, 1.8.4, 1.9, 2.0
    • Database SQL/XMLDB
    • None
    • Solaris 10,
      Oracle 10g,
      Firefox 2.0.0.2,
      Developer messages on
    • Oracle
    • MOODLE_17_STABLE, MOODLE_18_STABLE
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
    • /backup/restore.php

    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

          has a clone

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-12186 Oracle SQL Statement problem -- unable to list glossary entries

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              protzek D P
              Nobody Nobody
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                11/Jan/08