From 4f26d3d1ec40a43fe7550389a87d3674e0f9bfc3 Mon Sep 17 00:00:00 2001 From: Coleman Watts Date: Thu, 2 Jul 2020 13:09:20 -0400 Subject: [PATCH] Ensure all domains have the same value for locales --- CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl index bb5e5c9895..85bd64eadb 100644 --- a/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/5.28.alpha1.mysql.tpl @@ -18,3 +18,7 @@ UPDATE civicrm_contact_type SET is_reserved = 0 WHERE is_reserved IS NULL; -- https://lab.civicrm.org/dev/core/-/issues/1833 ALTER TABLE civicrm_event CHANGE participant_listing_id participant_listing_id int unsigned DEFAULT NULL COMMENT 'Should we expose the participant list? Implicit FK to civicrm_option_value where option_group = participant_listing.'; UPDATE civicrm_event SET participant_listing_id = NULL WHERE participant_listing_id = 0; + +-- https://lab.civicrm.org/dev/core/-/issues/1852 +-- Ensure all domains have the same value for locales +UPDATE civicrm_domain SET locales = (SELECT locales FROM (SELECT locales FROM civicrm_domain ORDER BY id LIMIT 1) d); -- 2.25.1