|
|
| Database: |
Oracle
|
| URL: |
/backup/restore.php
|
| Participants: |
D P, Eloy Lafuente (stronk7) and Joseph Boiteau
|
| Security Level: |
None
|
| Resolved date: |
08/Dec/07
|
| Affected Branches: |
MOODLE_17_STABLE, MOODLE_18_STABLE
|
| Fixed Branches: |
MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
|
|
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
|
|
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 |
Show » |
made changes - 06/Aug/07 07:36 AM
| Field |
Original Value |
New Value |
|
Attachment
|
|
restorelib.php
[ 11638
]
|
made changes - 08/Dec/07 07:31 AM
|
Fix Version/s
|
|
1.7.4
[ 10243
]
|
|
Fix Version/s
|
|
1.9
[ 10190
]
|
|
Status
|
Open
[ 1
]
|
Resolved
[ 5
]
|
|
Fix Version/s
|
|
1.8.4
[ 10242
]
|
|
Fix Version/s
|
|
2.0
[ 10122
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
|
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