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

Moodle 1.9.11 to Moodle 2.0 Upgrade DDL Execution error - mdl_backup_log


    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 2.0.5, 2.1.2
    • 2.0.4, 2.1.1, 2.2
    • Backup
    • Windows r2 s008, MS-SQL 2008, IIS 7.5. PHP 5.3.5 FastCGI

      When trying to do the upgrade from Moodle 1.9.11 to Moodle 2.0 I get an DDL Execution Error.

      It is at the

      ALTER TABLE mdl_backup_log

      It tries to add a new column backuptype nvarchar(50) Not Null

      The work around is to add the new column manually prior to upgrade.

      add the new column backuptype nvarchar(50 and set the default ''

      The upgrade can then proceed.

      However, probably better if it was fixed the upgrade script.

            samhemelryk Sam Hemelryk
            fweiss Fred Weiss
            Andrew Davis Andrew Davis
            Aparup Banerjee Aparup Banerjee
            Aparup Banerjee Aparup Banerjee
            1 Vote for this issue
            3 Start watching this issue


                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.