I took a copy of my live site, running concrete 8.5.1 with MYSQL 7, and installed it on a linux machine which is running MYSQL 8. I coped with the reserved words problems `Groups` and `identifiers` and everything seems to work fine. However when I Sign In I get an error message :-

An exception occurred while executing 'SELECT g.gName, u.uID FROM Groups g LEFT JOIN UserGroups ug ON ug.gID=g.gID INNER JOIN Users u ON ug.uID=u.uID AND (u.uName=? OR u.uEmail=?)' with params ["admin", "admin"]:

SQLSTATE[42000]: Syntax error or access violation: 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 g LEFT JOIN UserGroups ug ON ug.gID=g.gID INNER JOIN Users u ON ug.uID=u.' at line 1

If I then sign in again I get:

Invalid form token. Please reload this form and submit again.

But the login works, albeit leaving the Sign in form on the screen. I can then go into the dashboard, access the website through the sitemap and everything, again, seems to hen work as normal.

I presume that this is a further issue around reserved words. Can anyone shed any more light on this and let me know if there are any plans to migrate to MySQL 8