From 6c7b7b66110c5a63e4dbcece28b0358d4a3fce31 Mon Sep 17 00:00:00 2001 From: Micah Nordland Date: Wed, 1 Jun 2016 12:33:58 -0400 Subject: [PATCH] CRM-18699 Fixed Wake Island spelling --- CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl | 2 ++ xml/templates/civicrm_state_province.tpl | 2 +- 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl index 6fc87f8fc0..47d7120047 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.8.mysql.tpl @@ -13,3 +13,5 @@ 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/xml/templates/civicrm_state_province.tpl b/xml/templates/civicrm_state_province.tpl index c2738d2dff..852ed1ed37 100644 --- a/xml/templates/civicrm_state_province.tpl +++ b/xml/templates/civicrm_state_province.tpl @@ -3430,7 +3430,7 @@ INSERT INTO civicrm_state_province (id, country_id, abbreviation, name) VALUES (4978, 1227, "71", "Midway Islands"), (4979, 1227, "76", "Navassa Island"), (4980, 1227, "95", "Palmyra Atoll"), -(4981, 1227, "79", "Wake Ialand"), +(4981, 1227, "79", "Wake Island"), (4982, 1229, "AR", "Artigsa"), (4983, 1229, "CA", "Canelones"), (4984, 1229, "CL", "Cerro Largo"), -- 2.25.1