Fórum geral

Erro de execução DDL SQL
Outras informações sobre este erro
×Informações de depuração: Unknown collation: 'utf8mb4_0900_ai_ci'
CREATE TEMPORARY TABLE backup_ids_temp (
id BIGINT(10) NOT NULL auto_increment,
backupid VARCHAR(32) COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT
'c5c875ade703274ad8d3783b8c23a338',
itemname VARCHAR(160) COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
itemid BIGINT(10) NOT NULL,
newitemid BIGINT(10) NOT NULL DEFAULT 0,
parentitemid BIGINT(10),
info LONGTEXT COLLATE utf8mb4_0900_ai_ci,
CONSTRAINT PRIMARY KEY (id)
) DEFAULT COLLATE utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
;
CREATE INDEX backidstemp_bacitepar_ix ON backup_ids_temp (backupid,
itemname, parentitemid)
;
CREATE INDEX backidstemp_bacitenew_ix ON backup_ids_temp (backupid,
itemname, newitemid)
;
CREATE UNIQUE INDEX backidstemp_baciteite_uix ON backup_ids_temp (backupid,
itemname, itemid)
Error code: ddlexecuteerror
×Rastreamento de pilha:
line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception
thrown
line 1098 of /lib/dml/mysqli_native_moodle_database.php: call to
moodle_database->query_end()
line 77 of /lib/ddl/database_manager.php: call to
mysqli_native_moodle_database->change_database_structure()
line 469 of /lib/ddl/database_manager.php: call to database_manager-
>execute_sql_arr()
line 139 of /backup/util/dbops/backup_controller_dbops.class.php: call to
database_manager->create_temp_table()
line 41 of /backup/moodle2/backup_stepslib.php: call to
backup_controller_dbops::create_backup_ids_temp_table()
line 34 of /backup/util/plan/backup_execution_step.class.php: call to
create_and_clean_temp_stuff->define_execution()
line 181 of /backup/util/plan/base_task.class.php: call to
backup_execution_step->execute()
line 178 of /backup/util/plan/base_plan.class.php: call to base_task-
>execute()line 145 of /backup/util/plan/backup_plan.class.php: call to base_plan-
>execute()
line 410 of /backup/controller/backup_controller.class.php: call to
backup_plan->execute()
line 132 of /admin/tool/recyclebin/classes/category_bin.php: call to
backup_controller->execute_plan()
line 185 of /admin/tool/recyclebin/lib.php: call to
tool_recyclebin\category_bin->store_item()
line 5138 of /lib/moodlelib.php: call to tool_recyclebin_pre_course_delete()
line 68 of /course/delete.php: call to delete_course()


a hospedagem afirma que é problema com o bd
um programador afirma que é falta de recurso da hospedagem