|
Susan
|
May 6, 2014 at 5:42 pm
I cannot get the payment status to complete. I have tested in sandbox and in live version mode. I have looked at other threads on the forum and I’m not sure how to resolve this. The PayPal accepts the payment and when you’re directed to the Thank You page the Payment Status is incomplete and the Transaction ID is 0.
The Error message from the paypal.pin_results.log shows this line:
Errors resulting from the execution of curl transfer: SSL certificate problem: unable to get local issuer certificate[05/06/2014 7:11 PM] – FAIL: IPN Validation Failed . /cgi-bin/webscr : http://www.sandbox.paypal.com
I’m not sure if this is a hosting server error?
If so how do we correct this?
Wordpress version: 3.9
Event Espresso version 3.1.36.5.P
Transaction Notification Page: – http://corvetteclubofontario.com/cco/transactions/
Registration page: http://corvetteclubofontario.com/cco/event-registration/?ee=1
I have Receive IPN messages (Enabled)
|
|
Lorenzo Orlando Caum
|
May 6, 2014 at 8:13 pm
Hi Susan,
I did some research on this issue and it can happen on Windows IIS based servers. Do you know if your site is running on a Windows server?
—
Lorenzo
|
|
Susan
|
May 7, 2014 at 8:48 am
Hi Lorenzo,
I checked with the hosting company and they informed me that their server runs on a hybrid platform which is Windows and Unix. The hosting company is called easyhosting.com. I showed them the log error message and they had no solution. Aside from moving to another hosting company is their a solution to this?
|
|
Tony
|
May 7, 2014 at 9:27 am
Hi Susan,
That error is likely caused by an issue with the servers CA file.
Your host should have fixed this for you. You could contact them once again requesting the check the server has a CA cert bundle installed, is configured correctly and has the correct permissions, or you can try installing one yourself.
Josh has previously posts some info on the HERE.
|
|
Susan
|
May 7, 2014 at 1:01 pm
Hi,
I followed the instructions from the Josh post. I installed the cacert.pem file myself and then the host company told my I had to create the php.ini file so that it can point to the location of the pem file.
I did another sandbox text and the SSL error message is gone but I still receive this error message according to the log:
Errors resulting from the execution of curl transfer: Connection timed out after 45001 milliseconds[05/07/2014 2:55 PM] – FAIL: IPN Validation Failed . /cgi-bin/webscr : http://www.sandbox.paypal.com.
Is this still a hosting issue?
|
|
Sidney Harrell
|
May 7, 2014 at 1:41 pm
It could be the host. We currently set the timeout on the cUrl transfer to 45 seconds in gateways/paypal/Paypal.php on line 89:
$error["set_timeout"] = curl_setopt($ch, CURLOPT_TIMEOUT, 45);
You could try changing that to 90, but it could be the host blocking outgoing connections from your server, in which case it would still timeout. One thing you might want to try, since most hosting company support staff will balk at helping you with something with a lot of moving parts, is to make a simple script to test whether the server’s curl functionality is working correctly. Copy the script found here into a file called test.php in your site’s web root directory. Then pull up yousite.com/test.php to check the results. If it fails, then the host’s support staff should have no problem helping you fix it, since they are not having to deal with a situation where the complications in the code could be the problem.
|
|
Susan
|
May 7, 2014 at 2:05 pm
Hi,
I did the test and it fails on every account. You can see below the first fail. Installing the cacert.pem doesn’t seem to have solved the problem after all.
SSL certificate problem: unable to get local issuer certificateArray
(
[url] => https://www.google.com/intl/en/contact/
[content_type] =>
[http_code] => 0
[header_size] => 0
[request_size] => 0
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.040471
[namelookup_time] => 0.001563
[connect_time] => 0.019197
[pretransfer_time] => 0
[size_upload] => 0
[size_download] => 0
[speed_download] => 0
[speed_upload] => 0
[download_content_length] => -1
[upload_content_length] => -1
[starttransfer_time] => 0
[redirect_time] => 0
[certinfo] => Array
(
)
[redirect_url] =>
)
The host company’s solution was to upgrade the account to an SSL manager which didn’t make sense so they were not helpful.
At this stage I’m going to suggest that we move the site to hostgator as I see it’s listed as one of the hosting companies that you recommend.
|
|
Lorenzo Orlando Caum
|
May 7, 2014 at 4:03 pm
Hi Susan,
Be sure to request an apache or nginx based server with your new web host.
—
Lorenzo
|
|
Susan
|
May 11, 2014 at 12:59 pm
Hi,
I just wanted to follow up.
We moved to Hostgator. Everything works fine in sandbox mode.
However, in live mode I was disappointed to find that the payment status shows Incomplete despite the fact that payment was received and confirmed, emails sent by paypal, etc. It shows a complete payment status in the backend. Only When you refresh the browser on the thank you page it updates the status to Completed.
Is there not a solution to this?
Is there any way to show a completed payment status upon payment?
For now I put a message on the thank you page that you refresh your browser.
|
|
Lorenzo Orlando Caum
|
May 11, 2014 at 4:19 pm
Hello,
What is your IPN url set to in your PayPal account?
Also, do you have auto return enabled?
—
Lorenzo
|
|
Susan
|
May 11, 2014 at 4:46 pm
Hi Lorenzo,
Currently the pin is set to this url: http://corvetteclubofontario.com/transactions/.
Currently Auto Return in Paypal is Off under the Website Payment Preferences.
Should it be set to On?
If so what should the return URL be?
Should I set it to this page in paypal: http://corvetteclubofontario.com/thank-you/
Will changing these settings display a completed payment status for the purchaser?
|
|
Lorenzo Orlando Caum
|
May 11, 2014 at 5:09 pm
The Auto return URL is optional.
Currently, if its off then a customer will need to manually click the link to return to your site. If you would like to turn it on, then set it to this URL:
http://corvetteclubofontario.com/thank-you/
—
Lorenzo
|
|
Susan
|
May 11, 2014 at 5:38 pm
Hi Lorenzo,
I set it to Auto return URL. That part works fine.
I still have to refresh the browser on the Thank you page to change the Incomplete to Completed payment status.
Is there anything else I can try to get this to show a completed payment status on the thank you page rather than having to manually refresh the browser each time?
|
|
Dean
|
May 12, 2014 at 1:38 am
Hi,
Have you tried the Simplified Transaction Page template?
https://eventespresso.com/wiki/how-to-set-up-paypal-ipn/#incomplete
|
|
Susan
|
May 12, 2014 at 1:07 pm
Hi Dean,
I just tried it now. As you can see this page has the stripped down template: http://corvetteclubofontario.com/transactions/.
I did a live test and it returns back incomplete. If I refresh the browser it appears as complete.
Any other suggestions?
|
|
Dean
|
May 13, 2014 at 9:24 am
Well, the only other option I can think of (barring using a different gateway) would be to try Sidney’s partial fix here: https://gist.github.com/sidharrell/7087307
What it does is check for any form of communication from PayPal and if it is not completed it will mark it as pending instead. It’s not much but could perhaps limit any issues.
|
