Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.2, 2.3
    • 2.2.5, 2.3.2, 2.4
    • Database SQL/XMLDB
    • None
    • MOODLE_22_STABLE, MOODLE_23_STABLE
    • MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • w29_MDL-34271_m24_mysqlcollation
    • 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

    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.

      Attachments

        Issue Links

          Activity

            People

              skodak Petr Skoda
              skodak Petr Skoda
              Dan Poltawski Dan Poltawski
              Ankit Agarwal Ankit Agarwal
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Sep/12