Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.7.1, 1.8
-
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:
- 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
- . Creating events
Attachments
Issue Links
| This issue is a clone of: | ||||
| MDL-12186 | Oracle SQL Statement problem -- unable to list glossary entries |
|
|
|
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