Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Critical
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.7
-
Fix Version/s: 4.7.9
-
Component/s: None
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
Reported to me by an iATS Payments User [ http://civicrm.stackexchange.com/questions/11981/why-am-i-seeing-two-identical-payments-associated-with-one-contribution-in-4-7-x ]
Reproduced on http://dmaster.demo.civicrm.org/civicrm/contribute?reset=1 [today May23 at 9:40MT] - note the transaction IDs are identical:
[labeling as a 'possibly critical' - as I don't know to what degree these double payments filter through in other CiviCRM bits - like CiviAccounts etc]
Attachments
Issue Links
Activity
Digging into this to figure if it's a UI or DB issue, I noticed that the database has these financial transactions associated to the payment:
mysql> select * from civicrm_financial_trxn where trxn_id = 'live_1_5751f0d7938ef';
| id | from_financial_account_id | to_financial_account_id | trxn_date | total_amount | fee_amount | net_amount | currency | is_payment | trxn_id | trxn_result_code | status_id | payment_processor_id | payment_instrument_id | check_number |
| 96 | NULL | 6 | 2016-06-03 21:04:23 | 100.00 | 0.00 | 100.00 | USD | 1 | live_1_5751f0d7938ef | NULL | 1 | NULL | NULL | NULL |
| 97 | 6 | 5 | 2016-06-03 21:04:23 | 1.50 | 0.00 | 0.00 | USD | 1 | live_1_5751f0d7938ef | NULL | 1 | NULL | NULL | NULL |
| 98 | NULL | 12 | 2016-06-03 21:04:23 | 100.00 | 0.00 | 100.00 | USD | 1 | live_1_5751f0d7938ef | NULL | 1 | 1 | 1 | NULL |
3 rows in set (0.00 sec)
So I think we have two identical FT entries in the DB, and one of them is not associated to a financial account / payment processor id.
Dear Joe, I am going to assign these to you so you can explain why we have 2 rows when changing payment method.....
Other small detail: this only seems to happen when doing an online/public membership transaction, not through the backend form. Also doesn't happen when doing a normal contribution (just a donation, not a membership signup/renewal).
Assigning to Eileen McNaughton who has already started work on this!
Does this fix the described?
Pradeep Nayak could you look at #8490 ... the issue doesn't provide enough details to tell for sure, but I think there may just have been some confusion about what is supposed to happen according to specifications when a payment method is changed.
I think we identified & resolved a bug here so you probably don't need to look further
Exact steps to reproduce:
Purchase a Membership via this online Contribution Page:
http://dmaster.demo.civicrm.org/civicrm/contribute/transact?reset=1&id=2
The demo@example.com already had an existing Student Membership - so it would have processed as a renewal.
Note this is NOT recurring