An instructor created a quiz, and when you try to take the quiz it goes to an error page. I did a backup of the course on the production Moodle and recovered it on our development Moodle to test. It gives a different error page on the development one. This quiz is only one multiple choice question, the only quiz having this issue, and it happens regardless of user. The error page with debugging information and version information is below.
OS: Ubuntu 17.10
PHP: 7.1.8
Moodle: 3.4.4+ (production) and 3.4 (development)
Warning: mysqli::query(): MySQL server has gone away in /srv/www/public.com/public/moodle34-2017111304.08/lib/dml/mysqli_native_moodle_database.php on line 1327
Warning: mysqli::query(): Error reading result set's header in /srv/www/public.com/public/moodle34-2017111304.08/lib/dml/mysqli_native_moodle_database.php on line 1327
INSERT INTO mdl_question_attempt_steps (questionattemptid,sequencenumber,state,fraction,timecreated,userid) VALUES(?,?,?,?,?,?)
[array (
0 => 14134347,
1 => 0,
2 => 'todo',
3 => NULL,
4 => 1537983288,
5 => '2',
)]
Error code: dmlwriteexception
- line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
- line 1329 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1375 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 227 of /question/engine/datalib.php: call to mysqli_native_moodle_database->insert_record()
- line 148 of /question/engine/datalib.php: call to question_engine_data_mapper->insert_question_attempt_step()
- line 100 of /question/engine/datalib.php: call to question_engine_data_mapper->insert_question_attempt()
- line 100 of /question/engine/lib.php: call to question_engine_data_mapper->insert_questions_usage_by_activity()
- line 120 of /question/preview.php: call to question_engine::save_questions_usage_by_activity()
SELECT * FROM mdl_course_categories WHERE id = ?
[array (
0 => '1',
)]
Error code: dmlreadexception
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1245 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1571 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
- line 1543 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
- line 1522 of /lib/dml/moodle_database.php: call to moodle_database->get_record_select()
- line 1868 of /lib/pagelib.php: call to moodle_database->get_record()
- line 1856 of /lib/pagelib.php: call to moodle_page->load_category()
- line 1888 of /lib/pagelib.php: call to moodle_page->ensure_category_loaded()
- line 472 of /lib/pagelib.php: call to moodle_page->ensure_categories_loaded()
- line 820 of /lib/pagelib.php: call to moodle_page->magic_get_categories()
- line 1644 of /lib/pagelib.php: call to moodle_page->__get()
- line 1552 of /lib/pagelib.php: call to moodle_page->resolve_theme()
- line 1844 of /lib/setuplib.php: call to moodle_page->initialise_theme_and_output()
- line 374 of /lib/setuplib.php: call to bootstrap_renderer->__call()
- line ? of unknownfile: call to default_exception_handler()