I have a web site, www.ffez.com, at Dreamhost using Concrete5 22.214.171.124 and their recent update to MySQL 8 has crashed my site with a error about the use of “groups” somewhere in a SQL statement. Based on some reading, I tried editing the Concrete5 files to add back ticks to the word “groups” in any SQL-looking code, but the same error occurrs as soon as the updated site attempts to load past the splash page.
After reading through the frightening process of trying to move from version 5 to 8, I’ve copied a version 8.5 into a “newsite” folder and am resigned to recreateing the site (it needed a cell phone friendly template, anyway) and have the WayBack Machine to use as a reference… However, I’m not sure if I need a new MySQL database for this.
Can anyone give me a little guidance about how the database is connected? I’m a programmer, but not a web programmer. Thanks!
I copied the enter “web” folder in the GitHub legacy archive to the server, but I’m getting the same error message about the “groups” reserved word. I renamed the “concrete” folder and am uploading a fresh copy from the legacy version, but any comments would be welcome.