Page MenuHomePhabricator

Civi Report 'Gateway Reconciliation MINIMAL' errors
Closed, ResolvedPublic

Description

Investigating 'CIVI access for REPORTS not working' email report from Pats.

Event Timeline

Confirmed that running report triggers a backend SQL error :

Unknown column 'financial_trxn_civireport.is_negative' in 'group stat...")

relating to truncated query log output:

SELECT SQL_CALC_FOUND_ROWS contribution_civireport.receive_date as civicrm_contribution_receive_date, sum(financial_trxn_civireport.total_amount) as civicrm_financial_trxn_total_amount_sum, COUNT(financial_trxn_civireport.total_amount) as civicrm_financial_trxn_total_amount_count, IF( financial_trxn_civireport.total_amount < 0, '-', '+' ) AS civicrm_financial_trxn_is_negative, ribution_extra_civireport.original_currency as wmf_contribution_extra_original_currency, ribution_extra_civireport.gateway as wmf_contribution_extra_gateway, ribution_extra_civireport.gateway_account as wmf_contribution_extra_gateway_account, country_civireport.iso_code as civicrm_country_iso_code  FROM civicrm_contribution contribution_civireport#012LEFT JOIN wmf_contribution_extra ribution_extra_civireport#012    ON ribution_extra_civireport.entity_id = contribution_civireport.id#012#012LEFT JOIN civicrm_entity_financial_trxn entity_financial_trxn_civireport#012                    ON (contribution_civireport.id = entity_financial_trxn_civireport.entity_id AND#012                        entity_financial_trxn_civireport.entity_table = 'civicrm_contribution')#012#012  LEFT JOIN civicrm_financial_trxn financial_trxn_civireport#012                    ON financial_trxn_civireport.id = entity_financial_trxn_civireport.financial_trxn_id#012LEFT JOIN civicrm_address#012    ON civicrm_address.contact_id = contribution_civireport.contact_id#012        AND civicrm_address.is_primary = 1#012LEFT JOIN civicrm_country country_civireport#012    ON country_civireport.id = civicrm_address.country_id WHERE ( contribution_civireport.receive_date >= 20161129000000 ) AND ( contribution_civireport.receive_date

Change 454185 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Fix gateway reconciliation failing when is_negative group by in play.

https://gerrit.wikimedia.org/r/454185

Change 454188 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Gateway reconcilliation follow up tidy up

https://gerrit.wikimedia.org/r/454188

Change 454185 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Fix gateway reconciliation failing when is_negative group by in play.

https://gerrit.wikimedia.org/r/454185

Change 454188 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Gateway reconcilliation follow up tidy up

https://gerrit.wikimedia.org/r/454188