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

ORA error: "creating scales" error when restoring from a zipped course

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.12, 1.9.8
    • 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_18_STABLE, MOODLE_19_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...
      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'

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

              Created:
              Updated:
              Resolved:

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