mahara-contributors team mailing list archive

[Mahara Bot <1184450@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/2869
Committed: http://gitorious.org/mahara/mahara/commit/f4e4b44f8a414a34ff83ee9d863247a80278040b
Submitter: Son Nguyen (son.nguyen@xxxxxxxxxxxxxxx)
Branch:    1.6_STABLE

commit f4e4b44f8a414a34ff83ee9d863247a80278040b
Author: Aaron Wells <aaronw@xxxxxxxxxxxxxxx>
Date:   Mon Dec 16 13:57:38 2013 +1300

Override MySQL's check for accidental large queries

Bug 1070046: MySQL has an optional server config option, "MAX_JOIN_SIZE",
which throws an error if you try to run a SQL query that MySQL's strategizer
thinks will require it to evaluate more than MAX_JOIN_SIZE rows. This is
intended to prevent the user from accidentally running giant queries that
will never finish, but some Mahara queries (which are large but will finish)
can trip it. Adding SQL_BIG_SELECTS=1 tels it that our queries are *not*
accidentally large.

Also has order change for bug 1184450

Change-Id: I6db4699ea765d3213d13eb93b8de098914db24e0

-- 
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:
  Fix Released

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