From 7957fc8095d53da1e3c680289eb851be3bc1e1de Mon Sep 17 00:00:00 2001 From: atif-shaikh Date: Tue, 6 Jan 2015 18:04:27 +0530 Subject: [PATCH] CRM-15203 - Recurring contributions don't create MembershipPayment records https://issues.civicrm.org/jira/browse/CRM-15203 --- CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl index b363d6de54..ac2901af34 100755 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha1.mysql.tpl @@ -133,3 +133,6 @@ UPDATE `civicrm_state_province` SET `name`='Papua Barat', `abbreviation`='PB' WH UPDATE `civicrm_state_province` SET `name`='DKI Jakarta' WHERE `id` = 3083; UPDATE `civicrm_state_province` SET `name`='DI Yogyakarta' WHERE `id` = 3085; UPDATE `civicrm_state_province` SET `abbreviation`='KI' WHERE `id` = 3066; + +-- CRM-15203 Recurring contributions don't create MembershipPayment records +INSERT INTO civicrm_membership_payment (contribution_id, membership_id) select cc.id, cm.id FROM civicrm_contribution cc LEFT JOIN civicrm_membership_payment cmp ON cc.id = cmp.contribution_id LEFT JOIN civicrm_membership cm ON cc.contribution_recur_id = cm.contribution_recur_id WHERE cc.contribution_recur_id IS NOT NULL AND cmp.id IS NULL AND cm.id IS NOT NULL; -- 2.25.1