DB Error: no such field when using "Tab on contact summary" with contributions
When creating a dataprocessor with output "Tab on contact summary" and "contribution" as data source I get an Error DB Error: no such field
** Unknown column 'zuwendung.contact_id' in 'where clause'
It seems that the table name is translated. "Zuwendung" is the german word for "Contribution"
Dataprocessor 1.33 and CiviCRM 5.34.0
Using a "Search/Report" output works as expected.
DB Error Output:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT COUNT(*) AS count FROM (SELECT DISTINCT `zuwendung`.`id` AS `zuwendungs_id`, `zuwendung`.`net_amount` AS `nettobetrag` FROM (SELECT `_contribution`.`id` AS `id`, `_contribution`.`contact_id` AS `contact_id`, `_contribution`.`financial_type_id` AS `financial_type_id`, `_contribution`.`contribution_page_id` AS `contribution_page_id`, `_contribution`.`payment_instrument_id` AS `payment_instrument_id`, `_contribution`.`receive_date` AS `receive_date`, `_contribution`.`non_deductible_amount` AS `non_deductible_amount`, `_contribution`.`total_amount` AS `total_amount`, `_contribution`.`fee_amount` AS `fee_amount`, `_contribution`.`net_amount` AS `net_amount`, `_contribution`.`trxn_id` AS `trxn_id`, `_contribution`.`invoice_id` AS `invoice_id`, `_contribution`.`invoice_number` AS `invoice_number`, `_contribution`.`currency` AS `currency`, `_contribution`.`cancel_date` AS `cancel_date`, `_contribution`.`cancel_reason` AS `cancel_reason`, `_contribution`.`receipt_date` AS `receipt_date`, `_contribution`.`thankyou_date` AS `thankyou_date`, `_contribution`.`source` AS `source`, `_contribution`.`amount_level` AS `amount_level`, `_contribution`.`contribution_recur_id` AS `contribution_recur_id`, `_contribution`.`is_test` AS `is_test`, `_contribution`.`is_pay_later` AS `is_pay_later`, `_contribution`.`contribution_status_id` AS `contribution_status_id`, `_contribution`.`address_id` AS `address_id`, `_contribution`.`check_number` AS `check_number`, `_contribution`.`campaign_id` AS `campaign_id`, `_contribution`.`creditnote_id` AS `creditnote_id`, `_contribution`.`tax_amount` AS `tax_amount`, `_contribution`.`revenue_recognition_date` AS `revenue_recognition_date`, `_contribution`.`is_template` AS `is_template`, `_contribution_soft`.`contribution_id` AS `contribution_soft_contribution_id`, `_contribution_soft`.`contact_id` AS `contribution_soft_contact_id`, `_contribution_soft`.`amount` AS `contribution_soft_amount`, `_contribution_soft`.`currency` AS `contribution_soft_currency`, `_contribution_soft`.`pcp_id` AS `contribution_soft_pcp_id`, `_contribution_soft`.`pcp_display_in_roll` AS `contribution_soft_pcp_display_in_roll`, `_contribution_soft`.`pcp_roll_nickname` AS `contribution_soft_pcp_roll_nickname`, `_contribution_soft`.`pcp_personal_note` AS `contribution_soft_pcp_personal_note`, `_contribution_soft`.`soft_credit_type_id` AS `contribution_soft_soft_credit_type_id` FROM `civicrm_contribution` `_contribution` LEFT JOIN `civicrm_contribution_soft` `_contribution_soft` ON `_contribution`.`id` = `_contribution_soft`.`contribution_id` WHERE 1 AND `zuwendung`.`contact_id` = 20653 AND `_contribution`.`is_test` = 0 ) `zuwendung` WHERE 1 ) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column 'zuwendung.contact_id' in 'where clause']
[type] => DB_Error
[user_info] => SELECT COUNT(*) AS count FROM (SELECT DISTINCT `zuwendung`.`id` AS `zuwendungs_id`, `zuwendung`.`net_amount` AS `nettobetrag` FROM (SELECT `_contribution`.`id` AS `id`, `_contribution`.`contact_id` AS `contact_id`, `_contribution`.`financial_type_id` AS `financial_type_id`, `_contribution`.`contribution_page_id` AS `contribution_page_id`, `_contribution`.`payment_instrument_id` AS `payment_instrument_id`, `_contribution`.`receive_date` AS `receive_date`, `_contribution`.`non_deductible_amount` AS `non_deductible_amount`, `_contribution`.`total_amount` AS `total_amount`, `_contribution`.`fee_amount` AS `fee_amount`, `_contribution`.`net_amount` AS `net_amount`, `_contribution`.`trxn_id` AS `trxn_id`, `_contribution`.`invoice_id` AS `invoice_id`, `_contribution`.`invoice_number` AS `invoice_number`, `_contribution`.`currency` AS `currency`, `_contribution`.`cancel_date` AS `cancel_date`, `_contribution`.`cancel_reason` AS `cancel_reason`, `_contribution`.`receipt_date` AS `receipt_date`, `_contribution`.`thankyou_date` AS `thankyou_date`, `_contribution`.`source` AS `source`, `_contribution`.`amount_level` AS `amount_level`, `_contribution`.`contribution_recur_id` AS `contribution_recur_id`, `_contribution`.`is_test` AS `is_test`, `_contribution`.`is_pay_later` AS `is_pay_later`, `_contribution`.`contribution_status_id` AS `contribution_status_id`, `_contribution`.`address_id` AS `address_id`, `_contribution`.`check_number` AS `check_number`, `_contribution`.`campaign_id` AS `campaign_id`, `_contribution`.`creditnote_id` AS `creditnote_id`, `_contribution`.`tax_amount` AS `tax_amount`, `_contribution`.`revenue_recognition_date` AS `revenue_recognition_date`, `_contribution`.`is_template` AS `is_template`, `_contribution_soft`.`contribution_id` AS `contribution_soft_contribution_id`, `_contribution_soft`.`contact_id` AS `contribution_soft_contact_id`, `_contribution_soft`.`amount` AS `contribution_soft_amount`, `_contribution_soft`.`currency` AS `contribution_soft_currency`, `_contribution_soft`.`pcp_id` AS `contribution_soft_pcp_id`, `_contribution_soft`.`pcp_display_in_roll` AS `contribution_soft_pcp_display_in_roll`, `_contribution_soft`.`pcp_roll_nickname` AS `contribution_soft_pcp_roll_nickname`, `_contribution_soft`.`pcp_personal_note` AS `contribution_soft_pcp_personal_note`, `_contribution_soft`.`soft_credit_type_id` AS `contribution_soft_soft_credit_type_id` FROM `civicrm_contribution` `_contribution` LEFT JOIN `civicrm_contribution_soft` `_contribution_soft` ON `_contribution`.`id` = `_contribution_soft`.`contribution_id` WHERE 1 AND `zuwendung`.`contact_id` = 20653 AND `_contribution`.`is_test` = 0 ) `zuwendung` WHERE 1 ) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column 'zuwendung.contact_id' in 'where clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT COUNT(*) AS count FROM (SELECT DISTINCT `zuwendung`.`id` AS `zuwendungs_id`, `zuwendung`.`net_amount` AS `nettobetrag` FROM (SELECT `_contribution`.`id` AS `id`, `_contribution`.`contact_id` AS `contact_id`, `_contribution`.`financial_type_id` AS `financial_type_id`, `_contribution`.`contribution_page_id` AS `contribution_page_id`, `_contribution`.`payment_instrument_id` AS `payment_instrument_id`, `_contribution`.`receive_date` AS `receive_date`, `_contribution`.`non_deductible_amount` AS `non_deductible_amount`, `_contribution`.`total_amount` AS `total_amount`, `_contribution`.`fee_amount` AS `fee_amount`, `_contribution`.`net_amount` AS `net_amount`, `_contribution`.`trxn_id` AS `trxn_id`, `_contribution`.`invoice_id` AS `invoice_id`, `_contribution`.`invoice_number` AS `invoice_number`, `_contribution`.`currency` AS `currency`, `_contribution`.`cancel_date` AS `cancel_date`, `_contribution`.`cancel_reason` AS `cancel_reason`, `_contribution`.`receipt_date` AS `receipt_date`, `_contribution`.`thankyou_date` AS `thankyou_date`, `_contribution`.`source` AS `source`, `_contribution`.`amount_level` AS `amount_level`, `_contribution`.`contribution_recur_id` AS `contribution_recur_id`, `_contribution`.`is_test` AS `is_test`, `_contribution`.`is_pay_later` AS `is_pay_later`, `_contribution`.`contribution_status_id` AS `contribution_status_id`, `_contribution`.`address_id` AS `address_id`, `_contribution`.`check_number` AS `check_number`, `_contribution`.`campaign_id` AS `campaign_id`, `_contribution`.`creditnote_id` AS `creditnote_id`, `_contribution`.`tax_amount` AS `tax_amount`, `_contribution`.`revenue_recognition_date` AS `revenue_recognition_date`, `_contribution`.`is_template` AS `is_template`, `_contribution_soft`.`contribution_id` AS `contribution_soft_contribution_id`, `_contribution_soft`.`contact_id` AS `contribution_soft_contact_id`, `_contribution_soft`.`amount` AS `contribution_soft_amount`, `_contribution_soft`.`currency` AS `contribution_soft_currency`, `_contribution_soft`.`pcp_id` AS `contribution_soft_pcp_id`, `_contribution_soft`.`pcp_display_in_roll` AS `contribution_soft_pcp_display_in_roll`, `_contribution_soft`.`pcp_roll_nickname` AS `contribution_soft_pcp_roll_nickname`, `_contribution_soft`.`pcp_personal_note` AS `contribution_soft_pcp_personal_note`, `_contribution_soft`.`soft_credit_type_id` AS `contribution_soft_soft_credit_type_id` FROM `civicrm_contribution` `_contribution` LEFT JOIN `civicrm_contribution_soft` `_contribution_soft` ON `_contribution`.`id` = `_contribution_soft`.`contribution_id` WHERE 1 AND `zuwendung`.`contact_id` = 20653 AND `_contribution`.`is_test` = 0 ) `zuwendung` WHERE 1 ) `count_combined_sql_data_flow` [nativecode=1054 ** Unknown column 'zuwendung.contact_id' in 'where clause']"]
)