Which verrsion of CMSMS supports MySQL 8?

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
cbakewell
New Member
New Member
Posts: 3
Joined: Thu Mar 31, 2016 1:15 pm

Which verrsion of CMSMS supports MySQL 8?

Post 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.
User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1673
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: Which verrsion of CMSMS supports MySQL 8?

Post 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.
Not getting the answer you need? CMSMS support options
cbakewell
New Member
New Member
Posts: 3
Joined: Thu Mar 31, 2016 1:15 pm

Re: Which verrsion of CMSMS supports MySQL 8?

Post 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
User avatar
creopard
Forum Members
Forum Members
Posts: 77
Joined: Fri Nov 10, 2017 10:25 am
Location: .de
Contact:

Re: Which verrsion of CMSMS supports MySQL 8?

Post 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)
cbakewell
New Member
New Member
Posts: 3
Joined: Thu Mar 31, 2016 1:15 pm

Re: Which verrsion of CMSMS supports MySQL 8?

Post 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.
Post Reply

Return to “CMSMS Core”