I received notice from my web host that there will be issues with concrete database when my host upgrades to MySQL 8. Their upgrade notice follows:
We are excited to inform you that we will upgrade your server to MySQL 8 in November, ensuring compatibility with upcoming cPanel and Operating System upgrades.
We recommend reviewing your applications and scripts for compatibility to ensure a seamless transition. We will configure MySQL to help prevent common compatibility issues after upgrading, but you should view these settings as temporary.
It appears that “Groups” is now a reserved keyword. My host has called out several installs that will have problems. Host says all below will throw errors due to: Groups - Table name
I am not sure what to do. I tried finding information about this but did not have success. Hope someone can help me with this!
Server info - 4 websites: Site 1: Core Version - 9.2.0 Version Installed - 9.2.0 Database Version - 20230308163514 # Database Information Version: 5.7.43 # Concrete Packages Simple Gallery (2.1.0) # PHP Version 7.4.33 Site 2: # Concrete Version Core Version - 9.1.2 Version Installed - 9.1.2 Database Version - 20220908074900 # Database Information Version: 5.7.43 # Concrete Packages Simple Gallery (2.1.0) # PHP Version 8.1.23 Site 3: # concrete5 Version - 18.104.22.168 # concrete5 Packages - None # PHP Version - 7.4.33 Site 4: # concrete5 Version - 22.214.171.124 # concrete5 Packages CrimsonRed Menus (1.4), Whale Nivo Image Slider (1.2). # PHP Version - 7.4.33