Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.6
-
Fix Version/s: 1.6
-
Component/s: CiviContribute
-
Labels:None
Description
Custom payment instrument lost between 1.5 and 1.6. Giving any payment instrament causes this error.
Sorry. A non-recoverable error has occurred.
Database Error Code: Cannot add or update a child row: a foreign key constraint fails, 1216
Return to CiviCRM menu.
Error Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => UPDATE civicrm_contribution SET domain_id = 1 , contact_id = 832 , contribution_type_id = 1 , payment_instrument_id = 1 , receive_date = 20061111000000 , non_deductible_amount = NULL , total_amount = 65.00 , fee_amount = 2.84 , net_amount = 62.16 , trxn_id = NULL , invoice_id = NULL , currency = 'USD' , cancel_reason = NULL , source = NULL , note = NULL , honor_contact_id = NULL WHERE ( civicrm_contribution.id = 2175 ) [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
[type] => db_error
[user_info] => UPDATE civicrm_contribution SET domain_id = 1 , contact_id = 832 , contribution_type_id = 1 , payment_instrument_id = 1 , receive_date = 20061111000000 , non_deductible_amount = NULL , total_amount = 65.00 , fee_amount = 2.84 , net_amount = 62.16 , trxn_id = NULL , invoice_id = NULL , currency = 'USD' , cancel_reason = NULL , source = NULL , note = NULL , honor_contact_id = NULL WHERE ( civicrm_contribution.id = 2175 ) [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE civicrm_contribution SET domain_id = 1 , contact_id = 832 , contribution_type_id = 1 , payment_instrument_id = 1 , receive_date = 20061111000000 , non_deductible_amount = NULL , total_amount = 65.00 , fee_amount = 2.84 , net_amount = 62.16 , trxn_id = NULL , invoice_id = NULL , currency = 'USD' , cancel_reason = NULL , source = NULL , note = NULL , honor_contact_id = NULL WHERE ( civicrm_contribution.id = 2175 ) [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]"]
)