mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: In Progress

** Affects: mahara/17.10
     Importance: High
         Status: New

** Affects: mahara/18.04
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: In Progress

** Changed in: mahara
     Assignee: (unassigned) => Robert Lyon (robertl-9)

** Also affects: mahara/17.10
   Importance: Undecided
       Status: New

** Also affects: mahara/18.04
   Importance: High
     Assignee: Robert Lyon (robertl-9)
       Status: New

** Changed in: mahara/17.10
    Milestone: None => 17.10.4

** Changed in: mahara/17.10
   Importance: Undecided => High

** Changed in: mahara/18.04
       Status: New => In Progress

-- 
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:
  In Progress
Status in Mahara 17.10 series:
  New
Status in Mahara 18.04 series:
  In Progress

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