CMS Made Simple Forums

The biggest CMSMS relevant change might be The deprecated ASC or DESC qualifiers for GROUP BY clauses are removed. Queries that previously relied on GROUP BY sorting may produce results that differ from previous MySQL versions. To produce a given sort order, provide an ORDER BY clause. https://seve...

Ah right - that is helpful, albeit not the best of news

I guesss we should throw extra resources at the problem and update every site to the latest version.

many thanks

We have inherited a server that needs urgently upgrading to MySQL 8 from MySQL 5.7 The server has around 50 CMSMS sites on there, and we are trying to identify which sites need updating urgently and which can be left until after the server update. I guess the question is 'which is the oldest version...