[Mahara-contributors] [Bug 1752688] Re: MariaDB fails to upgrade - unable to CAST as JSON
** Changed in: mahara/18.04
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 Committed
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
___
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1752688] Re: MariaDB fails to upgrade - unable to CAST as JSON
** 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
___
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1752688] Re: MariaDB fails to upgrade - unable to CAST as JSON
** Changed in: mahara/17.10
Status: In Progress => Fix Committed
--
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 Committed
Status in Mahara 17.10 series:
Fix Committed
Status in Mahara 18.04 series:
Fix Committed
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
___
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1752688] Re: MariaDB fails to upgrade - unable to CAST as JSON
** Changed in: mahara/18.04
Status: In Progress => Fix Committed
--
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 Committed
Status in Mahara 17.10 series:
Fix Committed
Status in Mahara 18.04 series:
Fix Committed
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
___
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1752688] Re: MariaDB fails to upgrade - unable to CAST as JSON
** Changed in: mahara/17.10
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:
In Progress
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
___
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 1752688] Re: MariaDB fails to upgrade - unable to CAST as JSON
Hmm, of course there will be no easy way to work out which flavour of
mysql we have:
https://stackoverflow.com/questions/43611296/how-can-i-detect-whether-
connected-database-is-mariadb-or-mysql
With the best idea being to look at variable version_comment
https://stackoverflow.com/questions/37317869/determine-if-mysql-or-
percona-or-mariadb
--
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
___
Mailing list: https://launchpad.net/~mahara-contributors
Post to : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
