mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1752688@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara/17.10
       Status: Fix Committed => Fix Released

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

Title:
  MariaDB fails to upgrade - unable to CAST as JSON

Status in Mahara:
  Fix Released
Status in Mahara 17.10 series:
  Fix Released
Status in Mahara 18.04 series:
  Fix Released

Bug description:
  There is a problem in htdocs/lib/db/upgrade.php on the line

   if (is_mysql() && version_compare($db_version, '5.7.8', '>=')) {

  The problem is Mahara recognises both MySQL and MariaDB as being
  is_mysql() and their numbering systems are different (where MariaDB is
  around 10.* while MySQL is around 5.*)

  While both are mostly compatible with each other there are some slight
  differences and in this case CAST as JSON is not yet available in
  MariaDB.

  In this case we need to check which type of is_mysql() we have and if
  it is not 'MySQL' then we need to return the if statement as false
  rather than true.

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