moodle 3.6.2+
A new problem.
Impossible to save or restore a curse :
message : "Erreur d'exécution DDL sql"
Any idea ?
Thank's for your help
Turn on full developer debugging and see what the full error message says...
here the message :
Erreur d'exécution DDL sql
×Debug info: Unknown collation: 'utf8mb4'
CREATE TEMPORARY TABLE mdl_backup_ids_temp (
id BIGINT(10) NOT NULL auto_increment,
backupid VARCHAR(32) COLLATE utf8mb4 NOT NULL DEFAULT '78acc6a82450edf027e2d78aaf1d6d39',
itemname VARCHAR(160) COLLATE utf8mb4 NOT NULL DEFAULT '',
itemid BIGINT(10) NOT NULL,
newitemid BIGINT(10) NOT NULL DEFAULT 0,
parentitemid BIGINT(10),
info LONGTEXT COLLATE utf8mb4,
CONSTRAINT PRIMARY KEY (id)
) DEFAULT COLLATE utf8mb4 ROW_FORMAT=DYNAMIC
;
CREATE INDEX mdl_backidstemp_bacitepar_ix ON mdl_backup_ids_temp (backupid, itemname, parentitemid)
;
CREATE INDEX mdl_backidstemp_bacitenew_ix ON mdl_backup_ids_temp (backupid, itemname, newitemid)
;
CREATE UNIQUE INDEX mdl_backidstemp_baciteite_uix ON mdl_backup_ids_temp (backupid, itemname, itemid)
Error code: ddlexecuteerror
CREATE TEMPORARY TABLE mdl_backup_ids_temp (
id BIGINT(10) NOT NULL auto_increment,
backupid VARCHAR(32) COLLATE utf8mb4 NOT NULL DEFAULT '78acc6a82450edf027e2d78aaf1d6d39',
itemname VARCHAR(160) COLLATE utf8mb4 NOT NULL DEFAULT '',
itemid BIGINT(10) NOT NULL,
newitemid BIGINT(10) NOT NULL DEFAULT 0,
parentitemid BIGINT(10),
info LONGTEXT COLLATE utf8mb4,
CONSTRAINT PRIMARY KEY (id)
) DEFAULT COLLATE utf8mb4 ROW_FORMAT=DYNAMIC
;
CREATE INDEX mdl_backidstemp_bacitepar_ix ON mdl_backup_ids_temp (backupid, itemname, parentitemid)
;
CREATE INDEX mdl_backidstemp_bacitenew_ix ON mdl_backup_ids_temp (backupid, itemname, newitemid)
;
CREATE UNIQUE INDEX mdl_backidstemp_baciteite_uix ON mdl_backup_ids_temp (backupid, itemname, itemid)
Error code: ddlexecuteerror
×Stack trace:
- line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 1070 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 467 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 119 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()
- line 322 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()
- line 136 of /backup/util/ui/backup_ui.class.php: call to backup_controller->execute_plan()
- line 146 of /backup/backup.php: call to backup_ui->execute()
any idea about the error ?
just a problem of file.
solved...