From 2be20a47103bde4a4049a3fe9f433bcd4c4fe41a Mon Sep 17 00:00:00 2001 From: Micah Nordland Date: Thu, 2 Jun 2016 11:25:50 -0400 Subject: [PATCH] CRM-18699 fix in 4.7.9 now, better where statment --- CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl | 2 -- CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl | 3 +++ 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl index 47d7120047..6fc87f8fc0 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl @@ -13,5 +13,3 @@ DELETE FROM civicrm_state_province WHERE name = 'Fernando de Noronha'; -- CRM-17118 extend civicrm_address postal_code to accept full data strings from paypal etc. ALTER TABLE civicrm_address CHANGE `postal_code` `postal_code` varchar(64) ; --- CRM-18699 Fix Wake Island misspelling, was Wake Ialand -UPDATE civicrm_state_province SET name="Wake Island" WHERE id=4981; diff --git a/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl index 5d38563929..925db61223 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl @@ -6,3 +6,6 @@ UPDATE civicrm_option_value SET {localize field="label"}label = '{ts escape="sql"}Print/Merge Document{/ts}'{/localize}, {localize field="description"}description = '{ts escape="sql"}Export letters and other printable documents.{/ts}'{/localize} WHERE name = 'Print PDF Letter' AND option_group_id = @option_group_id_act; + +-- CRM-18699 Fix Wake Island misspelling, was Wake Ialand +UPDATE civicrm_state_province SET name="Wake Island" WHERE name="Wake Ialand"; -- 2.25.1