I am migrating and then upgrading our Moodle installation from a Windows 2003 server with Moodle 1.9.8 to a Linux server with Moodle 2.0.1
I have sucessfully installed Moodle 1.9.8 on the Linux server and migrated the database across. I then copied the contents of the moodledata directory on the Windows server to the data directory on the Linux server. So far all is well. I can login, list users and view courses etc.
The problem came when I wanted to upgrade to version 2.0.1 on the Linux server using both the web interface and CLI.
The error is below:
Upgrading to new version
mod_feedback
DDL sql execution error
More information about this error
Debug info: Table 'mdl_feedback' already exists
CREATE TABLE mdl_feedback (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL DEFAULT '',
intro TEXT NOT NULL,
introformat SMALLINT(4) unsigned NOT NULL DEFAULT 0,
anonymous TINYINT(1) unsigned NOT NULL DEFAULT 1,
email_notification TINYINT(1) unsigned NOT NULL DEFAULT 1,
multiple_submit TINYINT(1) unsigned NOT NULL DEFAULT 1,
autonumbering TINYINT(1) unsigned NOT NULL DEFAULT 1,
site_after_submit VARCHAR(255) NOT NULL DEFAULT '',
page_after_submit TEXT NOT NULL,
page_after_submitformat TINYINT(2) unsigned NOT NULL DEFAULT 0,
publish_stats TINYINT(1) unsigned NOT NULL DEFAULT 0,
timeopen BIGINT(10) unsigned NOT NULL DEFAULT 0,
timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
completionsubmit TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
) ENGINE = InnoDB
Stack trace:
line 397 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 636 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 493 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 265 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1403 of /lib/upgradelib.php: call to upgrade_plugins()
line 290 of /admin/index.php: call to upgrade_noncore()