Debug info: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
SELECT cm.id AS cmid, cmc.*,
CASE WHEN cmv.id IS NULL THEN 0 ELSE 1 END AS viewed
FROM mdl_course_modules cm
LEFT JOIN mdl_course_modules_completion cmc
ON cmc.coursemoduleid = cm.id AND cmc.userid = ?
LEFT JOIN mdl_course_modules_viewed cmv
ON cmv.coursemoduleid = cm.id AND cmv.userid = ?
INNER JOIN mdl_modules m ON m.id = cm.module
WHERE m.visible = 1 AND cm.course = ?
[array (
0 => 1,
1 => 1,
2 => '362',
)]
Error code: dmlreadexception
SELECT cm.id AS cmid, cmc.*,
CASE WHEN cmv.id IS NULL THEN 0 ELSE 1 END AS viewed
FROM mdl_course_modules cm
LEFT JOIN mdl_course_modules_completion cmc
ON cmc.coursemoduleid = cm.id AND cmc.userid = ?
LEFT JOIN mdl_course_modules_viewed cmv
ON cmv.coursemoduleid = cm.id AND cmv.userid = ?
INNER JOIN mdl_modules m ON m.id = cm.module
WHERE m.visible = 1 AND cm.course = ?
[array (
0 => 1,
1 => 1,
2 => '362',
)]
Error code: dmlreadexception
Stack trace:
- line 497 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
- line 1364 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
- line 1070 of /lib/completionlib.php: call to mysqli_native_moodle_database->get_records_sql()
- line 70 of /completion/classes/cm_completion_details.php: call to completion_info->get_data()
- line 317 of /completion/classes/cm_completion_details.php: call to core_completion\cm_completion_details->__construct()
- line 71 of /course/format/classes/output/local/content/cm/completion.php: call to core_completion\cm_completion_details::get_instance()
- line 245 of /course/format/classes/output/local/content/cm.php: call to core_courseformat\output\local\content\cm\completion->export_for_template()
- line 134 of /course/format/classes/output/local/content/cm.php: call to core_courseformat\output\local\content\cm->add_completion_data()
- line 107 of /course/format/classes/output/local/content/section/cmitem.php: call to core_courseformat\output\local\content\cm->export_for_template()
- line 122 of /course/format/classes/output/local/content/section/cmlist.php: call to core_courseformat\output\local\content\section\cmitem->export_for_template()
- line 241 of /course/format/classes/output/local/content/section.php: call to core_courseformat\output\local\content\section\cmlist->export_for_template()
- line 172 of /course/format/classes/output/local/content/section.php: call to core_courseformat\output\local\content\section->add_cm_data()
- line 46 of /course/format/topics/classes/output/courseformat/content/section.php: call to core_courseformat\output\local\content\section->export_for_template()
- line 181 of /course/format/classes/output/local/content.php: call to format_topics\output\courseformat\content\section->export_for_template()
- line 86 of /course/format/classes/output/local/content.php: call to core_courseformat\output\local\content->export_sections()
- line 54 of /course/format/topics/classes/output/courseformat/content.php: call to core_courseformat\output\local\content->export_for_template()
- line 87 of /lib/classes/output/plugin_renderer_base.php: call to format_topics\output\courseformat\content->export_for_template()
- line 88 of /course/format/classes/output/section_renderer.php: call to core\output\plugin_renderer_base->render()
- line 214 of /course/section.php: call to core_courseformat\output\section_renderer->render()