We are running 2.1 and cannot attempt any quizzes. Quizzes that we attempt to complete as any moodle role (admin, teacher, student) all give us the "error writing to database" that I posted yesterday.
I have also learned that when you attempt to change the Maximum Quiz Grade it also gives the Error Writing to Database.
Possibly these issues are related. PLEASE HELP.
Here is the debugging message when attempting to change the quiz grade: (note - on yesterday's post I added the debugging message for attempting the quiz)
Error writing to database
Debug info: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
UPDATE mdl_quiz SET grade = ? WHERE id = ?
[array (
0 => 15,
1 => '210',
)]
UPDATE mdl_quiz SET grade = ? WHERE id = ?
[array (
0 => 15,
1 => '210',
)]
Stack trace:
- line 396 of \lib\dml\moodle_database.php: dml_write_exception thrown
- line 1056 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1464 of \lib\dml\moodle_database.php: call to mysqli_native_moodle_database->set_field_select()
- line 461 of \mod\quiz\locallib.php: call to moodle_database->set_field()
- line 372 of \mod\quiz\edit.php: call to quiz_set_grade()