DB Error in Quiz & SCORM Module

DB Error in Quiz & SCORM Module

by Rajesh Krishnan -
Number of replies: 4

Hi,


We are using Moodle 2.9 version.   We are getting below error.

1) During the submission of quiz, we are getting DB Error.

2) Fetch Error during SCORM package update.

Average of ratings: -
In reply to Rajesh Krishnan

Re: DB Error in Quiz & SCORM Module

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

Please turn debugging on and then tell us exact errors.  There is not much we can do without more information!

In reply to Emma Richardson

Re: DB Error in Quiz & SCORM Module

by Rajesh Krishnan -

Please find the error message for DB error

Default exception handler: Error reading from database Debug: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
COMMIT TRANSACTION\n[NULL]\nError code: dmlreadexception\n* line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown\n*
line 242 of /lib/dml/mssql_native_moodle_database.php: call to moodle_database->query_end()
line 1366 of /lib/dml/mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
line 2408 of /lib/dml/moodle_database.php: call to mssql_native_moodle_database->commit_transaction()
line 92 of /lib/dml/moodle_transaction.php: call to moodle_database->commit_delegated_transaction()
line 197 of /mod/quiz/processattempt.php: call to moodle_transaction->allow_commit()


We are using Moodle 2.9 and below is Software stack

Apache/2.4.6

PHP 5.4.16

MSSQL 2012


In reply to Rajesh Krishnan

Re: DB Error in Quiz & SCORM Module

by Rajesh Krishnan -

Any updates to this issue?

In reply to Rajesh Krishnan

Re: DB Error in Quiz & SCORM Module

by Mathew Gancarz -
Picture of Core developers

Hi Rajesh, is this something that worked before and stopped working, or is it a brand new setup?

Which specific 2.9 are you running? If it's not the latest, perhaps updating to 2.9.2 or later will help? I found this possibly related, fixed in 2.9.2 issue: https://tracker.moodle.org/browse/MDL-51245