From 0f1ecc2b33e50dc7f6b607d347e4f459e4c7dd81 Mon Sep 17 00:00:00 2001 From: Ken West Date: Wed, 16 Jul 2014 14:03:40 +1000 Subject: [PATCH] CRM-14994 Fix activity type values --- CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl index ea8b4cb00e..d897c6dce2 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl @@ -182,7 +182,7 @@ VALUES -- new activity types required for partial payments SELECT @option_group_id_act := max(id) from civicrm_option_group where name = 'activity_type'; SELECT @option_group_id_act_wt := MAX(weight) FROM civicrm_option_value WHERE option_group_id = @option_group_id_act; -SELECT @option_group_id_act_val := MAX(value) FROM civicrm_option_value WHERE option_group_id = @option_group_id_act; +SELECT @option_group_id_act_val := MAX(ROUND(value)) FROM civicrm_option_value WHERE option_group_id = @option_group_id_act; SELECT @contributeCompId := max(id) FROM civicrm_component where name = 'CiviContribute'; INSERT INTO -- 2.25.1