Issues with CiviCRM Tables During MySQL 8.0 Upgrade
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
Proposed Solution:
SELECT "grouping" FROM xxx_cagri.civicrm_mapping_field;
Similar Issues
Environment information
- __CiviCRM: 5.67.0
- __PHP: 8.1.25
- __CMS: Joomla 4.4.1
- __Database: 5.7.44