Errors occurring with AuthorizeNetIPN payment messages

[ehendricks]

Drupal 7, Civicrm 4.5.1

Below is a trace of one of the error.  Pretty much none of the payment updates are being received.

Code: [Select]

Oct 14 04:03:38  [info] $Fatal Error Details = Array
(
    [message] => One of parameters  (value: ) is not of the type Integer
    [code] =>
)


Oct 14 04:03:38  [info] $backTrace = #0 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Core/Error.php(387): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Utils/Type.php(347): CRM_Core_Error::fatal("One of parameters  (value: ) is not of the type Integer")
#2 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1183): CRM_Utils_Type::validate(NULL, "Integer")
#3 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(1149): CRM_Core_DAO::composeQuery("\n      SELECT membership_num_terms FROM civicrm_line_item li\n      LEFT JOI...", (Array:2), TRUE)
#4 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(261): CRM_Core_DAO::singleValueQuery("\n      SELECT membership_num_terms FROM civicrm_line_item li\n      LEFT JOI...", (Array:2))
#5 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Core/Payment/BaseIPN.php(404): CRM_Contribute_BAO_Contribution->getNumTermsByContributionAndMembershipType("3")
#6 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Core/Payment/AuthorizeNetIPN.php(197): CRM_Core_Payment_BaseIPN->completeTransaction((Array:18), (Array:7), (Array:8), Object(CRM_Core_Transaction), Object(CRM_Contribute_BAO_ContributionRecur))
#7 /home/fshares/public_html/sites/all/modules/civicrm/CRM/Core/Payment/AuthorizeNetIPN.php(80): CRM_Core_Payment_AuthorizeNetIPN->recur((Array:18), (Array:7), (Array:8), FALSE)
#8 /home/fshares/public_html/sites/all/modules/civicrm/extern/authorizeIPN.php(42): CRM_Core_Payment_AuthorizeNetIPN->main()
#9 {main}
I have traced it to /CRM/Contribute/BAO/Contribution.php, the function getNumTermsByContributionAndMembershipType.  The validation of the query parameters is failing (1 or both parameters isn't an Integer).  I am having trouble setting up a test so I thought I might see if I could get help here.  This function is totally new and I am not sure what its supposed to be doing.

Any help would be appreciated.  Only one site is effected so far but others will be soon.

Thanks

[Dave Greenberg]

Ellen - Eileen (Fuzion) has committed a fix for this in 4.6 but the actual fix seems to be limited to this commit:
https://github.com/eileenmcnaughton/civicrm-core/commit/a284891b424c509c8a74eaf609691b26e65bc87c.patch

The patch does apply to 4.5 (just tried it) and looks like it will fix the problem in 4.5. Would be great if you could try the patch and see if it fixes the problem.

[ehendricks]

I apologize for the delay in replying.  I did apply the patch and it worked.

Thanks!

[Dave Greenberg]

Thanks. Ported the patch for 4.5.5 pending another round of QA by Jeremy P.
https://issues.civicrm.org/jira/browse/CRM-15621