|
Mutiara Hobbs
|
March 9, 2017 at 2:20 pm
Event Espresso version 3.1.37.11.P
WordPress version WP 4.7.3
I’m getting a strange behavior where some event registrations are going through just fine people sign up pay via PayPal standard and they get marked in the dashboard as “Completed”. In these instances I’ll receive 2 emails one from paypal showing payment and one from the website showing registration.I can see the IPN transactions in PayPal and everything.
Other times I’ll get the email from PayPal saying a person has paid but no email from my website saying they’ve registered. In PayPal I can see the IPN message and it’s been sent and received a HTTP 200 response, but in the Event Dashboard the attendee is still marked as “Incomplete”.
Our of 4 registrations today 3 went through just fine and one ended up like the second scenario.
Really stumped on why Event Espresso isn’t honoring the IPN messages in the second scenario.
|
|
Josh
|
March 9, 2017 at 3:09 pm
The first thing to find out is whether your site that has Event Espresso is actually getting those IPN messages. You can check the IPN log if you can FTP into the server, then go to /wp-content/uploads/espresso/logs. You’ll find an IPN log there. There are some other PayPal troubleshooting steps in this guide:
https://eventespresso.com/wiki/how-to-set-up-paypal-ipn/#troubleshooting
|
|
Mutiara Hobbs
|
March 10, 2017 at 10:07 am
Josh,
I downloadedteh paypal.ipn_results.log file from my uploads folder like you mentioned and there is no record of the transaction in question in the log. The other 3 are showing up just fine. So you’re saying that this means the IPN message never got to my site even though PayPal is showing an HTTP 200 response in their IPN History log?
I’ve spoken with my hosting provider to ensure caching is disabled for the /transactions page and based on this list of ips from paypal https://www.paypal-knowledge.com/infocenter/index?page=content&widgetview=true&id=FAQ1056 they’re not seeing any blocked traffic at the firewall level.
I’ve also started using the simplified transaction template as of yesterday morning before we had this latest “incomplete” transaction.
|
|
Josh
|
March 10, 2017 at 10:23 am
So you’re saying that this means the IPN message never got to my site even though PayPal is showing an HTTP 200 response in their IPN History log?
I didn’t say that, but when the IPN isn’t logged, then that indicates something went wrong with that IPN because it didn’t get written to the log. Can you try resending that IPN via the PayPal IPN history page?
|
|
Mutiara Hobbs
|
March 10, 2017 at 3:05 pm
Yep, I’ve logged into PayPal’s IPN History page and tried to resend the IPN. When viewing the Message ID it is showing a status of sent and HTTP code of 200 but the payment status for the attendees is still showing “Incomplete”
|
|
Josh
|
March 10, 2017 at 5:38 pm
Does your server’s access log indicate the IPN made it to the IPN listener page?
|
|
Mutiara Hobbs
|
March 13, 2017 at 9:21 am
Josh,
Yes according to the access logs from the server the PayPal IPN made it to the site.
From PayPal:
Message ID 6GX31577MG647862P
Date/time created 3/10/2017 06:08 PST
Original/Resent Original
Latest delivery attempt date/time 3/10/2017 06:08 PST
Notification URL http://thepaintfactorymn.com/transactions/?r_id=896-58c2b2c90ad92
From Server Access Log
173.0.81.1 – – [10/Mar/2017:22:01:23 +0000] “POST /transactions/?r_id=896-58c2b2c90ad92 HTTP/1.0” 200 1584 “-” “PayPal IPN ( https://www.paypal.com/ipn )
But in comparison from other PayPal IPN messages to my site it does appear as though that message is missing information. For example other PayPal IPN messages are similar to this:
/transactions/?r_id=893-58c3289ebe6f9&type=paypal&id=29578&event_id=893&attendee_action=post_payment&form_action=payment
Is this a PayPal issue?
|
|
Mutiara Hobbs
|
March 13, 2017 at 9:29 am
I should note that the unsuccessful message was for a registration of two attendees to the same event.
|
|
Mutiara Hobbs
|
March 13, 2017 at 9:38 am
So I tried creating a URL based on the missing parameters to see if EE would update the attendee, and it did except that the payment status was still marked as incomplete. So it looks like PayPal’s IPN isn’t sending all the information EE needs to properly update some registrations. The real question is why does PayPal send all the info sometimes and only the registration id other times?
http://thepaintfactorymn.com/transactions/?r_id=896-58c2b2c90ad92&type=paypal&id=29570&event_id=896&attendee_action=post_payment&form_action=payment
|
|
Tony
|
March 13, 2017 at 9:54 am
Hi there,
This does appear to be an issue with PayPal and apparently is only happening on some of PayPal’s servers and not others (which is why some payments work and others fail), there is a related stackoverflow thread highlighting this same issue here:
http://stackoverflow.com/questions/42669566/querystring-values-removed-from-the-ipn-endpoint-by-paypal
The solution posted there is to urlencode the notify_url before sending it over to PayPal which we can certainly test out.
I’ve created a ticket to investigate this further but if you’d like to test the above yourself in the mean time I can provide further details?
|
|
Tony
|
March 13, 2017 at 10:18 am
Actually, on testing this if we encode the notify_url it completely breaks the IPN’s so that will not work.
|
|
Mutiara Hobbs
|
March 13, 2017 at 12:40 pm
Thanks for the help in figuring this issue out everyone. It certainly looks like the ball is in PayPal’s court at this point since the IPN message is getting truncated by their servers. It’s also nice to know other people are experiencing this issue outside EE.
I’m going to reach out to PayPal and see what they have to say about this issue.
|
