From 9e4925a0b77a931338c3144854540e08b463748a Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Wed, 1 Jan 2020 22:17:16 +0000 Subject: [PATCH] dev/core#1143 dev/core#1480 Permit CiviCRM installation and running on MySQL 8 by adding backticks around grouping --- CRM/Core/OptionGroup.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Core/OptionGroup.php b/CRM/Core/OptionGroup.php index 145a07fced..97af275ded 100644 --- a/CRM/Core/OptionGroup.php +++ b/CRM/Core/OptionGroup.php @@ -121,7 +121,7 @@ class CRM_Core_OptionGroup { } $query = " -SELECT v.{$labelColumnName} as {$labelColumnName} ,v.{$keyColumnName} as value, v.grouping as grouping +SELECT v.{$labelColumnName} as {$labelColumnName} ,v.{$keyColumnName} as value, v.grouping as `grouping` FROM civicrm_option_value v, civicrm_option_group g WHERE v.option_group_id = g.id @@ -225,7 +225,7 @@ WHERE v.option_group_id = g.id } } $query = " -SELECT v.{$labelColumnName} as {$labelColumnName} ,v.value as value, v.grouping as grouping +SELECT v.{$labelColumnName} as {$labelColumnName} ,v.value as value, v.grouping as `grouping` FROM civicrm_option_value v, civicrm_option_group g WHERE v.option_group_id = g.id -- 2.25.1