Error on IPN webhook call on 6.5.4 and MJW 0.9.7
$Fatal Error Details = array(3) { ["message"]=> string(3010) "failed to load related objectsDB Error: already exists #0 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(2627): civicrm_api3('Contribution', 'create', Array) #1 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4478): CRM_Contribute_BAO_Contribution::repeatTransaction(Object(CRM_Contribute_BAO_Contribution), Array, Array, '3') #2 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/v3/Contribution.php(686): CRM_Contribute_BAO_Contribution::completeOrder(Array, Array, Array, Object(CRM_Core_Transaction), NULL) #3 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/v3/Contribution.php(629): _ipn_process_transaction(Array, Object(CRM_Contribute_BAO_Contribution), Array, Array, Object(CRM_Contribute_BAO_Contribution)) #4 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_contribution_repeattransaction(Array) #5 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Kernel.php(150): Civi\API\Provider\MagicFunctionProvider->invoke(Array) #6 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest(Array) #7 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/api.php(131): Civi\API\Kernel->runSafe('Contribution', 'repeattransacti...', Array) #8 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/mjwshared/CRM/Core/Payment/MJWIPNTrait.php(243): civicrm_api3('Contribution', 'repeattransacti...', Array) #9 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php(409): CRM_Core_Payment_StripeIPN->repeatContribution(Array) #10 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php(217): CRM_Core_Payment_StripeIPN->createNextContributionForRecur() #11 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/Stripe.php(1143): CRM_Core_Payment_StripeIPN->main() #12 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php(1619): CRM_Core_Payment_Stripe->handlePaymentNotification() #13 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php(1512): CRM_Core_Payment::handlePaymentMethod('handlePaymentNo...', Array) #14 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): CRM_Core_Payment::handleIPN() #15 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem(Array) #16 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke(Array) #17 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke(Array) #18 /home/webadmin/public_html/cmm/includes/menu.inc(527): civicrm_invoke('payment', 'ipn', '3') #19 /home/webadmin/public_html/cmm/index.php(21): menu_execute_active_handler() #20 {main}" ["code"]=> NULL ["exception"]=> object(CiviCRM_API3_Exception)#2627 (8) { ["extraParams":"CiviCRM_API3_Exception":private]=> array(5) { ["error_code"]=> int(0) ["entity"]=> string(12) "Contribution" ["action"]=> string(17) "repeattransaction" ["is_error"]=> int(1) ["error_message"]=> string(3010) "failed to load related objectsDB Error: already exists #0 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(2627): civicrm_api3('Contribution', 'create', Array) #1 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4478): CRM_Contribute_BAO_Contribution::repeatTransaction(Object(CRM_Contribute_BAO_Contribution), Array, Array, '3') #2 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/v3/Contribution.php(686): CRM_Contribute_BAO_Contribution::completeOrder(Array, Array, Array, Object(CRM_Core_Transaction), NULL) #3 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/v3/Contribution.php(629): _ipn_process_transaction(Array, Object(CRM_Contribute_BAO_Contribution), Array, Array, Object(CRM_Contribute_BAO_Contribution)) #4 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_contribution_repeattransaction(Array) #5 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Kernel.php(150): Civi\API\Provider\MagicFunctionProvider->invoke(Array) #6 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest(Array) #7 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/api.php(131): Civi\API\Kernel->runSafe('Contribution', 'repeattransacti...', Array) #8 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/mjwshared/CRM/Core/Payment/MJWIPNTrait.php(243): civicrm_api3('Contribution', 'repeattransacti...', Array) #9 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php(409): CRM_Core_Payment_StripeIPN->repeatContribution(Array) #10 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php(217): CRM_Core_Payment_StripeIPN->createNextContributionForRecur() #11 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/Stripe.php(1143): CRM_Core_Payment_StripeIPN->main() #12 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php(1619): CRM_Core_Payment_Stripe->handlePaymentNotification() #13 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php(1512): CRM_Core_Payment::handlePaymentMethod('handlePaymentNo...', Array) #14 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): CRM_Core_Payment::handleIPN() #15 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem(Array) #16 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke(Array) #17 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke(Array) #18 /home/webadmin/public_html/cmm/includes/menu.inc(527): civicrm_invoke('payment', 'ipn', '3') #19 /home/webadmin/public_html/cmm/index.php(21): menu_execute_active_handler() #20 {main}" } ["message":protected]=> string(3010) "failed to load related objectsDB Error: already exists #0 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(2627): civicrm_api3('Contribution', 'create', Array) #1 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4478): CRM_Contribute_BAO_Contribution::repeatTransaction(Object(CRM_Contribute_BAO_Contribution), Array, Array, '3') #2 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/v3/Contribution.php(686): CRM_Contribute_BAO_Contribution::completeOrder(Array, Array, Array, Object(CRM_Core_Transaction), NULL) #3 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/v3/Contribution.php(629): _ipn_process_transaction(Array, Object(CRM_Contribute_BAO_Contribution), Array, Array, Object(CRM_Contribute_BAO_Contribution)) #4 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_contribution_repeattransaction(Array) #5 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Kernel.php(150): Civi\API\Provider\MagicFunctionProvider->invoke(Array) #6 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/Civi/API/Kernel.php(81): Civi\API\Kernel->runRequest(Array) #7 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/api.php(131): Civi\API\Kernel->runSafe('Contribution', 'repeattransacti...', Array) #8 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/mjwshared/CRM/Core/Payment/MJWIPNTrait.php(243): civicrm_api3('Contribution', 'repeattransacti...', Array) #9 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php(409): CRM_Core_Payment_StripeIPN->repeatContribution(Array) #10 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php(217): CRM_Core_Payment_StripeIPN->createNextContributionForRecur() #11 /home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/Stripe.php(1143): CRM_Core_Payment_StripeIPN->main() #12 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php(1619): CRM_Core_Payment_Stripe->handlePaymentNotification() #13 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php(1512): CRM_Core_Payment::handlePaymentMethod('handlePaymentNo...', Array) #14 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(278): CRM_Core_Payment::handleIPN() #15 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem(Array) #16 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke(Array) #17 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke(Array) #18 /home/webadmin/public_html/cmm/includes/menu.inc(527): civicrm_invoke('payment', 'ipn', '3') #19 /home/webadmin/public_html/cmm/index.php(21): menu_execute_active_handler() #20 {main}" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(0) ["file":protected]=> string(68) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/api/api.php" ["line":protected]=> int(133) ["trace":"Exception":private]=> array(12) { [0]=> array(4) { ["file"]=> string(105) "/home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/mjwshared/CRM/Core/Payment/MJWIPNTrait.php" ["line"]=> int(243) ["function"]=> string(12) "civicrm_api3" ["args"]=> array(3) { [0]=> string(12) "Contribution" [1]=> string(17) "repeattransaction" [2]=> array(9) { ["contribution_recur_id"]=> string(3) "230" ["contribution_status_id"]=> int(2) ["receive_date"]=> string(14) "20201109122653" ["order_reference"]=> string(27) "in_1HlZSTA7J6ExrhfuzJOwTz9K" ["trxn_id"]=> string(27) "in_1HlZSTA7J6ExrhfuzJOwTz9K" ["total_amount"]=> int(5) ["fee_amount"]=> float(0.26) ["is_email_receipt"]=> bool(false) ["version"]=> int(3) } } } [1]=> array(6) { ["file"]=> string(100) "/home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php" ["line"]=> int(409) ["function"]=> string(18) "repeatContribution" ["class"]=> string(26) "CRM_Core_Payment_StripeIPN" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> array(7) { ["contribution_recur_id"]=> string(3) "230" ["contribution_status_id"]=> int(2) ["receive_date"]=> string(14) "20201109122653" ["order_reference"]=> string(27) "in_1HlZSTA7J6ExrhfuzJOwTz9K" ["trxn_id"]=> string(27) "ch_1HlaOjA7J6Exrhfu48N5cAn0" ["total_amount"]=> int(5) ["fee_amount"]=> float(0.26) } } } [2]=> array(6) { ["file"]=> string(100) "/home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/StripeIPN.php" ["line"]=> int(217) ["function"]=> string(30) "createNextContributionForRecur" ["class"]=> string(26) "CRM_Core_Payment_StripeIPN" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(97) "/home/webadmin/public_html/cmm/sites/default/files/civicrm/ext/stripe/CRM/Core/Payment/Stripe.php" ["line"]=> int(1143) ["function"]=> string(4) "main" ["class"]=> string(26) "CRM_Core_Payment_StripeIPN" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [4]=> array(6) { ["file"]=> string(77) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php" ["line"]=> int(1619) ["function"]=> string(25) "handlePaymentNotification" ["class"]=> string(23) "CRM_Core_Payment_Stripe" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [5]=> array(6) { ["file"]=> string(77) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Payment.php" ["line"]=> int(1512) ["function"]=> string(19) "handlePaymentMethod" ["class"]=> string(16) "CRM_Core_Payment" ["type"]=> string(2) "::" ["args"]=> array(2) { [0]=> string(25) "handlePaymentNotification" [1]=> array(3) { ["processor_name"]=> NULL ["processor_id"]=> string(1) "3" ["mode"]=> NULL } } } [6]=> array(6) { ["file"]=> string(76) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=> int(278) ["function"]=> string(9) "handleIPN" ["class"]=> string(16) "CRM_Core_Payment" ["type"]=> string(2) "::" ["args"]=> array(0) { } } [7]=> array(6) { ["file"]=> string(76) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=> int(68) ["function"]=> string(7) "runItem" ["class"]=> string(15) "CRM_Core_Invoke" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> &array(14) { ["id"]=> string(3) "215" ["domain_id"]=> string(1) "1" ["path"]=> string(19) "civicrm/payment/ipn" ["access_callback"]=> string(1) "1" ["access_arguments"]=> array(2) { [0]=> array(1) { [0]=> string(21) "access CiviContribute" } [1]=> string(3) "and" } ["page_callback"]=> array(2) { [0]=> string(16) "CRM_Core_Payment" [1]=> string(9) "handleIPN" } ["breadcrumb"]=> array(2) { [0]=> array(2) { ["title"]=> string(7) "CiviCRM" ["url"]=> string(16) "/civicrm?reset=1" } [1]=> array(2) { ["title"]=> string(11) "New Payment" ["url"]=> string(39) "/civicrm/payment?reset=1&action=add" } } ["component_id"]=> string(1) "2" ["is_public"]=> string(1) "1" ["is_ssl"]=> string(1) "0" ["weight"]=> string(1) "1" ["type"]=> string(1) "1" ["page_type"]=> string(1) "0" ["page_arguments"]=> bool(false) } } } [8]=> array(6) { ["file"]=> string(76) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php" ["line"]=> int(36) ["function"]=> string(7) "_invoke" ["class"]=> string(15) "CRM_Core_Invoke" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> array(4) { [0]=> string(7) "civicrm" [1]=> string(7) "payment" [2]=> string(3) "ipn" [3]=> string(1) "3" } } } [9]=> array(6) { ["file"]=> string(78) "/home/webadmin/public_html/cmm/sites/all/modules/civicrm/drupal/civicrm.module" ["line"]=> int(454) ["function"]=> string(6) "invoke" ["class"]=> string(15) "CRM_Core_Invoke" ["type"]=> string(2) "::" ["args"]=> array(1) { [0]=> array(4) { [0]=> string(7) "civicrm" [1]=> string(7) "payment" [2]=> string(3) "ipn" [3]=> string(1) "3" } } } [10]=> array(4) { ["file"]=> string(48) "/home/webadmin/public_html/cmm/includes/menu.inc" ["line"]=> int(527) ["function"]=> string(14) "civicrm_invoke" ["args"]=> array(3) { [0]=> string(7) "payment" [1]=> string(3) "ipn" [2]=> string(1) "3" } } [11]=> array(4) { ["file"]=> string(40) "/home/webadmin/public_html/cmm/index.php" ["line"]=> int(21) ["function"]=> string(27) "menu_execute_active_handler" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL } }
Backtrace:
$backTrace = #0 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Error.php(433): CRM_Core_Error::backtrace("backTrace", TRUE) #1 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/CRM/Core/Invoke.php(39): CRM_Core_Error::handleUnhandledException(Object(CiviCRM_API3_Exception)) #2 /home/webadmin/public_html/cmm/sites/all/modules/civicrm/drupal/civicrm.module(454): CRM_Core_Invoke::invoke((Array:4)) #3 /home/webadmin/public_html/cmm/includes/menu.inc(527): civicrm_invoke("payment", "ipn", "3") #4 /home/webadmin/public_html/cmm/index.php(21): menu_execute_active_handler() #5 {main}
$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [code] => -5 [message] => DB Error: already exists [mode] => 16 [debug_info] => INSERT INTO
civicrm_contribution (
contact_id,
financial_type_id,
contribution_page_id,
payment_instrument_id,
receive_date,
total_amount,
fee_amount,
net_amount,
trxn_id,
currency,
source,
contribution_recur_id,
is_test,
contribution_status_id,
check_number) VALUES ( 3771 , 19 , 13 , 1 , 20201109122653 , 5 , 0.26 , 4.74 , 'in_1HlZSTA7J6ExrhfuzJOwTz9K' , 'GBP' , 'Online Contribution: Membership' , 230 , 0 , 2 , NULL ) [nativecode=1062 ** Duplicate entry 'in_1HlZSTA7J6ExrhfuzJOwTz9K' for key 'UI_contrib_trxn_id'] [type] => DB_Error [user_info] => INSERT INTO
civicrm_contribution (
contact_id,
financial_type_id,
contribution_page_id,
payment_instrument_id,
receive_date,
total_amount,
fee_amount,
net_amount,
trxn_id,
currency,
source,
contribution_recur_id,
is_test,
contribution_status_id,
check_number) VALUES ( 3771 , 19 , 13 , 1 , 20201109122653 , 5 , 0.26 , 4.74 , 'in_1HlZSTA7J6ExrhfuzJOwTz9K' , 'GBP' , 'Online Contribution: Membership' , 230 , 0 , 2 , NULL ) [nativecode=1062 ** Duplicate entry 'in_1HlZSTA7J6ExrhfuzJOwTz9K' for key 'UI_contrib_trxn_id'] [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO
civicrm_contribution (
contact_id,
financial_type_id,
contribution_page_id,
payment_instrument_id,
receive_date,
total_amount,
fee_amount,
net_amount,
trxn_id,
currency,
source,
contribution_recur_id,
is_test,
contribution_status_id,
check_number ) VALUES ( 3771 , 19 , 13 , 1 , 20201109122653 , 5 , 0.26 , 4.74 , 'in_1HlZSTA7J6ExrhfuzJOwTz9K' , 'GBP' , 'Online Contribution: Membership' , 230 , 0 , 2 , NULL ) [nativecode=1062 ** Duplicate entry 'in_1HlZSTA7J6ExrhfuzJOwTz9K' for key 'UI_contrib_trxn_id']"] )