Upgrade from 1.1 to 1.2 on MySQL fails at table import_event_subscription

Bug #489023 reported by Nigel McNie
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Mahara
Fix Released
Undecided
Richard Mansfield
Changed in mahara:
milestone: none → 1.2.1
Revision history for this message
Richard Mansfield (richard-mansfield) wrote :

I have been able to reproduce this bug, but so far only in the
case where the database's default collation is different from the
collation on the name column of event_type.

If both are set to latin1_swedish_ci, then the upgrade runs for
me without problems.

I'm not sure how databases are getting into this state or how
common this problem is, but just refusing to upgrade any db with
a default collation other than utf8_unicode_ci is not a solution.

If there's a good reason to believe this problem is widespread,
then we should compare the two collations (default db collation
and name column of event_type) and refuse to upgrade if they are
different.

I think we should also replace the notice we used to have on the
admin page that tells people if their db is not utf8, warns them
what bad things might happen, and encourages them to convert to
utf8.

Revision history for this message
Richard Mansfield (richard-mansfield) wrote :

I have now added a specific check to ensure (default db collation == collation on event_type(name)). Once the next release is out this will stop people from upgrading their dodgy dbs until we work out what the problem really is.

Changed in mahara:
status: New → Fix Committed
Changed in mahara:
assignee: nobody → Richard Mansfield (richard-mansfield)
Changed in mahara:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.