From f33776d95530db49d3a898df5174f1e7c48f65ea Mon Sep 17 00:00:00 2001 From: monishdeb Date: Fri, 5 Sep 2014 13:47:08 +0530 Subject: [PATCH] CRM-15086 upgrade fix ---------------------------------------- * CRM-15086: civicrm_data.tpl: batch types, status, etc option values were mistakenly put in {ts} https://issues.civicrm.org/jira/browse/CRM-15086 --- CRM/Upgrade/Incremental/sql/4.5.beta9.mysql.tpl | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.beta9.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.beta9.mysql.tpl index dc34c88a3b..8bfdb728ff 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.beta9.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.beta9.mysql.tpl @@ -24,4 +24,13 @@ WHERE ceft.entity_table = 'civicrm_contribution' GROUP BY ceft.entity_id ) as temp ON temp.trxn_id = cft.id INNER JOIN civicrm_contribution cc ON cc.id = temp.contribution_id AND cc.payment_instrument_id <> cft.payment_instrument_id -SET cft.payment_instrument_id = cc.payment_instrument_id; \ No newline at end of file +SET cft.payment_instrument_id = cc.payment_instrument_id; + +--CRM-15086 +SELECT @option_group_id_batch_status := id FROM civicrm_option_group WHERE name = 'batch_status'; + +UPDATE civicrm_option_value SET name = 'Open' WHERE value = 1 AND option_group_id = @option_group_id_batch_status; +UPDATE civicrm_option_value SET name = 'Closed' WHERE value = 2 AND option_group_id = @option_group_id_batch_status; +UPDATE civicrm_option_value SET name = 'Data Entry' WHERE value = 3 AND option_group_id = @option_group_id_batch_status; +UPDATE civicrm_option_value SET name = 'Reopened' WHERE value = 4 AND option_group_id = @option_group_id_batch_status; +UPDATE civicrm_option_value SET name = 'Exported' WHERE value = 5 AND option_group_id = @option_group_id_batch_status; -- 2.25.1