mahara-contributors team mailing list archive

[Rebecca Blundell <1797276@xxxxxxxxxxxxxxxxxx>]

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