← Back to team overview

mahara-contributors team mailing list archive

[Bug 1184450] Re: Add mysql collation mode to pre-install sanity check

 

Patch submitted by Nitish: https://reviews.mahara.org/#/c/2455/

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1184450

Title:
  Add mysql collation mode to pre-install sanity check

Status in Mahara ePortfolio:
  Triaged

Bug description:
  It appears that if you try to install Mahara with a MySQL DB where the
  collation mode is 16-bit rather than 8-bit (i.e. UTF16 instead of
  UTF8), it fails out with the unhelpful error message "mysql error:
  [1231: Variable 'sql_mode' can't be set to the value of 'POSTGRESQL']
  in EXECUTE("SET SQL_MODE='POSTGRESQL'")"

  Is this something we could add to the sanity check on each page (or
  maybe just the pre-install sanity check)?

  See https://mahara.org/interaction/forum/topic.php?id=5452

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1184450/+subscriptions


References