Hola buenos dias, tengo un problema al actualizar moodle, me sale el siguiente error:
Installation
System
DDL sql execution error
More information about this error
It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation.
Debug info: Table 'mdl_q0nju9pk9xgjnwotconfig' already exists
CREATE TABLE mdl_q0nju9pk9xgjnwotconfig (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
value LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 DEFAULT COLLATE = utf8_general_ci
Error code: ddlexecuteerror
CREATE TABLE mdl_q0nju9pk9xgjnwotconfig (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
value LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 DEFAULT COLLATE = utf8_general_ci
Error code: ddlexecuteerror
Stack trace:
- line 429 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 842 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 88 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
- line 77 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
- line 417 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
- line 369 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
- line 1479 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
- line 202 of /admin/index.php: call to install_core()
Como soluciono este problema?
