Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-26327

DDL sql execution error when upgrading from 1.9-> 2



    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Duplicate
    • 2.0.1
    • None
    • Feedback
    • Windows server 2003 and Linux Fedora 10
    • MySQL


      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
      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,
      ) 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()


        1. mdl_modules_linux_version.jpg
          293 kB
          Tom Vivian
        2. mdl_modules_windows_version.jpg
          304 kB
          Tom Vivian
        3. screen_dump.jpg
          82 kB
          Tom Vivian



            skodak Petr Skoda
            tomvivian Tom Vivian
            Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona)
            0 Vote for this issue
            1 Start watching this issue