# MySQL 8 - Reserved Keywords - Groups

**URL:** <https://forums.concretecms.org/t/mysql-8-reserved-keywords-groups/6312>\
**Category:** Using Concrete / Help\
**Created:** [October 13, 2023, 6:41pm UTC](https://forums.concretecms.org/t/mysql-8-reserved-keywords-groups/6312 "2023-10-13T18:41:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GetSirius](https://forums.concretecms.org/user_avatar/forums.concretecms.org/getsirius/32/5810_2.png) [@GetSirius](https://forums.concretecms.org/u/GetSirius)\
**Post date:** [October 13, 2023, 6:41pm UTC](https://forums.concretecms.org/t/mysql-8-reserved-keywords-groups/6312/1 "2023-10-13T18:41:29Z")

</div>

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!

```auto
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 - 5.6.4.0
# concrete5 Packages - None
# PHP Version - 7.4.33

Site 4:
# concrete5 Version - 5.6.4.0
# concrete5 Packages
CrimsonRed Menus (1.4), Whale Nivo Image Slider (1.2).
# PHP Version - 7.4.33

```

---

<div class="post-metadata">

**Author:** ![hutman](https://forums.concretecms.org/user_avatar/forums.concretecms.org/hutman/32/6198_2.png) [@hutman](https://forums.concretecms.org/u/hutman)\
**Post date:** [November 17, 2023, 7:54pm UTC](https://forums.concretecms.org/t/mysql-8-reserved-keywords-groups/6312/2 "2023-11-17T19:54:59Z")

</div>

In that list Site 1 & 2 should not have any problems.

Site 3 & 4 will also be fine as long as you have the latest code from [GitHub - concretecms/concrete5-legacy: Legacy repository for concrete5](https://github.com/concretecms/concrete5-legacy/tree/master) (not the release, but the actual code inside web/concrete should be in your concrete directory on your server)

---

<div class="post-metadata">

**Author:** ![GetSirius](https://forums.concretecms.org/user_avatar/forums.concretecms.org/getsirius/32/5810_2.png) [@GetSirius](https://forums.concretecms.org/u/GetSirius)\
**Post date:** [November 28, 2023, 12:16am UTC](https://forums.concretecms.org/t/mysql-8-reserved-keywords-groups/6312/3 "2023-11-28T00:16:59Z")

</div>

Thank you!  
This did the trick to keep the old 5.6.4.0 websites online.

---

<div class="post-metadata">

**Author:** ![jb1](https://forums.concretecms.org/user_avatar/forums.concretecms.org/jb1/32/4935_2.png) [@jb1](https://forums.concretecms.org/u/jb1)\
**Post date:** [February 27, 2024, 4:39am UTC](https://forums.concretecms.org/t/mysql-8-reserved-keywords-groups/6312/4 "2024-02-27T04:39:38Z")

</div>

In case this helps other users…

My hosting company found a solution for the compatibility issue between Concrete 5.6 and MySQL8. I explained the full solution in this forum post - [Concrete 5.6 and MySQL8 [solved]](https://forums.concretecms.org/t/concrete-5-6-and-mysql8-solved/7024)