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
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
Roger Robins made changes - 18/May/09 02:42 PM
Field Original Value New Value
Attachment NSWTHMN203B.zip [ 17332 ]
Petr Skoda made changes - 18/May/09 03:33 PM
Assignee Dan Marsden [ danmarsden ] Eloy Lafuente (stronk7) [ stronk7 ]
Roger Robins made changes - 19/May/09 11:36 AM
Description 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 suspect the problem is buried in Oci_native_moodle_database.php.

 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 suspect the problem is buried in Oci_native_moodle_database.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.
Roger Robins made changes - 19/May/09 11:36 AM
Description 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 suspect the problem is buried in Oci_native_moodle_database.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.
 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.

Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.5-#360) - Bug/feature request - Atlassian news - Contact Administrators