Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Aug 2007
    Posts
    24
    Plugin Contributions
    0

    Default Paypal problem retrieving transaction details after changing servers

    Hi,

    I recently moved my shop to a new server and I'm now experiencing some errors in Admin, hope you can help.
    ZenCart version 1.3.8a
    PHP version 5.2.8
    MySQL version 5.0.67 (old server was MySQL 4.x.x)

    I get the error message "There was a problem retrieving transaction details." when I follow this workflow:
    'Admin' -> 'Customers' -> 'Orders'
    Click 'Edit' on an individual order eg. to update status
    Click 'Back' to return to Orders list, error message appears.

    There are 2 log files created:

    [FONT="Courier New"]2009-03-26 01:35:20
    -------------------
    (live transaction) --> https://payflowpro.verisign.com/transaction
    Request Headers:
    Array
    (
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 45
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - Payflow Pro
    [4] => X-VPS-VIT-Integration-Version: 1.3.8a
    )


    Request Parameters: {GetTransactionDetails}
    Array
    (
    [ORIGID] => ETJP3CA64308
    [TENDER] => C
    [TRXTYPE] => I
    [VERBOSITY] => MEDIUM
    [REQUEST_ID] => 1238070919
    [USER] => *********
    [PWD] => **********
    [PARTNER] => ********
    [VENDOR] => *******
    )


    Response:
    Array
    (
    [RESULT] => 0
    [PNREF] => EREP3CD189DA
    [TRANSSTATE] => 8
    [ORIGRESULT] => 0
    [ORIGPNREF] => ETJP3CA64308
    [RESPMSG] => Approved
    [AUTHCODE] => 111111
    [AVSADDR] => Y
    [AVSZIP] => Y
    [CVV2MATCH] => Y
    [CORRELATIONID] => 130f8b44d7982
    [PROCAVS] => F
    [PROCCVV2] => M
    [SETTLE_DATE] => 2009-03-26 04:39:28
    [IAVS] => Y
    [REQUEST_ID] => 1238070919
    [CURL_ERRORS] =>
    )


    GetTransactionDetails, Elapsed: 858ms -- Succeeded
    [/FONT]
    ....and....

    [FONT="Courier New"]2009-03-26 01:35:20
    -------------------
    (live transaction) --> https://payflowpro.verisign.com/transaction
    Request Headers:
    Array
    (
    [0] => Content-Type: text/namevalue
    [1] => X-VPS-Timeout: 45
    [2] => X-VPS-VIT-Client-Type: PHP/cURL
    [3] => X-VPS-VIT-Integration-Product: PHP::Zen Cart - Payflow Pro
    [4] => X-VPS-VIT-Integration-Version: 1.3.8a
    )


    Request Parameters: {GetTransactionDetails}
    Array
    (
    [ORIGID] => ETJP3CA64308
    [TENDER] => C
    [TRXTYPE] => I
    [VERBOSITY] => MEDIUM
    [REQUEST_ID] => 1238070919
    [USER] => *********
    [PWD] => **********
    [PARTNER] => ********
    [VENDOR] => *********
    )


    Response:
    Array
    (
    [] =>
    [DUPLICATE] => 1
    [REQUEST_ID] => 1238070919
    [CURL_ERRORS] =>
    )


    GetTransactionDetails, Elapsed: 1314ms -- Failed[/FONT]


    So it seems to be a duplicate REQUEST_ID. I've checked PayPal and Zencart transaction information and I am not receiving duplicate orders. I know this is a similar problem that others have posted about but no posts matched my experience exactly. Any suggestions?

    Many thanks
    zzfozz

  2. #2
    Join Date
    Jan 2004
    Posts
    60,406
    Blog Entries
    4
    Plugin Contributions
    144

    Default Re: Paypal problem retrieving transaction details

    When you open the order page for a PayPal transaction, your store tries to talk to the PayPal server to get the details of the transaction for the order you're viewing.
    The messages you're seeing have nothing to do with creating duplicate orders whatsoever. It appears as though you're asking for info on the same transaction twice in a short period of time. It's certainly no indication of anything wrong with customers' ability to create new orders and payments.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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
    Aug 2007
    Posts
    24
    Plugin Contributions
    0

    Default Re: Paypal problem retrieving transaction details

    Thanks Dr. Byte, it's reassuring to know that you think it's an admin only problem. Any idea why it has only started happening since my server migration?

    The migration step were:
    1. Backup zencart db to local PC.
    2. Backup zencart filesystem to local PC.
    3. Request server upgrade from host.
    4. Host moves filesystem but NOT db.
    5. I import db backup to new db.
    6. Amend configure.php in /includes and /admin/includes
    7. Run fix_cache_key.php

    And apart from this confusing Error message everything is working fine.

    Thanks again.
    zzfozz

  4. #4
    Join Date
    Jan 2004
    Posts
    60,406
    Blog Entries
    4
    Plugin Contributions
    144

    Default Re: Paypal problem retrieving transaction details

    I'm puzzled as to the cause of the symptoms. The migration process you mention appears logical.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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
    Aug 2007
    Posts
    24
    Plugin Contributions
    0

    Default Re: Paypal problem retrieving transaction details after changing servers

    Do you think it could have anything to do with character set translations? To migrated the db I followed these steps:

    1. I exported the old db from my Linux server using phpMyAdmin as a zip file
    2. Unzipped it on my Windows Vista laptop
    3. Editted it to remove the CREATE DATABASE and USE statements
    4. Re-zipped as a GZIP file with a UTF-8 character set using 7zip
    5. Imported it to my new db using phpMyAdmin.

    Could I have introduced any rogue characters that may have upset things with this process?

    Thanks again.
    zzfozz

  6. #6
    Join Date
    Jan 2004
    Posts
    60,406
    Blog Entries
    4
    Plugin Contributions
    144

    Default Re: Paypal problem retrieving transaction details after changing servers

    I suppose that's a minor possibility, although I'm hesitant to connect the two matters.


    You could avoid the whole character-set translation issue by not editing the exported file at all, and instead generating the export correctly in the first place ... ie: by selecting your database before doing the export, thereby avoiding the insertion of the CREATE DATABASE and USE statements, as documented here:
    http://tutorials.zen-cart.com/index.php?article=103

    Related FAQ on moving between servers: http://tutorials.zen-cart.com/index.php?article=100
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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
    Aug 2007
    Posts
    24
    Plugin Contributions
    0

    Default Re: Paypal problem retrieving transaction details after changing servers

    Agreed, I think my character set idea is a red herring. On further investigation I can better describe when the error occurs. It only happens when I click on the green 'e' Action within the Order row. It does NOT happen if I click anywhere else on the row (to select that row) and use the 'Edit' button in the Right-Hand sidebar (see attached image)

    Does that shed any more light on it?

    Thanks again
    Attached Images Attached Images  
    zzfozz

  8. #8
    Join Date
    Jan 2004
    Posts
    60,406
    Blog Entries
    4
    Plugin Contributions
    144

    Default Re: Paypal problem retrieving transaction details after changing servers

    It doesn't explain the "why", but I'm glad to know you have a usable workaround.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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.



  9. #9
    Join Date
    Aug 2007
    Posts
    24
    Plugin Contributions
    0

    Default Re: Paypal problem retrieving transaction details after changing servers

    Yes. Thanks for taking the time to answer my questions. If I ever get to the bottom of it I'll be sure to update this thread.
    zzfozz

  10. #10
    Join Date
    Jan 2009
    Posts
    2,124
    Plugin Contributions
    0

    Default Re: Paypal problem retrieving transaction details after changing servers

    I've only just started getting this exact same error on all of my three stores. I click in to edit an order, update status and then go back. At the top of the screen next to a yellow triangle with exclaimation mark I get:

    There was a problem retrieving transaction details. ()

    Unlike the OP, I have not changed anything. It was working perfectly and then suddenly just started happening for no apparent reason.

    Any ideas why, anyone?

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Paypal Orders Not Completing w/ IPN after changing servers
    By wired2work in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 8 Oct 2008, 06:34 AM
  2. PayPal transaction details grey box not displaying on admin orders pages
    By Woodymon in forum PayPal Express Checkout support
    Replies: 5
    Last Post: 16 Oct 2007, 10:54 PM
  3. Problem changing servers!
    By coldasice1234 in forum General Questions
    Replies: 1
    Last Post: 16 Oct 2007, 03:49 PM
  4. PayPal IPN Security Measure problem after switching servers
    By Gloria in forum Addon Payment Modules
    Replies: 3
    Last Post: 2 Mar 2007, 04:25 PM
  5. Transaction Details
    By weaver in forum General Questions
    Replies: 0
    Last Post: 15 May 2006, 10:15 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
  •