mahara-contributors team mailing list archive

[Mahara Bot <1184450@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/2455
Committed: http://gitorious.org/mahara/mahara/commit/034fe4438e017a26db47b95df3630ce9f0d81a72
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    master

commit 034fe4438e017a26db47b95df3630ce9f0d81a72
Author: Aaron Wells <aaronw@xxxxxxxxxxxxxxx>
Date:   Mon Sep 2 13:13:08 2013 +1200

Prevent non-helpful sql_mode error when trying to connect to a UTF16 DB

Bug 1184450. I don't know why this works but it does. When attempting to
connect to a UTF16 MySQL DB, if you first set the connection's character set
to UTF8 and then try to set the SQL_MODE to POSTGRES, it errors out on trying
to set the SQL_MODE. But if you try to set the SQL_MODE first, and *then* set
the character set to UTF8, it works fine.

Change-Id: I3528a92662708c081b15a111c625f0559fbd1c04

-- 
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