From c9e1e2bd6531642aa9b948da8d98b00e9cb59495 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Fri, 30 Sep 2022 16:06:04 -0400 Subject: [PATCH] RecentItems - additional fix for inconsistent option values created by installer --- CRM/Upgrade/Incremental/sql/5.54.alpha1.mysql.tpl | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/5.54.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.54.alpha1.mysql.tpl index 95af8e28a0..57b267ca3c 100644 --- a/CRM/Upgrade/Incremental/sql/5.54.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.54.alpha1.mysql.tpl @@ -12,3 +12,8 @@ WHERE `option_group_id` = @og_recent_items_providers; UPDATE `civicrm_option_value` SET `value` = `name` WHERE `option_group_id` = @og_recent_items_providers AND `value` REGEXP '^[0-9]+$'; + +{* Fix option values created with wrong name by the 5.53.0 installer *} +UPDATE `civicrm_option_value` +SET `name` = `value` +WHERE `option_group_id` = @og_recent_items_providers; -- 2.25.1