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

ORA error: "creating scales" error when restoring from 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.8.12, 1.9.8
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Solaris 10,
      Oracle 10g,
      Firefox 2.0.0.2,
      Developer messages on
    • Database:
      Oracle
    • Affected Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE
    • URL:
      /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...
      the problem seems to be, that the system doesn't find the standard scale (with the below sql statement), which is then duplicated in all of our courses (in /course/scales.php?id=x)
      Now we have more than one identical standard scale (with the german description: Durchaus differenziertes Wissen,Durchaus differenziert und fundiert,Zeigt ziemlich fundiertes Wissen) and can't delete them at /course/scales.php?id=x, because of the "2" under activties...so there is no delete button...

      Here is some better readable error message:

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

      SELECT * FROM m_scale WHERE scale = 'Durchaus differenziertes Wissen,Durchaus differenziert und fundiert,Zeigt ziemlich fundiertes Wissen' AND courseid = '0'

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              25/Mar/10