No Order Payment Data Available

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".

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.

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.

lat9:

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.

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.

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.
Well, lat9's getting paid transactions from the storefront, so we know that part of communications is fine ;)

DrByte:

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

Come to think of it that's why I didn't post about it the first time I read the OP... Worked on one sde, but not the other. Ahh well... No, haven't seen this exact condition of paypal express funds collected but admin order info not displaying... Only seen full loss of CURL providing admin side result and when in test mode that unable to see past purchase PayPal details with no known attempts to make a purchase.

Turns out to have been a "simple" configuration issue. I'd noticed this (https://www.zen-cart.com/showthread.php?198554-PayPal-transaction-data-missing-suddenly) similar posting, where the issue appeared to be email-related and passed that link on to the shop-owner.

It turns out that he'd recently (like 09-Dec) changed his email password (the site's using smtpauth as the email method) everywhere but in the Zen Cart admin. That said, an order would get close to finished, attempt to send the email and go off to never-land and the final database update of the PayPal order would never get recorded.

I'll note here that the site uses authorizenet_sim as an alternate payment method and orders taken using that method (usually after the PayPal method failed) were completed with no issue.

Perhaps the process-flow taken by paypalwpp orders should be compared to the flow taken by the authorizenet_sim orders to prevent email issues from interfering with the proper order-recording in a future version?