PayPal transaction data missing suddenly

[split63]

Dr Byte.

We have had FEC and Super Orders installed for about two years.
However, we recently updated the site from 1.3.9d to e, to f, to g, and now we are at 1.3.9h.
Perhaps its something in one of these updates that is incompatible with the previous installs of FEC and SO?
I checked the recent log files and there is nothing of interest.

Also, I would expect a hard failure. The problem with the interaction/update theory is that half the time the transaction work and half the time they do not. And they begin working spontaneously.
Also, customers are not complaining.....and customers always complain. If they were seeing something as they finished the checkout they would surely email us.

[DrByte]

Tracking down intermittent issues is always challenging. But the key is in determining what is unique to the group that work fine vs the group that don't. Lots of possibilities there. Plenty of things for you to investigate.

[split63]

Dr Byte,

I have been looking for a pattern; Time of the day, international or domestic, order size and/or order amount. I see no pattern. Its been down for hours and only moments ago started working. Its maddening.
I could insert debug statements into key files to try to determine how far the transactions are getting in the Zen files. Which files should I look at and what are the key insertion points that such statements would be telling?

[DrByte]

Its been down for hours and only moments ago started working.

Huh? "down for hours"?
This is the first that you've said your site has been down.
I must be missing something.

[split63]

By down I mean that the transaction data is missing on all transaction during this period.
Poor choice of words

[DrByte]

http://www.zen-cart.com/showthread.p...Logging-PayPal

[split63]

Thanks for the link. I turned the logging on and waited to capture both a good and bad transaction. Where bad is one which is missing transaction data on the order page. Looking through the logs, I see that the data that is missing on the order page is in the logs. The area of the logs were I noticed a problem is the sixth line below extracted from the bottom of the ipn_xxxx.log:

The error is: "Could not find matched txn_id record in DB. Therefore is new to us. "
This line, which is inserted between breakpoint 3 &4 is not present on a "good" transaction.

Aug 04 2012 11:01 -- CURL response: VERIFIED
Aug 04 2012 11:01 -- IPN INFO (cl) - Confirmation/Validation response VERIFIED
Aug 04 2012 11:01 -- Breakpoint: 1 - Collected data from PayPal notification
Aug 04 2012 11:01 -- Breakpoint: 2 - Validated transaction components
Aug 04 2012 11:01 -- Breakpoint: 3 - Communication method verified
Aug 04 2012 11:01 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.
Aug 04 2012 11:01 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

[DrByte]

If you're using Express Checkout, then the IPN logs will only reflect symptoms, not actual causes, because the IPNs which are sent for Express Checkout transactions are expected to find the completed transaction in your store in order to match up. The stuff you quoted simply confirms that the EC module wasn't able to complete the required tasks once the customer was done confirming payment at PayPal. You still need to track down what's different in your store vs all the other stores which work fine including those installed fresh with no customizations.

[split63]

For each transaction there are 5 log files;
2 - PayPal_Curl_xxxx.log
2 - paypalwpp_Paypal_Action_xxxx.log
1 - ipn_xxx.log

Which of these would you think would be the one to focus on?

Also, once I got the logs, I turned off logging. Oddly enough the PayPal_Curl_xxxx.logs keep coming. They seem to be stuck on. THe other logs stopped.

[split63]

I also compared the full install of 1.3.9h(source) to my site with winmerge.
I found files on my site which are not in the source....these all related to file copies, and to previously installed FEC and super order files.
The only file missing that was in the source and not on my site was

includes\modules\pages\tell_a_friend\header_php.php

Perhaps I missed it in the change list or maybe it was missing. Regardless, my site does not use the tell_a_friend feature.

I doubt if Super Orders is to blame here since it is an admin plug in and not used during transactions..
However, perhaps FEC is to blame? It is certainly involved in the check out process....though I'm not clear that it has anything to do with PayPal data. THe thought is that FEC worked fine with 1.3.9d, but with all the changes from d to h, maybe FEC is having a strange interactions. Again, nothing makes sense since it works fine about 60% of the time.