Importar Base de datos

Importar Base de datos

de Diego Ruggirello -
Número de respuestas: 1

Buenas tardes gente,

Como siempre vengo a molestarlos.

Tengo el siguiente inconveniente, importe una base de datos que tenia a mi moodle con Centos7 y a la hora de actualizar la base de datos me salta el siguiente problema:


Probe en modificar los parametros de memoria y limite del archivo php.ini y realice una limpieza de cache del php.


Alguna sugerencia?

Muchas gracias!

Actualizando la versión - Moodle 3.0.10 (Build: 20170508)

qtype_ddimageortext

Error de ejecución DDL sql

Más información sobre este error

Debug info: Table 'mdl_qtype_ddimageortext' already exists
CREATE TABLE mdl_qtype_ddimageortext (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
shuffleanswers SMALLINT(4) NOT NULL DEFAULT 1,
correctfeedback LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
correctfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
partiallycorrectfeedback LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
partiallycorrectfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
incorrectfeedback LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
incorrectfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
shownumcorrect TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_qtypddim_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Defines drag and drop (text or images onto a background imag'
;
CREATE TABLE mdl_qtype_ddimageortext_drops (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
no BIGINT(10) NOT NULL DEFAULT 0,
xleft BIGINT(10) NOT NULL DEFAULT 0,
ytop BIGINT(10) NOT NULL DEFAULT 0,
choice BIGINT(10) NOT NULL DEFAULT 0,
label LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_qtypddimdrop_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Drop boxes'
;
CREATE TABLE mdl_qtype_ddimageortext_drags (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
no BIGINT(10) NOT NULL DEFAULT 0,
draggroup BIGINT(10) NOT NULL DEFAULT 0,
infinite SMALLINT(4) NOT NULL DEFAULT 0,
label LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_qtypddimdrag_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Images to drag. Actual file names are not stored here we use'
Error code: ddlexecuteerror
Stack trace:
  • line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
  • line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
  • line 412 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
  • line 364 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
  • line 508 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
  • line 1647 of /lib/upgradelib.php: call to upgrade_plugins()
  • line 683 of /admin/index.php: call to upgrade_noncore()

Promedio de valoraciones: -