Today I upgraded our Mahara site from version 1.7.2 to 1.8.1 (current version). What it was expected to be an easy procedure turned out to a trouble due to a database (MySQL) collation issue. Below are the details:
After doing all backups as it’s required I downloaded and unzip the new version to perform the upgrade via cli-script.
me@myserver:/var/www/mahara# php ./admin/cli/upgrade.php
[WAR] 77 (lib/mahara.php:183) A column of your database is using a collation that is not the same as the database default. Please ensure all columns use the same collation as the database.
Call stack (most recent first):
* ensure_upgrade_sanity() at /var/www/mahara/admin/cli/upgrade.php:46
A column of your database is using a collation that is not the same as the database default. Please ensure all columns use the same collation as the database.
My old Mahara version (1.7.2) had an utf8_spanish2_ci collation in tables. As I had recently changed to a new server and I had configured MySQL to a utf8_general_ci default collation the upgrade process stopped showing a warning about «.. not the same collation..».
Continue reading ‘Mahara: How to solve collation issue when upgrading’ »