No Order Payment Data Available

[lat9]

There's something weird going on with PayPal Express Checkout on a site that I've been asked to investigate. The site's paypalwpp.php and ipn_main_handler.php are unmodified from the Zen Cart v1.5.1 distribution.

Starting on 10-Dec, none of the transactions handled by paypalwpp have had their payment details updated:

PayPal debug is enabled (log-only) and nothing looks amiss in the CURL logs for the setExpressCheckout, getExpressCheckoutDetails and doExpressCheckout calls. The bottom of the ipn log for one of the transactions shows:

Dec 15 2015 12:47 -- CURL response: VERIFIED

Dec 15 2015 12:47 -- IPN INFO (cl) - Confirmation/Validation response VERIFIED

Dec 15 2015 12:47 -- Breakpoint: 1 - Collected data from PayPal notification

Dec 15 2015 12:47 -- Breakpoint: 2 - Validated transaction components

Dec 15 2015 12:47 -- Breakpoint: 3 - Communication method verified

Dec 15 2015 12:47 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us. 

Dec 15 2015 12:47 -- Breakpoint: 4 - Details:  txn_type=unique    ordersID = 0  IPN_id=0

   Relevant data from POST:
     txn_type = unique
     parent_txn_id = None
     txn_id = xxxxxxxxx

Dec 15 2015 12:47 -- Breakpoint: 5 - Transaction type (txn_type) = cart   [parentLookup=unique]

Dec 15 2015 12:47 -- Breakpoint: 5 - midstream checkpoint

Dec 15 2015 12:47 -- Breakpoint: 5 - Record does not need to be processed since it is not new and is not an update. See earlier notices. Processing aborted.

There are no myDEBUG logs generated around the time of the doExpressCheckout action.

The site is hosted on hostgator, running PHP 5.3.29 and MySQL 5.5.42-37.1 on a Linux host with a valid SSL cert from Comodo.

Has anyone else seen this before? It's like someone threw a switch on 10-Dec to cause these transactions to go "funny".

[DrByte]

Did someone change the PayPal credentials in the EC module? It uses those credentials to do the lookup for displaying that information on the admin order page, and if the credentials have changed (ie: to another account) since the order was placed then no data will show.

Also, when it does the lookup via the Admin, if logging is enabled then it will show a log for the GetTransactionDetails lookup request it makes to PayPal's servers.

[lat9]

No PayPal credentials have changed. I can make a payment via PayPal and then hop over to the admin and see the "no information". I'll check one of the getTransactionDetails logs to see what's up.

[DrByte]

I'll check one of the getTransactionDetails logs to see what's up.

You likely already realize this, but just in case: ... that'll probably be in one of the files with CURL in the filename.

[mc12345678]

Didn't put two and two together until DrByte commented on the CURL aspect. Almost two years ago I think it was, somewhere between the server and paypal some software/firewall upgrade prevented communication with paypal via curl and site had same result.

Confirm curl communication with paypal using the appropriate tester in the extras folder.

[DrByte]

Didn't put two and two together until DrByte commented on the CURL aspect. Almost two years ago I think it was, somewhere between the server and paypal some software/firewall upgrade prevented communication with paypal via curl and site had same result.

Confirm curl communication with paypal using the appropriate tester in the extras folder.

Well, lat9's getting paid transactions from the storefront, so we know that part of communications is fine ;)