I've upgraded my 2.9.3 moodle site to 3.0.
The first problem is a crashing question type plugin.
Any suggestion how to solve this?
Thanks,
Hans.
qtype_ddwtos
DDL sql uitvoeringsfout
Debug info: Table 'mood_question_ddwtos' already exists
CREATE TABLE mood_question_ddwtos (
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 mood_quesddwt_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Defines drag and drop (words into sentences) questions'
Error code: ddlexecuteerror
CREATE TABLE mood_question_ddwtos (
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 mood_quesddwt_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Defines drag and drop (words into sentences) questions'
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 1641 of /lib/upgradelib.php: call to upgrade_plugins()
- line 677 of /admin/index.php: call to upgrade_noncore()