Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2, 2.3
    • Fix Version/s: 2.2.5, 2.3.2, 2.4
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Testing Instructions:
      Hide

      run unit tests

      1/ install moodle 19
      2/ Alter collations in several tables/columns, make it so there is a mix of collations. (Use http://moodle.org/mod/forum/discuss.php?d=206607 as an examle of a real life mixture)
      3/ point moodle 22 install to 19 database
      4/ try /admin/cli/mysql_collation.php script to fix the incorrect collations before upgrade
      5/ run upgrade - no problems expected

      1/ create a test database with 19 data
      2/ change default database collation to something different to what it currently is
      3/ try upgrade to 22 - no problems expected

      Show
      run unit tests 1/ install moodle 19 2/ Alter collations in several tables/columns, make it so there is a mix of collations. (Use http://moodle.org/mod/forum/discuss.php?d=206607 as an examle of a real life mixture) 3/ point moodle 22 install to 19 database 4/ try /admin/cli/mysql_collation.php script to fix the incorrect collations before upgrade 5/ run upgrade - no problems expected 1/ create a test database with 19 data 2/ change default database collation to something different to what it currently is 3/ try upgrade to 22 - no problems expected
    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w29_MDL-34271_m24_mysqlcollation

      Description

      Quite often ppl change default collation either when upgrading MYSQL or when backing up and restoring mysql dump - this usually coincides with Moodle upgrades. Solution is to detect current collation from one table (config) and use reasonable default when starting installation.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    10/Sep/12