On my C5 site https://www.watch-deal.com/, I have a strange new error, the whole site is down with that error saying :
An exception occurred while executing ‘select * from Groups where gID = ?’ with params [1]: SQLSTATE[42000]: 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
Any idea what does it mean (it is like chinese to me…).
Any idea how to solve that ?
Thank you all for your help, my website is crashed now … and it is a huge issue for my business.
It appears that what might have happened is that your hosting company updated the version of MySQL because ‘Group’ has become a reserve word in MySQL version 8. If this were my site, I’d contact my host and ask them to change the version of MySQL back or do it yourself in the host’s dashboard. But even if you can do this temporarily, you will eventually need to solve the issue by updating concrete.
@mhawke thanks a lot for this precise answer ! Now I know what to do !
How can I know which version of Concrete5 I have on my website now that it is dawn ?
I check some files with Filezilla but could not find any version number.
If you are running a legacy version of concrete5, look in the file concrete/config/version.php
Assuming your not running the core files out of your ‘updates’ folder.
OK I found in the “concrete.php” file that I have the version 8.3.1. installed.
Which version can I easily install to fix my issue ?
I understand that installing the newest version would be better but maybe also more difficult as my current version is pretty old.
Other question, as my website is dawn, I think I need to use this method to upgrade my 8.3.1 C5 version :
### Replacing Original Concrete Directory (Version 8+)
** Download version 8.5.7*
** Replace the concrete directory in web root.*
** Empty updates directory.*
** Delete application/config/update.php.*
** Replace composer.json and composer.lock (if pre-8.2.0).*
** Visit your site; Concrete will run required database migrations.*
Do you confirm that it will work even if my website is currently dawn with a MySQL issue ?
Generally the right thing, assuming this was not a composer installation in the first place.
The post from @EvanCooper is a bit old. You can update to the latest 8.5 version. I think that is about 8.5.13, though may be later by now.
For replacing the directory, I suggest unzipping the new core (/concrete) to /concrete_new. Then rename /concrete to concrete_old and rename /concrete_new to /concrete
For running the update, the CLI is usually better. You can actually follow the individual migrations as they are reported back to the CLI.
