Discussions started by Bonnie Dilling

Moodle in English -> Installing and upgrading help -> Moodle 2.1.1 Fresh Install

by Bonnie Dilling -

We just installed 2.1.1 because our 2.1 site would not allow the quiz module to operate or import items between courses.  As I begin to set up categories to allow the restoring of courses from our 2.1 site, I receive an error message saying the following:

Coding error detected, it must be fixed by a programmer: paging_bar requires a perpage value.

More information about this error

Stack trace:
  • line 1936 of \lib\outputcomponents.php: coding_exception thrown
  • line 2123 of \lib\outputrenderers.php: call to paging_bar->prepare()
  • line 70 of \lib\outputrenderers.php: call to core_renderer->render_paging_bar()
  • line 2112 of \lib\outputrenderers.php: call to renderer_base->render()
  • line 261 of \course\category.php: call to core_renderer->paging_bar()
Can someone help me by telling me what this number is to be and how to find these codes of script to fix it?
Thank you for any help.
Average of ratings: -

Moodle in English -> Quiz -> Quiz Maximum Grade -Chaning this causes - Error Writing to Database

by Bonnie Dilling -

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

More information about this error

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',
)]
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()
Bonnie
Average of ratings: -

Moodle in English -> Quiz -> Error Writing to Database when Attempting a Quiz

by Bonnie Dilling -

We are using moodle 2.1 and whenever a teacher/student attempts a quiz, we receive "Error Writing to Database".  The debugging is on and this is what shows up:

Error writing to database

More information about this error

Debug info: Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'
INSERT INTO mdl_question_usages (contextid,component,preferredbehaviour) VALUES(?,?,?)
[array (
0 => '1172',
1 => 'mod_quiz',
2 => 'deferredfeedback',
)]
Stack trace:
  • line 396 of \lib\dml\moodle_database.php: dml_write_exception thrown
  • line 878 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 920 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
  • line 67 of \question\engine\datalib.php: call to mysqli_native_moodle_database->insert_record()
  • line 93 of \question\engine\lib.php: call to question_engine_data_mapper->insert_questions_usage_by_activity()
  • line 198 of \mod\quiz\startattempt.php: call to question_engine::save_questions_usage_by_activity()
I have checked the module settings and the quiz and everything seems normal.  I have created my own quiz to recreate this issue and try to determine the problem and no luck.
Any help would be appreciated.
Thank you
Bonnie
Average of ratings: Useful (1)

Moodle in English -> Quiz -> Moodle 2.1 - Using Quizzes and Questions from 1.9

by Bonnie Dilling -

Hello Tim and others,

We have upgraded to moodle 2.1 so we could import courses from moodle 1.9.  I have been able to import courses however they are not coming in successfully.  Mostly the problem lies within the quiz module.  I started doing backups in parts so that assignments, resources, and quizzes were restored in 2.1 separately.  When I restore the quizzes it fails - the screen goes blank and nothing happens.  It will not restore the quizzes.  I then started exported questions as xml files and importing into the moodle 2.1 courses, however when I click on the question bank in the 2.1 course, nothing shows up.  No questions show up nor does the box to choose a question type if you were to create a new question.

Please help.

Bonnie

Technology Coach/Moodle Admin for NBCSD

Average of ratings: -