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:

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

....and....

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

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

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.

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.

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

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.

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:
https://www.zen-cart.com/tutorials/index.php?article=103

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

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

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

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.

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?

That'll happen if your server can't talk to PayPal's servers. PayPal was having problems yesterday. Maybe that's why?
Details may show up in your PayPal log files if you've got them turned on.