Good day everyone
I am using Moodle 3.0.4, PHP 5.5.34 and mysql 5.0.11
I tried to restore an archive file from moodle 2 but I got "DDL sql execution error"
I read the more information but not too sure exactly how to resolve it. I turned on debug and tried to restore again I got the following in my server error log. I star-ed out reference to my url and IP.
Can I get any help with this?
***[Thu Apr 21 11:27:46 2016] [error] ) DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] CONSTRAINT PRIMARY KEY (id): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] ;: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] CREATE INDEX mdl_backidstemp_bacitepar_ix ON mdl_backup_ids_temp (backupid, itemname, parentitemid): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] CREATE INDEX mdl_backidstemp_bacitenew_ix ON mdl_backup_ids_temp (backupid, itemname, newitemid):
/home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] ;: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] ;: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] CREATE UNIQUE INDEX mdl_backidstemp_baciteite_uix ON mdl_backup_ids_temp (backupid, itemname, itemid): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 449 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] Error code: ddlexecuteerror: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 905 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 76 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 133 of /backup/util/dbops/backup_controller_dbops.class.php: call to database_manager->create_temp_table(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 455 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 87 of /backup/util/helper/restore_prechecks_helper.class.php: call to restore_controller_dbops::create_restore_temp_tables(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 376 of /backup/controller/restore_controller.class.php: call to restore_prechecks_helper::execute_prechecks(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 114 of /backup/util/dbops/restore_controller_dbops.class.php: call to backup_controller_dbops::create_backup_ids_temp_table(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 990 of /backup/util/ui/restore_ui_stage.class.php: call to restore_controller->execute_precheck(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 99 of /backup/restore.php: call to restore_ui->requires_substage(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] * line 370 of /backup/util/ui/restore_ui.class.php: call to restore_ui_stage_process->process(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] : /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] Potential coding error - existing temptables found when disposing database. Must be dropped!: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] PHP Fatal error: Uncaught exception 'ddl_change_structure_exception' with message 'DDL sql execution error' in /home/sites/***/public_html/moodle/lib/dml/moodle_database.php:449: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] Stack trace:: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #0 /home/sites/***/public_html/moodle/lib/dml/mysqli_native_moodle_database.php(905): moodle_database->query_end(false): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #1 /home/sites/***/public_html/moodle/lib/ddl/database_manager.php(76): mysqli_native_moodle_database->change_database_structure(Array): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #2 /home/sites/***/public_html/moodle/lib/ddl/database_manager.php(326): database_manager->execute_sql_arr(Array): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #3 /home/sites/***/public_html/moodle/lib/dml/moodle_temptables.php(140): database_manager->drop_table(Object(xmldb_table)): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #5 /home/sites/***/public_html/moodle/lib/dml/mysqli_native_moodle_database.php(481): moodle_database->dispose(): /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #6 /home/sites/***/pub in /home/sites/***/public_html/moodle/lib/dml/moodle_database.php on line 449: /home/sites/***/public_html/moodle/backup/restore.php
***[Thu Apr 21 11:27:46 2016] [error] #4 /home/sites/***/public_html/moodle/lib/dml/moodle_database.php(370): moodle_temptables->dispose(): /home/sites/***/public_html/moodle/backup/restore.php