[MDL-26811] Moodle 1.9.11 to Moodle 2.0 Upgrade DDL Execution error - mdl_backup_log - Moodle Tracker

XML

Word

Printable

Database:

Microsoft SQL
Affected Branches:
MOODLE_20_STABLE, MOODLE_21_STABLE, MOODLE_22_STABLE
Fixed Branches:
MOODLE_20_STABLE, MOODLE_21_STABLE
Pull from Repository:
git://github.com/samhemelryk/moodle.git
Pull Main Branch:
wip-~~MDL-26811~~-master
Pull Main Diff URL:
https://github.com/samhemelryk/moodle/compare/master...wip-MDL-26811-master
Testing Instructions:
1. To test this site use a 1.9 MSSQL site that has records in the backup log table.
2. Upgrade the site from 1.9 to 2.0
3. Ensure the upgrade completes.

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.

has been marked as being related by

MDL-29185 Remove the backup_log table

MDL-22414 META: Restore 1.9 backups into Moodle 2.1 (phase 1)

Participants:: Andrew Davis, Aparup Banerjee, Eloy Lafuente (stronk7), Fred Weiss, Sam Hemelryk