Patch for "master" branch: https://reviews.mahara.org/9236
-- 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/1797276 Title: New reserved keywords in mysql8 cause SQL errors Status in Mahara: In Progress Bug description: I'm running PHP7.2 on Ubuntu 16.04 with MYSQL8 in Firefox. There's an SQL error for the groups report that occurs when running mysql. If you go to http://mahara/admin/users/statistics.php while running postgres, you see the reports page as expected. In mysql you get an error (Reports page in mysql.png - attached): [WAR] a6 (lib/dml.php:517) Failed to get a recordset: mysqli error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM "group" WHERE deleted = 0 GROUP ' at line 1] in EXECUTE(" SELECT grouptype, COUNT(id) AS groups FROM "group" WHERE deleted = 0 GROUP BY grouptype ORDER BY groups DESC")Command was: SELECT grouptype, COUNT(id) AS groups FROM "group" WHERE deleted = 0 GROUP BY grouptype ORDER BY groups DESC To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1797276/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
