Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default 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:
    Name:  no_order_data.jpg
Views: 398
Size:  19.9 KB
    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:
    Code:
    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".

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: No Order Payment Data Available

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

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: No Order Payment Data Available

    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.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: No Order Payment Data Available

    Quote Originally Posted by lat9 View Post
    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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: No Order Payment Data Available

    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: No Order Payment Data Available

    Quote Originally Posted by mc12345678 View Post
    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 ;)
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: No Order Payment Data Available

    Quote Originally Posted by DrByte View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: No Order Payment Data Available

    Turns out to have been a "simple" configuration issue. I'd noticed this (https://www.zen-cart.com/showthread....ssing-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?

 

 

Similar Threads

  1. v154 Is PayEezy Payment Module - (formerly First Data GGE4) Available?
    By cogitoergo in forum Addon Payment Modules
    Replies: 3
    Last Post: 20 Jul 2016, 11:04 PM
  2. v155 Data Available - Make stock available mod , does it exist ?
    By mesnitu in forum General Questions
    Replies: 3
    Last Post: 19 Jun 2016, 08:35 PM
  3. v151 losing some data of order in my custom payment module
    By dial in forum Addon Payment Modules
    Replies: 0
    Last Post: 20 Jul 2013, 11:44 AM
  4. No order data payment
    By dmagic in forum PayPal Express Checkout support
    Replies: 1
    Last Post: 21 Nov 2011, 06:25 AM
  5. cartID not set, is $order available in checkout-payment page?
    By jonasrullo in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 24 Jan 2010, 10:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR