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

ORA error: Errors when restoring a zipped course

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.7.4, 1.8.4, 1.9, 2.0
    • 1.7.1, 1.8
    • 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

      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

            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.