Hi!
On my localhost Moodle test site I (stupidly) created a (large) Test course from Site administration / Development / Make test course.
Now I can't delete it! I get this error message. What can I do?
Note.- In the error message quoted below I have removed almost all of the [array ([array (12 => contents, which consists of a lot of apparent garbage.
Deleting test course
Error writing to database
More information about this error
Debug info: MySQL server has gone away
INSERT INTO mdl_backup_controllers (backupid,operation,type,itemid,format,interactive,purpose,userid,status,execution,executiontime,checksum,controller,timecreated,timemodified) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
-- line 1403 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
-- line 97 of \backup\util\dbops\backup_controller_dbops.class.php: call to mysqli_native_moodle_database->insert_record()
-- line 439 of \backup\controller\backup_controller.class.php: call to backup_controller_dbops::save_controller()
-- line 206 of \backup\controller\backup_controller.class.php: call to backup_controller->save_controller()
-- line 161 of \backup\controller\backup_controller.class.php: call to backup_controller->set_status()
-- line 130 of \admin\tool\recyclebin\classes\category_bin.php: call to backup_controller->__construct()
-- line 185 of \admin\tool\recyclebin\lib.php: call to tool_recyclebin\category_bin->store_item()
-- line 4998 of \lib\moodlelib.php: call to tool_recyclebin_pre_course_delete()
-- line 68 of \course\delete.php: call to delete_course()
[array (
0 => 'a7a98ffa0fc72e0f1b3a4a03fb2373f2',
1 => 'backup',
2 => 'course',
3 => '7',
4 => 'moodle2',
5 => 0,
6 => 50,
7 => '2',
8 => 700,
9 => 1,
10 => 0,
11 => 'bec69d387a218ca52a81ae1487a6e00e',
12 => 'TzoxNzoiYmFja3VwX2NvbnRyb2xsZXIiOjIxOntzOjExOiIAKgBiYWNrdXBpZCI7czozMjoiYTdhOThmZmEwZmM3MmUwZjFiM2E0YTAzZ
.........
7fX1zOjE3OiIAKgByZWxlYXNlc2Vzc2lvbiI7YjowO3M6NzoiACoAY29weSI7Tjt9',
13 => 1633011455,
14 => 0,
)]
Error code: dmlwriteexception
Stack trace:
line 489 of \lib\dml\moodle_database.php: dml_write_exception thrown
line 1357 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1403 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
line 97 of \backup\util\dbops\backup_controller_dbops.class.php: call to mysqli_native_moodle_database->insert_record()
line 439 of \backup\controller\backup_controller.class.php: call to backup_controller_dbops::save_controller()
line 206 of \backup\controller\backup_controller.class.php: call to backup_controller->save_controller()
line 161 of \backup\controller\backup_controller.class.php: call to backup_controller->set_status()
line 130 of \admin\tool\recyclebin\classes\category_bin.php: call to backup_controller->__construct()
line 185 of \admin\tool\recyclebin\lib.php: call to tool_recyclebin\category_bin->store_item()
line 4998 of \lib\moodlelib.php: call to tool_recyclebin_pre_course_delete()
line 68 of \course\delete.php: call to delete_course()