From 7814f32fbdd844026cde88d20647996c8a128b47 Mon Sep 17 00:00:00 2001 From: Allen Shaw Date: Sat, 30 Dec 2017 20:01:11 -0600 Subject: [PATCH] Fix for one cause of CRM-18300. --- CRM/Upgrade/Incremental/sql/4.7.31.mysql.tpl | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.31.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.31.mysql.tpl index 811651f40e..a40e4357d1 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.31.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.31.mysql.tpl @@ -1 +1,12 @@ {* file to handle db changes in 4.7.31 during upgrade *} + +-- CRM-18300 Remove "_[id]" suffix from name column for profiles referenced +-- by name in core code. +UPDATE IGNORE civicrm_uf_group SET name = 'new_individual' WHERE name = concat('new_individual_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'new_organization' WHERE name = concat('new_organization_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'new_household' WHERE name = concat('new_household_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'summary_overlay' WHERE name = concat('summary_overlay_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'contribution_batch_entry' WHERE name = concat('contribution_batch_entry_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'membership_batch_entry' WHERE name = concat('membership_batch_entry_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'shared_address' WHERE name = concat('shared_address_', id); +UPDATE IGNORE civicrm_uf_group SET name = 'event_registration' WHERE name = concat('event_registration_', id); -- 2.25.1