Support

Home Forums Event Espresso Premium PayPal ipn problems (2)

PayPal ipn problems (2)

Posted: February 24, 2014 at 8:15 pm


cori nevruz

February 24, 2014 at 8:15 pm

Set up so an initial payment (deposit) is made, we change the fee, send payment reminder for the remainder due… First transaction is recorded fine, second payment ipn is failing… Sending ipn failure email, setting a transaction id but not the right paypal transaction id, the deposit/amount paid is wiped out and status is changed to incomplete all when the payment actually went through and they are paid up….
Ipn is set up in paypal and enabled and transaction page is public with the proper short code…
What els can I check?


Tony

  • Support Staff

February 25, 2014 at 1:43 am

Hi Cori,

Which version of Event Espresso is this please?


cori nevruz

February 25, 2014 at 4:19 am

3.9.35.2.p


cori nevruz

February 25, 2014 at 4:58 am

I checked the logs and it appears it is being written to fine and although it says transaction error, no error really pops out at me… they all look like this:

[10/07/2013 8:41 AM] – Errors from IPN Validation:

Using BUILT-IN PHP curl methods
key = mc_gross
value = 0.01
key = protection_eligibility
value = Ineligible
key = item_number1
value =
key = payer_id
value = AUE6WS7LP9EVA
key = tax
value = 0.00
key = payment_date
value = 05:40:36 Oct 07, 2013 PDT
key = payment_status
value = Completed
key = charset
value = windows-1252
key = mc_shipping
value = 0.00
key = mc_handling
value = 0.00
key = first_name
value = Cori
key = mc_fee
value = 0.01
key = notify_version
value = 3.7
key = custom
value =
key = payer_status
value = verified
key = business
value = info@packswimcamp.com
key = num_cart_items
value = 1
key = mc_handling1
value = 0.00
key = verify_sign
value = AsxfXDMVYdoQemXTOd-YLjFceenRAyRz3WjGSD2ho3miwTtOIqnZz2G9
key = payer_email
value = cori.nevsss@spyderwoman.com
key = mc_shipping1
value = 0.00
key = tax1
value = 0.00
key = txn_id
value = 88P83444SV5046730
key = payment_type
value = instant
key = payer_business_name
value = SpyderWoman, LLC
key = last_name
value = Nevruz
key = item_name1
value = Commuter Camper Deposit Only for Overnight: June 15-19 (Sun-Thurs). Attendee: Cori Test
key = receiver_email
value = info@packswimcamp.com
key = payment_fee
value = 0.01
key = quantity1
value = 1
key = receiver_id
value = YZZPDXZQW2MBS
key = txn_type
value = cart
key = mc_gross_1
value = 0.01
key = mc_currency
value = USD
key = residence_country
value = US
key = transaction_subject
value =
key = payment_gross
value = 0.01
key = ipn_track_id
value = 82443589c50a9
Success Setting host: https://www.paypal.com/cgi-bin/webscr
Success Setting request type to post
Success Setting post fields: mc_gross=0.01&protection_eligibility=Ineligible&item_number1=&payer_id=AUE6WS7LP9EVA&tax=0.00&payment_date=05%3A40%3A36+Oct+07%2C+2013+PDT&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=Cori&mc_fee=0.01&notify_version=3.7&custom=&payer_status=verified&business=info%40packswimcamp.com&num_cart_items=1&mc_handling1=0.00&verify_sign=AsxfXDMVYdoQemXTOd-YLjFceenRAyRz3WjGSD2ho3miwTtOIqnZz2G9&payer_email=cori.xxx%40spyderwoman.com&mc_shipping1=0.00&tax1=0.00&txn_id=88P83444SV5046730&payment_type=instant&payer_business_name=SpyderWoman%2C+LLC&last_name=Nevruz&item_name1=Commuter+Camper+Deposit+Only+for+Overnight%3A+June+15-19+%28Sun-Thurs%29.+Attendee%3A+Cori+Test&receiver_email=info%40packswimcamp.com&payment_fee=0.01&quantity1=1&receiver_id=YZZPDXZQW2MBS&txn_type=cart&mc_gross_1=0.01&mc_currency=USD&residence_country=US&transaction_subject=&payment_gross=0.01&ipn_track_id=82443589c50a9&cmd=_notify-validate
Success Setting Fain On Error
Success Setting return transfer
Success Setting Timeout
Success Setting verbose mode
Errors resulting from the execution of curl transfer: [10/07/2013 8:41 AM] – SUCCESS!
IPN POST Vars from gateway:
mc_gross=0.01, protection_eligibility=Ineligible, item_number1=, payer_id=AUE6WS7LP9EVA, tax=0.00, payment_date=05:40:36 Oct 07, 2013 PDT, payment_status=Completed, charset=windows-1252, mc_shipping=0.00, mc_handling=0.00, first_name=Cori, mc_fee=0.01, notify_version=3.7, custom=, payer_status=verified, business=info@packswimcamp.com, num_cart_items=1, mc_handling1=0.00, verify_sign=AsxfXDMVYdoQemXTOd-YLjFceenRAyRz3WjGSD2ho3miwTtOIqnZz2G9, payer_email=cori.nevruz@spyderwoman.com, mc_shipping1=0.00, tax1=0.00, txn_id=88P83444SV5046730, payment_type=instant, payer_business_name=SpyderWoman, LLC, last_name=Nevruz, item_name1=Commuter Camper Deposit Only for Overnight: June 15-19 (Sun-Thurs). Attendee: Cori Test, receiver_email=info@packswimcamp.com, payment_fee=0.01, quantity1=1, receiver_id=YZZPDXZQW2MBS, txn_type=cart, mc_gross_1=0.01, mc_currency=USD, residence_country=US, transaction_subject=, payment_gross=0.01, ipn_track_id=82443589c50a9,
IPN Response from gateway Server:
VERIFIED


Tony

  • Support Staff

February 25, 2014 at 5:00 am

Can you confirm the version number please? The latest version is 3.1.36.4.p Just checking that it is a typo.

Partial payments are not official supported within Event Espresso core although we do have a work around with some modifications to allow them to work with Paypal:

https://eventespresso.com/wiki/setting-partial-payments-ee/

This would also allow your attendee to pay a deposit within the need to edit the payment data.

I would recommend backing up the site (both the files and database)

Then update to the latest version of Event Espresso and setup the Partial Payments mod above.


cori nevruz

February 25, 2014 at 5:04 am

3.9.35.2.p
As of now all deposits for the upcoming scheduled events are paid and all are paying their remainder through our work around. Partial payments was not ready when we launched. When these events end we plan to use the new mod. I admit I am a bit worried about upgrading at this time only b/c all registered users have at least paid their ‘deposit’ and a lot are fully paid (and more are paying every day)… hate to throw a wrench in things now. I just need to get the IPN to update the status properly…


cori nevruz

February 25, 2014 at 7:48 am

Can u tell anything by the log entry?


cori nevruz

February 25, 2014 at 10:12 am

Yes sorry… 3.1.35.2.p
And wp version 3.6.1
I would love to find out why this is suddenly not updating the payment and status (although it does update the transaction num) and get it fixed until we got through this registration cycle. I will happily update both wp and ee as soon as all final payments are made…
Upgrading in the midst of this makes me nervous πŸ™‚
Thanks!


cori nevruz

February 25, 2014 at 5:25 pm

I updated wordpress and ee and edited the code to use the partial payments modification… Very smooth transition… Whew. Also, now the ipn is working. My last question now is, when a user is taken to the page to pay they do not have the ability to edit the payment as I saw in the screenshots… I saw it said it only works w paypal standard… But in all my troubleshooting today I thought you had to have paypal business to use ipn
Can u clarify?
Thanks


cori nevruz

February 25, 2014 at 5:57 pm

Okay, got it. It DOES work with PayPal Business… I just had to set Bypass Payment Overview to NO in Payment Settings…. that was that I had previously turned on during my troubleshooting… It is all working brilliantly! Thank you!


Tony

  • Support Staff

February 27, 2014 at 5:34 am

Hi Cori,

I’m sorry I missed your previous question, but glad that updating and using the partial payment mod worked for you πŸ™‚

In regards to the account type, it should actually make no difference for Event Espresso, IPN is a feature available for both Personal and Business accounts and can be used for both.

As you found, bypassing the Payment Overview was the cause as this page contains the edit payment options.

Anyway, I’m glad this resolved your issue should you have any further issues just let us know.


cori nevruz

March 3, 2014 at 7:39 am

I know that Partial Payments is not a supported full function but after more testing I am realizing that the IPN is erroring when partial payments are made. The payment goes through but the amount paid and status is not updated in the attendee’s record and an email is received that says IPN failure from PayPal… How can I best troubleshoot this?
If I bypass the page that allows partial payments, it works great.
Thanks in advance.


Josh

  • Support Staff

March 4, 2014 at 3:01 pm

Hi Cori,

Usually the IPN can be troubleshot by looking at the errors in the IPN log located in /wp-content/uploads/espresso/logs.


cori nevruz

March 5, 2014 at 4:31 am

Thank you, Can you help me decipher this error… I do not see where the problem is other than the fact it says Errors…

[03/03/2014 9:39 AM] – Errors from IPN Validation:

Using BUILT-IN PHP curl methods
key = mc_gross
value = 155.00
key = protection_eligibility
value = Ineligible
key = item_number1
value =
key = payer_id
value = AUE6WS7LP9EVA
key = tax
value = 0.00
key = payment_date
value = 06:39:03 Mar 03, 2014 PST
key = payment_status
value = Completed
key = charset
value = windows-1252
key = mc_shipping
value = 0.00
key = mc_handling
value = 0.00
key = first_name
value = Cori
key = mc_fee
value = 4.80
key = notify_version
value = 3.7
key = custom
value =
key = payer_status
value = verified
key = business
value = info@packswimcamp.com
key = num_cart_items
value = 1
key = mc_handling1
value = 0.00
key = verify_sign
value = Ad3cle44xelzoD3hnb4nZHWUsI4OAy5O09kig-3ZwUsNjBIFGvVroQ.A
key = payer_email
value = cori.nxxz@xxxx.com
key = mc_shipping1
value = 0.00
key = tax1
value = 0.00
key = txn_id
value = 1MG55368PE495713M
key = payment_type
value = instant
key = payer_business_name
value = SpyderWoman, LLC
key = last_name
value = xxxx
key = item_name1
value = Day Camper Fee for Day Camp: June 23-27 (Mon-Fri). Attendee: Coltrane DELETE ME
key = receiver_email
value = info@packswimcamp.com
key = payment_fee
value = 4.80
key = quantity1
value = 1
key = receiver_id
value = YZZPDXZQW2MBS
key = txn_type
value = cart
key = mc_gross_1
value = 155.00
key = mc_currency
value = USD
key = residence_country
value = US
key = transaction_subject
value =
key = payment_gross
value = 155.00
key = ipn_track_id
value = 268900811eb5c
Success Setting host: https://www.paypal.com/cgi-bin/webscr
Success Setting request type to post
Success Setting post fields: mc_gross=155.00&protection_eligibility=Ineligible&item_number1=&payer_id=AUE6WS7LP9EVA&tax=0.00&payment_date=06%3A39%3A03+Mar+03%2C+2014+PST&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=Cori&mc_fee=4.80&notify_version=3.7&custom=&payer_status=verified&business=info%40packswimcamp.com&num_cart_items=1&mc_handling1=0.00&verify_sign=Ad3cle44xelzoD3hnb4nZHWUsI4OAy5O09kig-3ZwUsNjBIFGvVroQ.A&payer_email=cori.xx%40xxx.com&mc_shipping1=0.00&tax1=0.00&txn_id=1MG55368PE495713M&payment_type=instant&payer_business_name=SpyderWoman%2C+LLC&last_name=Nevruz&item_name1=Day+Camper+Fee+for+Day+Camp%3A+June+23-27+%28Mon-Fri%29.+Attendee%3A+Coltrane+DELETE+ME&receiver_email=info%40packswimcamp.com&payment_fee=4.80&quantity1=1&receiver_id=YZZPDXZQW2MBS&txn_type=cart&mc_gross_1=155.00&mc_currency=USD&residence_country=US&transaction_subject=&payment_gross=155.00&ipn_track_id=268900811eb5c&cmd=_notify-validate
Success Setting Fain On Error
Success Setting return transfer
Success Setting Timeout
Success Setting verbose mode
Errors resulting from the execution of curl transfer: [03/03/2014 9:39 AM] – SUCCESS!
IPN POST Vars from gateway:
mc_gross=155.00, protection_eligibility=Ineligible, item_number1=, payer_id=AUE6WS7LP9EVA, tax=0.00, payment_date=06:39:03 Mar 03, 2014 PST, payment_status=Completed, charset=windows-1252, mc_shipping=0.00, mc_handling=0.00, first_name=Cori, mc_fee=4.80, notify_version=3.7, custom=, payer_status=verified, business=info@packswimcamp.com, num_cart_items=1, mc_handling1=0.00, verify_sign=Ad3cle44xelzoD3hnb4nZHWUsI4OAy5O09kig-3ZwUsNjBIFGvVroQ.A, payer_email=cori.nexxz@spydexxn.com, mc_shipping1=0.00, tax1=0.00, txn_id=1MG55368PE495713M, payment_type=instant, payer_business_name=SpyderWoman, LLC, last_name=Nxxuz, item_name1=Day Camper Fee for Day Camp: June 23-27 (Mon-Fri). Attendee: xxane DELETE ME, receiver_email=info@packswimcamp.com, payment_fee=4.80, quantity1=1, receiver_id=YZZPDXZQW2MBS, txn_type=cart, mc_gross_1=155.00, mc_currency=USD, residence_country=US, transaction_subject=, payment_gross=155.00, ipn_track_id=268900811eb5c,
IPN Response from gateway Server:
VERIFIED


Josh

  • Support Staff

March 5, 2014 at 8:01 am

Hi there,

It turns out that it’s saying there are no errors. If there were something other than Success where it says:

Errors resulting from the execution of curl transfer: [03/03/2014 9:39 AM] – SUCCESS!

Then that would mean there are errors.


cori nevruz

March 5, 2014 at 8:10 am

Thanks Josh, So where do I go from here.
The status and paid amount are not getting updated and an email is getting trigged saying there is an IPN error but the payment is going through…

The email says:

Subject: Instant Payment Notification – Gateway Variable Dump

An instant payment notification failed

Then dumps the data but o actual error…


Josh

  • Support Staff

March 5, 2014 at 3:35 pm

Hi Cori,

Is this happening to both full payments (where no partial payment modifications are involved) or only with partial payments?


cori nevruz

March 5, 2014 at 5:19 pm

Only partial payments. In fact, if I bypass payment overview so they have to pay full amount there are no errors at all…


Josh

  • Support Staff

March 6, 2014 at 1:10 pm

Hi Cori,

While I don’t fully understand the partial payment implementation that you have set up, the issue you’re running into may be related to where the PayPal gateway checks to see if the amount paid is equal or greater than the total cost of the ticket. Normally what this check does is prevent a clever/dishonest ticket buyer from changing the payment amount that gets sent off to PayPal to get a cheaper ticket. You can try removing that check, it’s in gateways/paypal/paypal_ipn.php on line 27. With that check removed it will look like this:

if ($myPaypal->ipnData['payment_status'] == 'Completed' || $myPaypal->ipnData['payment_status'] == 'Pending') {

The support post ‘PayPal ipn problems (2)’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso