From 74cbd7fc81276d4241aace6df9a66bd32866ffbc Mon Sep 17 00:00:00 2001 From: Dave Greenberg Date: Wed, 7 May 2014 20:14:18 -0400 Subject: [PATCH] Add fix for trailing single-quote in Awaiting Information grant status label. --- CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl index 7f58f2bdcf..05926b60b5 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl @@ -495,3 +495,10 @@ SELECT 'Withdrawn' AS grantstatus LEFT JOIN civicrm_option_value co ON LOWER(co.name) = LOWER(temp.grantstatus) AND option_group_id = @option_grant_status WHERE co.id IS NULL; + +-- Fix trailing single quote in grant status label +UPDATE civicrm_option_value v + INNER JOIN civicrm_option_group g + ON v.option_group_id=g.id AND g.name='grant_status' + SET label='Awaiting Information' + WHERE v.label='Awaiting Information\'' and v.name='Awaiting Information'; -- 2.25.1