Post by MikeSCC » Thu Mar 14, 2013 1:21 am

Hello,

Urgent help on this would be very much appreciated! I am getting the following errors in my OC error log when the customer is trying to place an order using the PayPal Pro payment method:

2013-03-13 14:27:41 - PHP Warning: curl_error(): 118 is not a valid cURL handle resource in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 167
2013-03-13 14:27:41 - PHP Warning: curl_errno(): 118 is not a valid cURL handle resource in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 167
2013-03-13 14:27:41 - DoDirectPayment failed: ()

Also received curl_error numbers '120', '125' and '130' (on different orders). The code in the 'pp_pro.php' file is as follows:

Code: Select all

if (!$response) {
$this->log->write('DoDirectPayment failed: ' . curl_error($curl) . '(' . curl_errno($curl) . ')');
}
When the customer clicks confirm the page hangs on 'Processing' and ends up timing out (I have 'Error: MySQL server has gone away' errors in log reflect this). The orders do not go through. Basically it appears the customers' payment information is not reaching PayPal. I have tried placing an order using wrong card information and the same happens - which leads me to believe the data is not reaching PayPal

I have no idea what is causing this - I've spoken to my provider and they say the SSL set up is fine and nothing has changed on their end (thought it might be this due to this thread: http://forum.opencart.com/viewtopic.php?t=10340). They also say API should still work.

I cannot speak to PayPal until tomorrow as I'm not the account holder.

My API settings are definitely correct in the PayPal Pro module settings (I have also checked in the PayPal account that no settings have changed). I have also not changed any OC files.

This has only happened within the last 24 hours before which orders were coming through normally, I just have no idea what is causing it.

Any help would be greatly appreciated, thanks in advance.

Mike

Active Member

Posts

Joined
Tue Nov 20, 2012 5:55 pm

Post by MikeSCC » Thu Mar 14, 2013 9:49 pm

Any help on this would be very much appreciated.

Thanks

Active Member

Posts

Joined
Tue Nov 20, 2012 5:55 pm

Post by straightlight » Fri Mar 15, 2013 11:15 am

On the error log output file from your system/logs folder or from your admin - > settings - > error logs page, can you track that / those line(s) and paste what is the actual sentence of the posted code you showed on your first post ? Only then would be possible knowing what might be the cause of this problem.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by MikeSCC » Fri Mar 15, 2013 5:21 pm

Thanks for your reply.

I have now got the cURL error code to appear in the logs. The complete set of error logs show:

Code: Select all

2013-03-15 9:06:21 - PayPal Pro DoDirectPayment CURL ERROR: 28::connect() timed out!
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  ACK in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 188
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  ACK in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 188
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  L_ERRORCODE0 in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 306
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  L_LONGMESSAGE0 in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 306
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  ACK in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 307
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  L_ERRORCODE0 in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 307
2013-03-15 9:06:21 - PHP Notice:  Undefined index:  L_LONGMESSAGE0 in /homepages/33/.../htdocs/.../catalog/controller/payment/pp_pro.php on line 307
2013-03-15 9:06:21 - PayPal Pro - Payment . Error Code 
I think it is timing out becuase it is not getting a response from PayPal. That explains the 'ACK', 'L_ERRORCODE0' and 'L_LONGMESSAGE0' errors because it normally would retrieve these from PayPal. The code for the cURL error now looks like:

Code: Select all

if (!$response) {
			$json['error'] = 'CURL ERROR: ' . curl_errno($curl) . '::' . curl_error($curl);
			$this->log->write('PayPal Pro DoDirectPayment CURL ERROR: ' . curl_errno($curl) . '::' . curl_error($curl));
		}
What I don't know is why the payment details aren't reaching PayPal, or if there is something blocking it on PayPal's end. It it was on PayPal's end I would expect an error code to show - but there is nothing. Even trying to checkout using duff credit card information brings up the same errors as above. I'm in the process of speaking to PayPal (not the account holder so am being set up) but I'm worried that when I do speak to them they'll simply say they are not receiving the information and there is nothing wrong in their end.

Thanks,

Mike

Active Member

Posts

Joined
Tue Nov 20, 2012 5:55 pm

Post by MikeSCC » Fri Mar 15, 2013 7:58 pm

Update: I have done a fresh install of Opencart on the same server (v. 1.5.4) and installed the PayPal Pro payment module. I've activated it in test mode and input my sandbox API details. The same issue is occuring when I try to buy something using this payment method - this leads me to believe it must be something on the server?

Active Member

Posts

Joined
Tue Nov 20, 2012 5:55 pm

Post by Qphoria » Fri Mar 15, 2013 9:27 pm

Yes it does appear to be server related... but it is weird... From what I can tell, curl is assigning the resource correctly but a few steps later when it tries to reuse that resource handle, it is not found... as if the server closed the connection unexpectedly. Check with your host on this.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by straightlight » Fri Mar 15, 2013 10:34 pm

@MikeSCC:
$json['error'] = 'CURL ERROR: ' . curl_errno($curl) . '::' . curl_error($curl);
This line from JSON response outputs the CURL error number and the text line on the OpenCart error line template. On your next tryout, would it be possible to post that error line number and text you're receiving ? This would explain the reason on why CURL would successfully initialize but seem to fail on returning the results to the object in return.

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by MikeSCC » Sat Mar 16, 2013 12:44 am

@straightlight

I included this line in my second post:

Code: Select all

2013-03-15 9:06:21 - PayPal Pro DoDirectPayment CURL ERROR: 28::connect() timed out!
However, I now know the cause of this issue. After I tested with a fresh install I went back to my host and they gave me a fresh update. It turns out that between PayPal and AT&T they have blocked the 1&1 IP address, stopping any payments being made. Apparently there are other people affected - still waiting for a fix.

Thanks for your help - thanks also @Qphoria.

Active Member

Posts

Joined
Tue Nov 20, 2012 5:55 pm

Post by jeremy10 » Thu Mar 21, 2013 5:22 am

MikeSCC wrote:@straightlight

I included this line in my second post:

Code: Select all

2013-03-15 9:06:21 - PayPal Pro DoDirectPayment CURL ERROR: 28::connect() timed out!
However, I now know the cause of this issue. After I tested with a fresh install I went back to my host and they gave me a fresh update. It turns out that between PayPal and AT&T they have blocked the 1&1 IP address, stopping any payments being made. Apparently there are other people affected - still waiting for a fix.

Thanks for your help - thanks also @Qphoria.
Yep, I got the same error message, checked with my host and they told me the same thing about AT&T blocking certian webservers.

Newbie

Posts

Joined
Thu Mar 21, 2013 5:19 am

Post by MikeSCC » Fri Mar 22, 2013 6:28 pm

It looks as if this was fixed at some point on Saturday (16th March).

Active Member

Posts

Joined
Tue Nov 20, 2012 5:55 pm

Post by ralphstirrat » Tue May 14, 2013 7:31 pm

Hi I'm still having problems with this, what was the fix?

http://colbrook.co.uk


Active Member

Posts

Joined
Wed Aug 29, 2012 7:53 pm

Post by ralphstirrat » Tue May 14, 2013 10:32 pm

OK mine is now working OK, not sure why, maybe it was a cache error

http://colbrook.co.uk


Active Member

Posts

Joined
Wed Aug 29, 2012 7:53 pm
Who is online

Users browsing this forum: No registered users and 45 guests