# Unexpected error on my whole site **URL:** \ **Category:** Using Concrete / Help\ **Created:** [August 3, 2024, 8:13pm UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919 "2024-08-03T20:13:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 3, 2024, 8:13pm UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/1 "2024-08-03T20:13:48Z")
Hello On my C5 site [https://www.watch-deal.com/](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. Thanks a lot Olivier ---
**Author:** ![mhawke](https://forums.concretecms.org/user_avatar/forums.concretecms.org/mhawke/32/6297_2.png) [@mhawke](https://forums.concretecms.org/u/mhawke)\ **Post date:** [August 4, 2024, 2:05am UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/2 "2024-08-04T02:05:29Z")
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. [Concrete 5.6 and MySQL8 [solved] - Developing with Concrete - Concrete CMS](https://forums.concretecms.org/t/concrete-5-6-and-mysql8-solved/7024) ---
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 4, 2024, 5:03pm UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/3 "2024-08-04T17:03:31Z")
@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. ---
**Author:** ![ConcreteOwl](https://forums.concretecms.org/user_avatar/forums.concretecms.org/concreteowl/32/6304_2.png) [@ConcreteOwl](https://forums.concretecms.org/u/ConcreteOwl)\ **Post date:** [August 4, 2024, 8:35pm UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/4 "2024-08-04T20:35:38Z")
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. ---
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 5, 2024, 9:00am UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/5 "2024-08-05T09:00:09Z")
Thank you ConcreteOwl, I went into that folder and did not find any version.php file. Here is the screenshot of the files present in that folder : ![concreete](https://forums.concretecms.org/uploads/default/original/2X/b/b6d6bc4c2bbd922f1d3a51cad1eacced82167385.png) The files are from January 2018, so I guess I have a pretty old version installed… ---
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 5, 2024, 9:07am UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/6 "2024-08-05T09:07:43Z")
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. Thank you all for your help ---
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 5, 2024, 2:41pm UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/7 "2024-08-05T14:41:30Z")
On [another forum topic](https://forums.concretecms.org/t/sql-syntax-error-core-8-2-1/6348), @EvanCooper says that version 8.5.7 should be enough to solve my issue. 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 ?** ---
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 6, 2024, 9:28am UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/8 "2024-08-06T09:28:15Z")
Could you please confirm me ? I am afraid of doing a wrong move… ---
**Author:** ![JohntheFish](https://forums.concretecms.org/user_avatar/forums.concretecms.org/johnthefish/32/3767_2.png) [@JohntheFish](https://forums.concretecms.org/u/JohntheFish)\ **Post date:** [August 6, 2024, 9:52am UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/9 "2024-08-06T09:52:26Z")
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. ---
**Author:** ![opequin](https://forums.concretecms.org/user_avatar/forums.concretecms.org/opequin/32/3495_2.png) [@opequin](https://forums.concretecms.org/u/opequin)\ **Post date:** [August 6, 2024, 9:29pm UTC](https://forums.concretecms.org/t/unexpected-error-on-my-whole-site/7919/11 "2024-08-06T21:29:11Z")
Thank you all… my website is back ! With a 8.5.17 version. I am very happy. Thank you for your precious help