Support

Home Forums Event Espresso Premium Errors from IPN Validation

Errors from IPN Validation

Posted: July 17, 2014 at 9:36 am


Newton Zheng

July 17, 2014 at 9:36 am

I have problems with any payments via Paypal. If the event is free I have no issue. But once user pays via Payapl (the only method of payment) then they are returned to the site and the payment status reads incomplete.

I have gone through your forums and tried all the solutions below but still cannot get any transactions that use Paypal to read anything other than incomplete. Every transaction which is paid by Paypal is marked as “Payment Status: Incomplete” when the user is sent back to the site. BUT Paypal sends me an email showing that the payment was indeed successful.

I have tried the following solutions from your site:
1 – ensuring Paypal IPN is enabled and set to transactions page in Paypal
2 – transactions page is public, published, contains correct shortcode
3 – transactions page is using simplified txnpage.php as template
4 – cURL installed on server
5 – site is live, using live paypal
6 – logs folder in wp-content\uploads\espress\logs permission is set to ‘777’
7 – No VAT/Sales Tax in Paypal has been set

Looking in Paypal’s IPN history I see ALL transactions and each has the 200 code so no issue with any blocking of IP or firewall. I can see the transaction does occur and is sent back to transactions page and logs in Event Espresso confirm this in both the ‘espresso_log.txt’ and ‘paypal.ipn_results.log’.

Here is what my log shows:
===================================
[07/17/2014 5:23 PM] – Errors from IPN Validation:

Using BUILT-IN PHP curl methods
key = mc_gross
value = 1.00
key = protection_eligibility
value = Ineligible
key = item_number1
value =
key = payer_id
value = 57EAC7TAD49XW
key = tax
value = 0.00
key = payment_date
value = 02:27:50 Jul 17, 2014 PDT
key = payment_status
value = Completed
key = charset
value = gb2312
key = mc_shipping
value = 0.00
key = mc_handling
value = 0.00
key = first_name
value = Doris
key = mc_fee
value = 0.54
key = notify_version
value = 3.8
key = custom
value =
key = payer_status
value = verified
key = business
value = diane@bych.sg
key = num_cart_items
value = 1
key = mc_handling1
value = 0.00
key = verify_sign
value = As-f21gcr6j05zMb4a6X6TGMPqXrAeLAlS7W4l48BrYi4iYpYTceGcG.
key = payer_email
value = newton@ccg.sg
key = mc_shipping1
value = 0.00
key = tax1
value = 0.00
key = txn_id
value = 7KE40642GL350651B
key = payment_type
value = instant
key = last_name
value = Chai
key = item_name1
value = Member Pricing for Cardio Test Class. Attendee: Newton Zheng
key = receiver_email
value = diane@bych.sg
key = payment_fee
value =
key = quantity1
value = 1
key = receiver_id
value = QU8D4PGQ2DMCA
key = txn_type
value = cart
key = mc_gross_1
value = 1.00
key = mc_currency
value = SGD
key = residence_country
value = SG
key = transaction_subject
value =
key = payment_gross
value =
key = ipn_track_id
value = 8d4aa6b142d16
Success Setting host: https://www.paypal.com/cgi-bin/webscr
Success Setting request type to post
Success Setting post fields: mc_gross=1.00&protection_eligibility=Ineligible&item_number1=&payer_id=57EAC7TAD49XW&tax=0.00&payment_date=02%3A27%3A50+Jul+17%2C+2014+PDT&payment_status=Completed&charset=gb2312&mc_shipping=0.00&mc_handling=0.00&first_name=Doris&mc_fee=0.54&notify_version=3.8&custom=&payer_status=verified&business=diane%40bych.sg&num_cart_items=1&mc_handling1=0.00&verify_sign=As-f21gcr6j05zMb4a6X6TGMPqXrAeLAlS7W4l48BrYi4iYpYTceGcG.&payer_email=newton%40ccg.sg&mc_shipping1=0.00&tax1=0.00&txn_id=7KE40642GL350651B&payment_type=instant&last_name=Chai&item_name1=Member+Pricing+for+Cardio+Test+Class.+Attendee%3A+Newton+Zheng&receiver_email=diane%40bych.sg&payment_fee=&quantity1=1&receiver_id=QU8D4PGQ2DMCA&txn_type=cart&mc_gross_1=1.00&mc_currency=SGD&residence_country=SG&transaction_subject=&payment_gross=&ipn_track_id=8d4aa6b142d16&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: Protocol https not supported or disabled in libcurl[07/17/2014 5:23 PM] – FAIL: IPN Validation Failed . /cgi-bin/webscr : http://www.paypal.com
IPN POST Vars from gateway:
mc_gross=1.00, protection_eligibility=Ineligible, item_number1=, payer_id=57EAC7TAD49XW, tax=0.00, payment_date=02:27:50 Jul 17, 2014 PDT, payment_status=Completed, charset=gb2312, mc_shipping=0.00, mc_handling=0.00, first_name=Doris, mc_fee=0.54, notify_version=3.8, custom=, payer_status=verified, business=diane@bych.sg, num_cart_items=1, mc_handling1=0.00, verify_sign=As-f21gcr6j05zMb4a6X6TGMPqXrAeLAlS7W4l48BrYi4iYpYTceGcG., payer_email=newton@ccg.sg, mc_shipping1=0.00, tax1=0.00, txn_id=7KE40642GL350651B, payment_type=instant, last_name=Chai, item_name1=Member Pricing for Cardio Test Class. Attendee: Newton Zheng, receiver_email=diane@bych.sg, payment_fee=, quantity1=1, receiver_id=QU8D4PGQ2DMCA, txn_type=cart, mc_gross_1=1.00, mc_currency=SGD, residence_country=SG, transaction_subject=, payment_gross=, ipn_track_id=8d4aa6b142d16,
IPN Response from gateway Server:
========================================

Any assistance would be greatly appreciated. Let me know if you need me to send you any further information or what I can do to resolve this. Thanks.


Tony

  • Support Staff

July 17, 2014 at 9:44 am

Hi,

Although the thank-you page shows as incomplete on that page does the registration show complete within the admin or does that still show incomplete also?


Newton Zheng

July 17, 2014 at 9:55 am

Hi Tony, no that shows incomplete as well. After refreshing the thank you page it still says incomplete and no emails are sent to either user or admin to inform them of any registration. I don’t believe this is a delayed IPN sending issue. Any other ideas? Thanks


Sidney Harrell

July 17, 2014 at 10:08 am

The error looks like it is here:

Protocol https not supported or disabled in libcurl


Newton Zheng

July 17, 2014 at 10:22 am

I saw that error and asked my hosting guy if cURL is installed and got the following response:

curl module is enabled in the server, see below snippet
==========
root@server [~]# php -m | grep curl
curl
root@server [~]#
==============

Then I asked if https could be enabled or was not supported and got the below response
=============
I could see there is no issue with the curl. SSL feature has been supported and the libcurl was built with it.
I have given below the snippet for your verification.Please check with script.
———
root@server [~]# curl-config –feature | grep SSL
SSL
———-

Does this help to get us any closer to a solution? Let me know. Thanks so much.


Sidney Harrell

July 17, 2014 at 10:48 am

Try something like this:

$version = curl_version();
$ssl_supported= ($version['features'] & CURL_VERSION_SSL);
var_dump($ssl_supported);
var_dump($version['ssl_version']);

and

$temp = stream_get_wrappers();
var_dump($temp);


Newton Zheng

July 17, 2014 at 10:50 am

Hi Sidney, Sorry, this could be a really stupid question but where do I try that? Thanks


Sidney Harrell

July 17, 2014 at 12:48 pm

You can use a custom function plugin as outlined here: http://youtu.be/pqe1RQ4peAM. You can put a

die();

statement in after the var_dumps, to end execution. Once you have the results, you can take the debug code back out, to put the site back to normal execution.


Newton Zheng

July 17, 2014 at 8:30 pm

My host did say because php 5.2 has been removed from EasyApache and depreciated by PHP for quite some time.

Only with the latest version we would be able to install curlSSL.
Please be informed that once you upgrade the php version some of the scripts might not work.

Does EE need curlSSL? Is this the same as cURL? Thanks


Newton Zheng

July 17, 2014 at 8:31 pm

Just to clarify, no SSL cert for this site.


Lorenzo Orlando Caum

  • Support Staff

July 18, 2014 at 11:14 am

Hi Newton,

Could you ask your webhost to update your website to PHP 5.3 or PHP 5.4?


Lorenzo


Newton Zheng

July 20, 2014 at 7:51 pm

Hi, my developer got the following results. Let me know if this helps at all below.

Lorenzo, we’re on PHP 5.2 will that not work? Let me know if can be resolved without upgrading php as old version has been deprecated and I’m not sure if other scripts in the server may be affected with an upgrade. Thanks.

site’s curl is not able to communicate with paypal to verify the payment response.

below is the curl dump the event espress asked for ….
[It is curl issue. We get response from curl
Results: Array
(
[version_number] => 464896
[age] => 3
[features] => 1545
[ssl_version_number] => 0
[version] => 7.24.0
[host] => i686-pc-linux-gnu
[ssl_version] =>
[libz_version] => 1.2.3
[protocols] => Array
(
[0] => dict
[1] => file
[2] => ftp
[3] => gopher
[4] => http
[5] => imap
[6] => pop3
[7] => rtsp
[8] => smtp
[9] => telnet
[10] => tftp
)
)

]


Josh

  • Support Staff

July 21, 2014 at 9:13 am

Hi Newton,

It turns out that PHP 5.2 itself was deprecated in 2010 and is no longer being supported by the folks that develop PHP. They recommend running a minimum of PHP 5.3 because using older versions “may expose you to security vulnerabilities and bugs that have been fixed in more recent versions of PHP“.

Along with updating to a newer version of PHP, the following stackexchange threads may help your host get this sorted out:

http://stackoverflow.com/questions/6884669/curl-1-protocol-https-not-supported-or-disabled-in-libcurl

http://stackoverflow.com/questions/22628097/curl-protocol-https-not-supported-or-disabled-in-libcurl-post-php-update

The support post ‘Errors from IPN Validation’ 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