Moodle

META: Increase robustness of upgrade from 1.9 to 2.2

Details

  • Affected Branches:
    MOODLE_22_STABLE
  • Fixed Branches:
    MOODLE_22_STABLE

Description

Use this META bug to group and prioritise problems found in the 1.9 -> 2.2 upgrade.

For large sites, please use the command-line interface (CLI).
http://docs.moodle.org/22/en/Administration_via_command_line#Upgrading_via_command_line

All fixes here should be ported to 2.2.x only.

Issue Links

has been marked as being related by

Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-36126 Error restoring a Moodle 1.9.x course to Moodle 2.x due to long filenames

  • Critical - Crashes server, loss of data, severe memory leak
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed should not be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Dan Poltawski added a comment -

Really I think we should be able to do something like this in xmldb:
http://docs.moodle.org/22/en/Verify_Database_Schema

Show
Dan Poltawski added a comment - Really I think we should be able to do something like this in xmldb: http://docs.moodle.org/22/en/Verify_Database_Schema
Hide
Permalink
Dan Poltawski added a comment - - edited

From http://moodle.org/mod/forum/discuss.php?d=205367 - some work someone had to do:

ALTER TABLE mdl_user MODIFY COLUMN lastip VARCHAR(45) NOT NULL DEFAULT '';
ALTER TABLE mdl_post MODIFY COLUMN uniquehash VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE mdl_resource MODIFY COLUMN reference VARCHAR(255) NOT NULL DEFAULT '';
UPDATE mdl_user SET lastip = '0.0.0.0' WHERE lastip IS NULL;
UPDATE mdl_user SET city = 'unknown' WHERE city IS NULL;
ALTER TABLE mdl_modules ALTER COLUMN search SET DEFAULT 'default';

FWIW, I have also had to change all of those fields apart form mdl_post and mdl_modules on a site i've upgraded. This must be fairly widespread.

Show
Dan Poltawski added a comment - - edited From http://moodle.org/mod/forum/discuss.php?d=205367 - some work someone had to do: ALTER TABLE mdl_user MODIFY COLUMN lastip VARCHAR(45) NOT NULL DEFAULT ''; ALTER TABLE mdl_post MODIFY COLUMN uniquehash VARCHAR(255) NOT NULL DEFAULT ''; ALTER TABLE mdl_resource MODIFY COLUMN reference VARCHAR(255) NOT NULL DEFAULT ''; UPDATE mdl_user SET lastip = '0.0.0.0' WHERE lastip IS NULL; UPDATE mdl_user SET city = 'unknown' WHERE city IS NULL; ALTER TABLE mdl_modules ALTER COLUMN search SET DEFAULT ' default '; FWIW, I have also had to change all of those fields apart form mdl_post and mdl_modules on a site i've upgraded. This must be fairly widespread.
Hide
Permalink
Martin Dougiamas added a comment -

How about this one about collations? http://moodle.org/mod/forum/discuss.php?d=206607

ELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;') as stmt
FROM `information_schema`.`TABLES` t
WHERE 1
AND t.`TABLE_SCHEMA` = 'moodledb'
ORDER BY 1 ;

and

ALTER TABLE `mdl_course` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `mdl_context` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `mdl_role_assignments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `mdl_enrol` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Show
Martin Dougiamas added a comment - How about this one about collations? http://moodle.org/mod/forum/discuss.php?d=206607 ELECT CONCAT('ALTER TABLE `', t.`TABLE_SCHEMA`, '`.`', t.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;') as stmt FROM `information_schema`.`TABLES` t WHERE 1 AND t.`TABLE_SCHEMA` = 'moodledb' ORDER BY 1 ; and ALTER TABLE `mdl_course` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE `mdl_context` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE `mdl_role_assignments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE `mdl_enrol` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Hide
Permalink
Dan Poltawski added a comment -

Martin: pretty sure that is nothing to do with us, just mysql environment settings.

Show
Dan Poltawski added a comment - Martin: pretty sure that is nothing to do with us, just mysql environment settings.
Hide
Permalink
Dan Poltawski added a comment -

Please ignore my above comment. Petr has come up with a solution for this in MDL-34271.

Show
Dan Poltawski added a comment - Please ignore my above comment. Petr has come up with a solution for this in MDL-34271 .

People

Vote (8)
Watch (11)

Dates

  • Created:
    Updated:
    Resolved: