Hi,
We are running Modx Revolution 2.6.5, for security reasons we're looking to update our webserver to MySQL v8.0. We've gone ahead and done this but noticed some minor issues in the manager page, the "Who's Online" and the "Recently Edited Resources" pages do not work. We've since rolled back to MySQL 5.7 and everything has started working as normal. While this issue appears minor, we're not sure what else might be broken that we haven't yet noticed.
An investigation of the SQL log showed a problem:
SELECT `modCategory`.`id` AS `modCategory_id`, `modCategory`.`parent` AS `modCategory_parent`, `modCategory`.`category` AS `modCategory_category`, `modCategory`.`rank` AS `modCategory_rank`
FROM `categories` AS `modCategory`
ORDER BY rank ASC, category ASC
The ORDER BY clause has “rank”, rank is now a reserved word, so the query needs to become : “ORDER BY `rank` ASC, `category` ASC”
What's the latest supported version of MySQL that we can use? I found this page (
https://docs.modx.com/revolution/2.x/getting-started/server-requirements) but it's from August 2017 so I'm not sure if anything has changed in the meantime.
Should we expect MySQL v8.0 to work? If so it appears we've uncovered a bug in Modx.
