[#MDL-9593] ORA error: Errors when restoring a zipped course

Issue Details (XML | Word | Printable)

Key:	MDL-9593
Type:	Bug
Status:	Resolved
Resolution:	Fixed
Priority:	Major
Assignee:	Eloy Lafuente (stronk7)
Reporter:	D P
Votes:	0
Watchers:	0

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

Moodle

ORA error: Errors when restoring a zipped course

Created: 26/Apr/07 08:10 PM Updated: 08/Dec/07 07:31 AM

Return to search

Component/s:

Database SQL/XMLDB

Affects Version/s:

1.7.1, 1.8

Fix Version/s:

1.7.4, 1.8.4, 1.9, 2.0

File Attachments:

restorelib.php (312 kB)

Image Attachments:

1. moodle_bug_restore2.JPG
(108 kB)

Environment:

« Hide

Solaris 10,
Oracle 10g,
Firefox 2.0.0.2,
Developer messages on

Issue Links:

Cloners

This issue is a clone of:

~~MDL-12186~~ Oracle SQL Statement problem -- unable to list glossary entries

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

Description

« Hide

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 »

All

Comments

Change History

Version Control

Sort Order:

[ Permalink | « Hide ]

Eloy Lafuente (stronk7) added a comment - 06/Aug/07 07:36 AM

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

Eloy Lafuente (stronk7) made changes - 06/Aug/07 07:36 AM

Field	Original Value	New Value
Attachment		restorelib.php [ 11638 ]

[ Permalink | « Hide ]

Joseph Boiteau added a comment - 16/Nov/07 11:48 PM

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 !

Joseph Boiteau made changes - 16/Nov/07 11:48 PM

Link

This issue is a clone of ~~MDL-12186~~ [ ~~MDL-12186~~ ]

[ Permalink | « Hide ]

Eloy Lafuente (stronk7) added a comment - 08/Dec/07 07:31 AM

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

Closing, ciao

Eloy Lafuente (stronk7) 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 ]

All content on this web site is made available under the GNU General Public License, unless otherwise stated.