I have a number of sites that are now displaying a MySQL syntax error.
The sites are running core 8.2.1 and were working fine using PHP 5.6 or 7.1, but are now broken.
This is the error: An exception occurred while executing 'select * from Groups where gID = ?' with params ["1"]: SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Groups where gID = '1'' at line 1
I do not have access to the dashboard so cannot update the core. I have tried manual updates using concrete [instructions here] (How to Upgrade Concrete CMS) but this did not work.
I do not have SSH access on my servers and do not have the skills anyhow.
Can anyone guide me as to a work-round as my clients are very unhappy (so far 6 websites).
Thanks so much for your clear and detailed reply. You are correct about the MySql.
I have managed to somehow bring back most sites by manually trying a variety of core updates till I found one that gave me a dashboard and then go from there.
Some of the sites themes however are now broken because they are not supported by core 9 which is a right pain.
I’m new to ConcreteCMS, but that error appears to be related to a column missing (siteTreeID) on table Pages… Can you confirm thar you have that column on this table. Not sure on how ConcreteCMS updates are done but some database migration missing ?
Sadly this is about the 4th attempt to update the core. Each time I start with the a backup and have tried updating using versions newer than the original and also tried going straight to 9.2, but in each case I get errors.
Sure that’s understandable - essentially it looks like you need to upgrade to 8.5.7 - if you’re looking for someone to work with who can help guide you through the process, I would definitely roll over to Gigs & Jobs - Concrete CMS