mahara-contributors team mailing list archive

[Aaron Wells <1184450@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mahara
     Importance: Medium
         Status: Triaged


** Tags: bite-sized installer mysql

** Tags added: bite-sized

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contrib members
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