Issue Details (XML | Word | Printable)

Key: MDL-13332
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Martin Dougiamas
Reporter: Sara Arjona
Votes: 0
Watchers: 1
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Ambiguosly column message restoring a course - ORA

Created: 05/Feb/08 06:31 PM   Updated: 09/Mar/08 09:40 PM
Return to search
Component/s: Backup
Affects Version/s: 1.8.4
Fix Version/s: None

Environment: Solaris + Oracle

Database: Oracle
URL: http://agora.xtec.cat
Participants: Martin Dougiamas and Sara Arjona
Security Level: None
Affected Branches: MOODLE_18_STABLE


 Description  « Hide
We have found the following problem restoring a backup course:

S'estan creant els grups ("Creating groups...")

ORA-00918: column ambiguously defined

SELECT * FROM mlgroups g, mlgroups_courses_groups gcg WHERE gcg.courseid = 181 AND g.id = gcg.groupid AND g.name = 'Group B' AND dbms_lob.substr(description, 32,1) = dbms_lob.substr('Description of the group', 32,1)

    * line 677 of lib/dmllib.php: call to debugging()
    * line 474 of lib/dmllib.php: call to get_recordset_sql()
    * line 2234 of backup/restorelib.php: call to get_record_sql()
    * line 6153 of backup/restorelib.php: call to restore_create_groups()
    * line 47 of backup/restore_execute.html: call to restore_execute()
    * line 162 of backup/restore.php: call to include_once()

Otherwise, when we execute this SQL Query directly in our database it works fine.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.