Public bug reported: 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 ** Affects: mahara Importance: Undecided Status: New ** Attachment added: "Reports page in mysql.png" https://bugs.launchpad.net/bugs/1797276/+attachment/5199752/+files/Reports%20page%20in%20mysql.png -- 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: 18.10 RC2: Reports page causes error in mysql8 Status in Mahara: New 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 : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
