I cannot get the game module to install in Moodle 2.1. It shows up in notifications, I press the only button available, Upgrade, and I get an error.
Here is what I get:
mod_game
DDL sql execution error
Debug info: Table 'mdl_game' already exists
CREATE TABLE mdl_game (
id BIGINT(10) unsigned NOT NULL auto_increment,
name VARCHAR(255),
course BIGINT(10),
sourcemodule VARCHAR(50),
timeopen BIGINT(10) unsigned DEFAULT 0,
timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0,
quizid BIGINT(10),
glossaryid BIGINT(10),
glossarycategoryid BIGINT(10),
questioncategoryid BIGINT(10),
bookid BIGINT(10),
gamekind VARCHAR(20),
param1 BIGINT(10),
param2 BIGINT(10),
param3 BIGINT(10),
param4 BIGINT(10),
param5 BIGINT(10),
param6 BIGINT(10),
param7 BIGINT(10),
param8 BIGINT(10),
param9 MEDIUMTEXT,
param10 BIGINT(10),
shuffle TINYINT(2) DEFAULT 1,
timemodified BIGINT(10),
gameinputid BIGINT(10),
toptext TEXT,
bottomtext TEXT,
grademethod TINYINT(2),
grade BIGINT(10),
decimalpoints TINYINT(2),
popup SMALLINT(4),
review BIGINT(10),
attempts BIGINT(10),
glossaryid2 BIGINT(10),
glossarycategoryid2 BIGINT(10),
language VARCHAR(10),
subcategories TINYINT(1),
CONSTRAINT PRIMARY KEY (id)
) ENGINE = InnoDB
CREATE TABLE mdl_game (
id BIGINT(10) unsigned NOT NULL auto_increment,
name VARCHAR(255),
course BIGINT(10),
sourcemodule VARCHAR(50),
timeopen BIGINT(10) unsigned DEFAULT 0,
timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0,
quizid BIGINT(10),
glossaryid BIGINT(10),
glossarycategoryid BIGINT(10),
questioncategoryid BIGINT(10),
bookid BIGINT(10),
gamekind VARCHAR(20),
param1 BIGINT(10),
param2 BIGINT(10),
param3 BIGINT(10),
param4 BIGINT(10),
param5 BIGINT(10),
param6 BIGINT(10),
param7 BIGINT(10),
param8 BIGINT(10),
param9 MEDIUMTEXT,
param10 BIGINT(10),
shuffle TINYINT(2) DEFAULT 1,
timemodified BIGINT(10),
gameinputid BIGINT(10),
toptext TEXT,
bottomtext TEXT,
grademethod TINYINT(2),
grade BIGINT(10),
decimalpoints TINYINT(2),
popup SMALLINT(4),
review BIGINT(10),
attempts BIGINT(10),
glossaryid2 BIGINT(10),
glossarycategoryid2 BIGINT(10),
language VARCHAR(10),
subcategories TINYINT(1),
CONSTRAINT PRIMARY KEY (id)
) ENGINE = InnoDB
Stack trace:
- line 400 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 655 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 75 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
- line 456 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
- line 408 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
- line 502 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
- line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
- line 1460 of /lib/upgradelib.php: call to upgrade_plugins()
- line 317 of /admin/index.php: call to upgrade_noncore()