One of parameters (value: ) is not of the type Integer
Hi All, we're running into an issue when a contribution is attributed to the Financial Type of "Other".
Here's how we reproduce the issue:
- In CiviCRM we "View Contact"
- Select "Contributions" tab
- Clicking "Edit" for a contribution assigned the financial type of "Other" produces the "Network Error Unable to reach the server. Please refresh this page in your browser and try again." error.
- Right clicking the "Edit" and selecting "Open link in new tab" produces the error "One of parameters (value: ) is not of the type Integer" with the following backtrace:
#0 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace()
#1 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Type.php(571): CRM_Core_Error::fatal("One of parameters (value: ) is not of the type Integer")
#2 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1519): CRM_Utils_Type::validate("", "Integer")
#3 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1397): CRM_Core_DAO::composeQuery("SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civic...", (Array:2), TRUE)
#4 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/FinancialTrxn.php(99): CRM_Core_DAO::executeQuery("SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civic...", (Array:2))
#5 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(3991): CRM_Core_BAO_FinancialTrxn::getBalanceTrxnAmt("44726")
#6 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/Form/AbstractEditPayment.php(744): CRM_Contribute_BAO_Contribution::getPaymentInfo("44726", NULL, TRUE)
#7 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/Form/Contribution.php(251): CRM_Contribute_Form_AbstractEditPayment->assignPaymentInfoBlock()
#8 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(585): CRM_Contribute_Form_Contribution->preProcess()
#9 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#10 /home/example/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contribute_Form_Contribution), "display")
#11 /home/example/public_html/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution), "display")
#12 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(349): HTML_QuickForm_Page->handle("display")
#13 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/Page/Tab.php(327): CRM_Core_Controller->run()
#14 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Contribute/Page/Tab.php(378): CRM_Contribute_Page_Tab->edit()
#15 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(311): CRM_Contribute_Page_Tab->run((Array:4), NULL)
#16 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:13))
#17 /home/example/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#18 /home/example/public_html/wp-content/plugins/civicrm/civicrm.php(1392): CRM_Core_Invoke::invoke((Array:4))
#19 /home/example/public_html/wp-includes/class-wp-hook.php(286): CiviCRM_For_WordPress->invoke("")
#20 /home/example/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters("", (Array:1))
#21 /home/example/public_html/wp-includes/plugin.php(465): WP_Hook->do_action((Array:1))
#22 /home/example/public_html/wp-admin/admin.php(253): do_action("toplevel_page_CiviCRM")
This is the URL structure of the new tab: https://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview%2Fcontribution&reset=1&action=update&id=44726&cid=532&context=contribution
Thank you for any help you can provide.