Forums / PayPal Express Checkout support / PayPal transaction data missing suddenly

PayPal transaction data missing suddenly

Started by split63 on 27 Jul 2012, 10:21 PM · Views: 6,474

Results 21 to 38 of 38
5 Aug 2012, 1:42 PM
#21
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

PayPal transaction data missing suddenly

zip them and post the zip

Successful transactions will have 3 CURL logs and 2-5 paypalwpp logs and 1 ipn log

.
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 Aug 2012, 1:49 PM
#22
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

Each transaction is consistent, good or bad, there are always 5 log files as described above. Not sure what to make of this. I will post them for you shortly

5 Aug 2012, 5:42 PM
#23
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

The successful transactions will have 3 CURL files each. They have to. If they don't then that could be very revealing.

What exactly is unique about your store compared to the one I just installed from a fresh copy of original Zen Cart files? What would I have to do to make mine recreate how yours functions?

.
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 Aug 2012, 8:02 PM
#24
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

DrByte,

I sent you a PM.
Even though I have turned of logging in the PayPal module, the curl log files keep coming. How can I stop these log files?

5 Aug 2012, 9:07 PM
#25
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

Haven't seen the PM.

The log file thing might be related to an old bug.

.
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 Aug 2012, 9:29 PM
#26
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

DrByte,

I just checked and that PM is sitting in my sent box.
Old bug? What old bug? Is there no resolution?

5 Aug 2012, 9:47 PM
#27
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

Attach the file here, or post (or PM) a URL where I can grab the zip off your server.

Yes, an old bug. There's a fix. I don't remember where off the top of my head.

.
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 Aug 2012, 11:52 PM
#28
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

DrByte

I have sent you 3 PMs. They don't seem to be reaching you. PM me with your email address and I will send you the log files.

Thanks,

6 Aug 2012, 8:59 PM
#29
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

DrByte,

I went through previous orders to determine when this issue began. I had assumed it began when we upgraded beyond 1.3.9d. However, it began on 7/24/12 four days prior to the upgrades. I don't recall making any changes prior to 7/28/12. In fact, I did a search for any files which were modified from 7/1 through 7/27 and found none. Widening the search to include 7/28, I could see the files which were updated. This would tend to eliminate the theory that it was an issue between the older FEC and SO plugins and the new updates.
Also, we just had a flurry of orders which are missing the transaction data. Two customers ordered twice within minutes of each other. I contacted them and so far I got one response and that person claimed that during checkout he got some sort of email error, so he tried ordering again. He had no more details beyond that.

6 Aug 2012, 10:51 PM
#30
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

Email error.
Okay, then what are your email settings set to? Are you using SMTPAUTH? If not, why not? Find out from your hosting company whether there have been any reports of email handling issues in the same timeframe. Also ask whether your site is sending an abnormally large number of emails and is being prevented from sending emails for any reason. Find out whether their email server's spamtrapper or whatever is encountering any problems being handed to it from your website.

And again, are there any debug logs in the /cache/ folder? If not, are you sure the folder is writable so that if there ARE any errors they could even be logged? http://www.zen-cart.com/content.php?124-blank-page

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

6 Aug 2012, 11:33 PM
#31
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

We have made no store config changes. We are using PHP, not SMTPAUTH. The text next to this setting reads "Servers running on Windows and MacOS should change this setting to SMTP." We are on a linux server.

We have spoken to Godaddy (yes, damn Godaddy), they claim they see nothing unusual. However, they do claim that our hosting account affords 1000 sent emails each day. They also claim that we reach that limit early in the day. Yet, we estimate that we use less than 100 emails. Also, when I had them on the phone they claimed I had reached my limit...so as a test, I sent an email from our hosting account. It was received at a Gmail account with no issue. I'm not convinced they know what they are talking about....But I am convinced that there is some sort of email issue and somehow it appears tied to the missing transaction data. Then again, it could be that the transactions don't fully complete on the Zen side so an email is never sent.

Godadday claims they can offer no insight into the emails, their source, if they sent all at once or over time, and they claim they can not capture any of the emails. I have since escalated this potential issue with godaddy management.
It does make sense that it is a server issues since the site had not changed when the issue began.

I have those logs ziped and ready to send you. Please PM your email address.

7 Aug 2012, 12:40 AM
#32
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

Using SMTPAUTH sends your emails as authenticated messages, instead of as anonymous messages. It could be that you're hitting thresholds for anonymous messages. Or maybe that's not it at all.

But, sending emails as authenticated messages always gives you better performance as far as getting past spam filters is concerned, so is always a better choice.
(The only reason the help text mentions Windows/Mac is because on those platforms they MUST use smtp methods instead of bothering with a generic PHP choice.)

.
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 Aug 2012, 12:47 AM
#33
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

Is it simply a matter of changing that one parameter from PHP to smtpauth?

I sent you the log files.

This business of reaching the email limits....I not a believer. They claim that the limit is reset daily. Yet the transactions with missing data occur at any time of the day. For example, all transactions might be great until Noon, then for several hours all transactions will be missing data. But later in the evening, say 5 pm, it will start working again. We certainly have not had our limit reset by evening. Its so random. The missing data transaction can occur any time of the day and start working any time of the day

7 Aug 2012, 12:56 AM
#34
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

The log files reveal nothing other than that the activities sent to PayPal are working correctly.

So, it comes back to the operation on your site.
If emails are failing and causing a fatal error that aborts PHP execution, then anything after that email failure is not going to work, which could include any of the symptoms you've mentioned.
Or it could be custom code on your site. But unless someone has changed code in the window when this started happening, it's likely that it's something external ... which then brings us back to this email issue possibly.

.
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 Aug 2012, 1:05 AM
#35
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

Ok, I will continue to pursue the email possibility through Godaddy.
Thanks for looking through the logs.

7 Aug 2012, 6:08 PM
#36
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

DrByte,

Those Curl logs keep coming even though we have Debug set to off. I have tried turning it back on and then off again, but it had no effect.

13 Aug 2012, 3:57 PM
#37
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: PayPal transaction data missing suddenly

DrByte:

It has nothing to do with emails. But if you're hitting email thresholds then you might have other problems going on with rogue activity on your server. http://www.zen-cart.com/wiki/index.php/Recovering_From_Hacks

The problem appears to be that a forum on our site was being externally attacked. Each day hundreds of forum accounts were created. Each time an account was created an email was generated. This caused our site's allotted daily emails to be exhausted and/or the number that can be sent per hour to be exceeded. This would cause Zen to not be able to send php mail and this would prevent Zen from logging the transaction data. Since disabling the forum, our daily emails are very low and we have had not problems with Zen

13 Aug 2012, 5:15 PM
#38
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: PayPal transaction data missing suddenly

Thanks for the follow-up and for explaining where the source of the external problem was located.

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