Issue Details (XML | Word | Printable)

Key: MDL-19223
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Eloy Lafuente (stronk7)
Reporter: Roger Robins
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

SCORM import hangs with Moodle running on Linux connected to an Oracle Database

Created: 18/May/09 02:41 PM   Updated: 20/May/09 10:18 AM
Return to search
Component/s: SCORM
Affects Version/s: 2.0
Fix Version/s: None

File Attachments: 1. Zip Archive NSWTHMN203B.zip (493 kB)

Environment: Moodle 2.0 running on Linix Redhat ES 3.0 connected to Oracle 10.2 (oci native)

Database: Oracle
Participants: Eloy Lafuente (stronk7), Petr Skoda and Roger Robins
Security Level: None
Difficulty: Moderate
Affected Branches: MOODLE_20_STABLE


 Description  « Hide
The hang is due to a database INSERT into the SCORM table returning the wrong record id.
The code is line 45 of mod/scorm/lib.php - if (!$id = $DB->insert_record('scorm', $scorm)) {

The problem only appears when the sequence MBL_SCOR_ID_SEQ (MBL_ default prefix) next_val reaches double figures, then only the first digit of the sequence number is returned from the insert_record at line 45 of lib.php.

I've traced the problem down to the php oracle oci plugin and have logged a bug with www.php.net. I'd still like to know if there is a work around for this problem.
B.T.W. The php I'm running is 5.2.9 compiled again oracle 10.2 client.


 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
No commits have yet been performed on this issue.