Hey all,
in an ideal world all our old concrete5.6.x sites would have been by now replaced with nice shiny V9 versions, but due to all sorts of reasons we either still host or support a bunch.
Whilst they are not just legacy, they are a liability, but they still work, are fast, and can at least run on PHP7.4.
One of the sites I had to fix the other day was 15 years old, still even running eCommerce. Incredible. (yes, I’ve advised them multiple times about updating, etc, etc, etc)
But the reason for my post is that we’ve had a few cPanel servers update lately where MySQL has been updated, where ‘Group’ is now a keyword.
For these older Concrete sites, this broke them, as even in the latest 5.6.x release the word Group is used in a few queries without being quoted.
Fortunately, it’s a quick case of editing a file, putting in some quotes, and a site comes back up.
But to fix other instances in the codebase, the solution is to download the master branch zip, extract from that the concrete folder and swap that out with the live one. It’s still the same version, but the master branch had further fixes in it that didn’t make the last release.
So for anyone finding that their 5.6.x sites crashes after a cPanel upgrade, aim to run them on php7.4 and use the concrete folder from the master branch, to address any errors that talk about ‘Group’.
I don’t know what is involved about putting out a new release, and maybe I’m in a very small minority of fools that are still supporting it, but if someone is able to put out a new release with everything commit to date I reckon that might save someone a few headaches.