CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2023-12-06T23:29:47Zhttps://lab.civicrm.org/dev/core/-/issues/4825Issues with CiviCRM Tables During MySQL 8.0 Upgrade2023-12-06T23:29:47ZfatihatesIssues with CiviCRM Tables During MySQL 8.0 UpgradeDuring the upgrade to MySQL 8.0, I encountered one different warnings related to CiviCRM tables and I want to take the correct steps in this regard. These warnings are listed below:
Usage of db objects with names conflicting with new re...During the upgrade to MySQL 8.0, I encountered one different warnings related to CiviCRM tables and I want to take the correct steps in this regard. These warnings are listed below:
Usage of db objects with names conflicting with new reserved keywords Warning: The following objects have names that conflict with new reserved keywords. Ensure queries sent by your applications use quotes when referring to them or they will result in errors.
Do I need to fix the mentioned 4 tables (sample tables listed below)? Are the commands I provided for fixing these tables correct and valid?
Sample Tables
----------------------------------------
`xxx_xx.civicrm_mapping_field.grouping - Column name`
`xxx_xx.civicrm_option_value.grouping - Column name`
`xxx_xx.log_civicrm_mapping_field.grouping - Column name`
`xxx_xx.log_civicrm_option_value.grouping - Column name`
Images
----------------------------------------
![2023-12-01_01_59_19](/uploads/934aa70e46592189d1c748892224c31e/2023-12-01_01_59_19.png)
Proposed Solution:
----------------------------------------
`SELECT "grouping" FROM xxx_cagri.civicrm_mapping_field;`
Similar Issues
----------------------------------------
https://civicrm.stackexchange.com/questions/45993/issues-with-civicrm-tables-during-mysql-8-0-upgrade
Environment information
----------------------------------------
* __CiviCRM: 5.67.0
* __PHP: 8.1.25
* __CMS: Joomla 4.4.1
* __Database: 5.7.44