Moodle

ORA error: Errors when restoring a zipped course

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major 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

  1. File
    restorelib.php
    06/Aug/07 7:36 AM
    312 kB
    Eloy Lafuente (stronk7)
  1. moodle_bug_restore2.JPG
    108 kB
    26/Apr/07 8:10 PM

Issue Links

This issue is a clone of:
MDL-12186 Oracle SQL Statement problem -- unable to list glossary entries Minor Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

Hi,

can you test under Oracle if the lib/restorelib.php file above works properly?

Note that such file is to be used under Moodle 1.7 latest!

TIA and ciao

Show
Eloy Lafuente (stronk7) added a comment - Hi, can you test under Oracle if the lib/restorelib.php file above works properly? Note that such file is to be used under Moodle 1.7 latest! TIA and ciao
Hide
Permalink
Joseph Boiteau added a comment -

Same problem as mine:
Oracle doesn't allow that SQL syntax with the datatype CLOB (field "description" here)

the next statement is crashing:
SELECT * FROM m_groups WHERE description = '';
but this other is working perfectly: (lang isn't CLOB but varchar2)
SELECT * FROM m_groups WHERE lang = '';

I don't know how to handle it !

Show
Joseph Boiteau added a comment - Same problem as mine: Oracle doesn't allow that SQL syntax with the datatype CLOB (field "description" here) the next statement is crashing: SELECT * FROM m_groups WHERE description = ''; but this other is working perfectly: (lang isn't CLOB but varchar2) SELECT * FROM m_groups WHERE lang = ''; I don't know how to handle it !
Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

This was comitted on September to CVS, From MOODLE_17_STABLE to HEAD. I forgot to relate it to this bug.

Closing, ciao

Show
Eloy Lafuente (stronk7) added a comment - This was comitted on September to CVS, From MOODLE_17_STABLE to HEAD. I forgot to relate it to this bug. Closing, ciao

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.