Kryptronic Software Support Forum

Hi kaz.  I was on the box today and here's what I have to report:

I figured the best way to test this was to isolate whether the issue
was a server-related one, or specific to the software.  I started out
by installing a fresh copy of CCP5.1 in a directory named
/www/cgstore2.  I configured it to hook into your PayPal account and
implemented the debug code we were working on in the forum.  I placed
a test order and everything came through fine.  There were three calls
to the ste_order_conf_proc routine (as there should have been):

(1) IPN from PayPal, which deleted the cart file.

(2) Return redirect from PayPal which called ste_order_conf_proc and
saw no cart file existed so it did nothing except print the CCP
redirect page.

(3) Call from the redirect page which did nothing but print the order
confirm page.

The debug log reads as follows:

2005-07-25 10:43:27 - calling &ste_order_conf_sendemail_proc(,,) from ste_order_conf_proc
cart file 51G4620910.csv DOES NOT EXIST.
2005-07-25 10:45:25 - calling &ste_order_conf_sendemail_proc(,,) from ste_order_conf_proc
cart file 51G4620910.csv DOES NOT EXIST.
2005-07-25 10:45:25 - calling &ste_order_conf_sendemail_proc(,,) from ste_order_conf_proc
cart file 51G4620910.csv DOES NOT EXIST.

I appended that code to write to the debug file outside of the if cart
exists statement in that routine.  That shows me the cart was deleted
on the first hit.

I then tested on your live install.  Results were different.  Your
debug file indicated pretty much the same thing - but your debug
entries were inside the if statement and the unlink failed every time.

This indicates something in your install (possibly due to a mod or two
you implemented) is locking those ./data/temp/*.csv files and not
allowing them to be deleted.

Have you made any mods at all anywhere in the program that FLOCK one
of those files without unlocking it?  Is there a mod you have
installed that could be doing this?

This problem is specific to your codebase as the clean 5.1 install I
tested did not have the issue at all.  This is definitely a
software-based issue due to a modified package.

I'll update the forum with this info as well...

Hmm... I have no mods that FLOCK but I did get SEO installed this year.

Since the SEO does not deal with the cart files in any way, it is very hard to see how it could be related.

None of my modules lock any files, that I can say with certainty.

Besides codebase differences there are other potential differences between a fresh install and your install, most notably the presence of a lot more and different data (orders, etc) and different configuration settings.

I suggest a file ownership issue, that is to say that apache might be running as different user when the cart is created (non-ssl) then when the IPN notification comes in (ssl perhaps?). Just a guess. This could be addressed by changing the permissions that the cart files are created with. What ownership and permission do the cart files have when users are still shopping (before checkout and payment)?

Mark

I moved to MySQL two days ago and have not had a single duplicate (or triplicate) order confirmation email since.

My shippers are getting duplicates too - usually 2 but sometimes 3 - however the internal or customer emails are not duplicated! Really confused as to how to fix this...  :-( 

Performance cannot explain mine, I'm on a dedicated server and it happens even during the slow summer months when the server is 99% idle.

No, I was never able to resolve this.  I get three for every paypal order.