CiviCRM Community Forums (archive)

I am trying to get the Payflow extension working with a Civi 4.2 and Drupal 7. My extensions directory is outside the civi root as directed, so it's in /sites/all/civicrm_extend. The first issue is that PayFlowLinkIPN.php has the wrong paths to civicrm.config.php and Core/Config.php, but those were easy enough to fix (I can post a bug report about that as well once I get this working). So now that I altered those I get the correct 'Failure: Missing Parameter' message when I go to mysite.com/sites/all/civicrm_extend/nz.co.fuzion.payflowlink/extern/PayFlowLinkIPN.php. So this is good, and I put that link in the return url and silent url settings of manager.paypal.com.

Next I go to try to use the test credit card.  The one listed in the tutorial at http://wiki.civicrm.org/confluence/display/CRMDOC42/PayFlow+Link is no longer working, so I called PayPal and they gave me a link to a site that updates new test cards every few hours.

http://www.darkcoding.net/credit-card-numbers/

So, when I test it with one of the fresh numbers, I get a white screen with this message:

Failure: Amount values dont match between database and IPN request

I am testing on an amount of $300, which according to the tutorial suggests it should return a code 0.

So then I log in to the manager.paypal.com and look at my test transactions, and I see there that in fact it odes look like the transactions are working, as they are showing with a code 0. I have the security settings of manager.paypal.com set to csc at full.

Ideas on why we are getting this failure (white screen with just the text Failure: Amount values dont match between database and IPN request)?

Thanks much in advance!
Emily

After working with Eileen a bit over IRC, I was able to resolve the majority of the payflow issues. A lot of it was because the POST var is empty and just needed to be replaced with REQUEST.

I am attaching a git diff patch with all my changes.

However, now upon testing payment and being returned to my site I get a Civi core error that I haven't been able to work through. Here is my backtrace:

Warning: Invalid argument supplied for foreach() in /public_html/sites/all/modules/civicrm/CRM/Core/Error.php on line 601
backTrace

#0 /public_html/sites/all/modules/civicrm/CRM/Core/Error.php(307): CRM_Core_Error::backtrace()
#1 /public_html/sites/all/modules/civicrm/CRM/Utils/Type.php(324): CRM_Core_Error::fatal("One of parameters  (value: ) is not of the type Integer")
#2 /public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(982): CRM_Utils_Type::validate(NULL, "Integer")
#3/public_html/sites/all/modules/civicrm/CRM/Core/DAO.php(907): CRM_Core_DAO::composeQuery(" SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,\n    ...", (Array:1), TRUE)
#4 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Phone.php(227): CRM_Core_DAO::executeQuery(" SELECT phone, ltype.name as locationType, ph.is_primary as is_primary,\n    ...", (Array:1))
#5 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Block.php(191) : eval()'d code(1): CRM_Core_BAO_Phone::allEntityPhones((Array:2))
#6 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Block.php(191): eval()
#7 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Block.php(78): CRM_Core_BAO_Block::getBlockIds("phone", NULL, (Array:2))
#8 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Phone.php(109): CRM_Core_BAO_Block::getValues("phone", (Array:2))
#9 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Location.php(263) : eval()'d code(1): CRM_Core_BAO_Phone::getValues((Array:2), FALSE)
#10 /public_html/sites/all/modules/civicrm/CRM/Core/BAO/Location.php(263): eval()
#11 /public_html/sites/all/modules/civicrm/CRM/Core/Payment/BaseIPN.php(401): CRM_Core_BAO_Location::getValues((Array:2))
#12 /public_html/sites/all/civicrm_extend/nz.co.fuzion.payflowlink/CRM/Core/Payment/PayflowLinkIPN.php(119): CRM_Core_Payment_BaseIPN->completeTransaction((Array:12), (Array:8), (Array:8), Object(CRM_Core_Transaction), FALSE)
#13 /public_html/sites/all/civicrm_extend/nz.co.fuzion.payflowlink/CRM/Core/Payment/PayflowLinkIPN.php(167): CRM_Core_Payment_PayflowLinkIPN->single((Array:12), (Array:8), (Array:8), FALSE, FALSE)
#14 /public_html/sites/all/civicrm_extend/nz.co.fuzion.payflowlink/extern/PayFlowLinkIPN.php(19): CRM_Core_Payment_PayflowLinkIPN->main()
#15 {main}