Page 1 of 1
Which verrsion of CMSMS supports MySQL 8?
Posted: Wed Jul 03, 2024 4:20 pm
by cbakewell
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 of CMSMS that will function OK with MySQL 8 ?
Thanks in advance.
Re: Which verrsion of CMSMS supports MySQL 8?
Posted: Wed Jul 03, 2024 5:44 pm
by DIGI3
It's going to be a tough one to answer as we don't really have specific MySQL requirements for each version. Some third-party modules may also have their own database calls that won't work in some versions.
Likely any basic site on the 2.x branch will work ok, but 1.x may be questionable. Again it will depend on the complexity of the sites and which modules they have installed.
Re: Which verrsion of CMSMS supports MySQL 8?
Posted: Thu Jul 04, 2024 8:16 am
by cbakewell
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
Re: Which verrsion of CMSMS supports MySQL 8?
Posted: Thu Jul 04, 2024 9:25 am
by creopard
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://severalnines.com/blog/moving-my ... ould-know/
And you might run into issues when using the upload module when using custom fields, see ONLY_FULL_GROUP_BY:
https://www.cms-1.org/forum/viewtopic.p ... 218#p42218 (sorry, German only. Use translation service if needed)
Re: Which verrsion of CMSMS supports MySQL 8?
Posted: Thu Jul 04, 2024 1:47 pm
by cbakewell
creopard wrote: ↑Thu Jul 04, 2024 9:25 am
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://severalnines.com/blog/moving-my ... ould-know/
And you might run into issues when using the upload module when using custom fields, see ONLY_FULL_GROUP_BY:
https://www.cms-1.org/forum/viewtopic.p ... 218#p42218 (sorry, German only. Use translation service if needed)
Thanks - that will help point us in the right direction if things go wrong. Fortunately, we will be able to test sites before they go live.