From 9bf724614553621051caa5875321616b2a936555 Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Wed, 8 Sep 2021 09:16:54 +1000 Subject: [PATCH] Fix Upgrade step to ensure all fields are converted correctly as well --- CRM/Upgrade/Incremental/php/FiveFortyThree.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/php/FiveFortyThree.php b/CRM/Upgrade/Incremental/php/FiveFortyThree.php index 15073618fa..a3b8c9c30c 100644 --- a/CRM/Upgrade/Incremental/php/FiveFortyThree.php +++ b/CRM/Upgrade/Incremental/php/FiveFortyThree.php @@ -75,7 +75,7 @@ class CRM_Upgrade_Incremental_php_FiveFortyThree extends CRM_Upgrade_Incremental $characterSet = 'utf8mb4'; } if ($contactTableCollation !== $relationshipCacheCollation) { - CRM_Core_DAO::executeQuery('ALTER TABLE civicrm_relationship_cache ENGINE=InnoDB DEFAULT CHARACTER SET ' . $characterSet . ' COLLATE ' . $contactTableCollation); + CRM_Core_BAO_SchemaHandler::migrateUtf8mb4(($characterSet === 'utf8mb4' ? FALSE : TRUE), ['%civicrm_relationship_cache%']); } return TRUE; } -- 2.25.1