Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Critical
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.11
-
Fix Version/s: 4.7.13
-
Component/s: None
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
When CiviCRM is configured for Memcached, data for line items are incorrectly stored.
To replicate on memcached server;
Create Offline 'General' Membership and change the total amount under record payment before hitting save button.
Bug:
The total amount of financial_trxn is not matched with financial item is not matched.
Here is the query for reference:
SELECT
cc.id contribution_id,
cc.contribution_status_id,
cc.total_amount contribution_amount,
cft.id financial_trxn_id,
cft.to_financial_account_id,
cft.from_financial_account_id,
cfi.financial_account_id item_financial_account_id,
cft.total_amount trxn_amount,
cft.trxn_date trxn_date,
cft.status_id trxn_status_id,
cfi.id item_id,
cfi.amount item_amount,
cfi.status_id item_status,
cli.*
FROM civicrm_financial_trxn cft
INNER JOIN civicrm_entity_financial_trxn ceft ON ceft.financial_trxn_id = cft.id
INNER JOIN civicrm_financial_item cfi ON cfi.id = ceft.entity_id AND ceft.entity_table = 'civicrm_financial_item'
INNER JOIN civicrm_line_item cli ON cli.id = cfi.entity_id AND cfi.entity_table = 'civicrm_line_item'
INNER JOIN civicrm_entity_financial_trxn ceft1 ON ceft1.financial_trxn_id = cft.id AND ceft1.entity_table = 'civicrm_contribution'
INNER JOIN civicrm_contribution cc ON cc.id = ceft1.entity_id
WHERE cc.id=26425