CiviCRM Community Forums (archive)

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.

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

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

Thanks!