Paypal IPN cart not emptying

**warrenthewindmill** · 11-04-2003, 09:28 PM

When I make a payment using paypal ipn everything works fine until I continue after the sale. The shopping cart still contains the item I just bought.
Any help please?

**warrenthewindmill** · 11-07-2003, 07:35 PM

still haven't managed to sort this. Even a possible direction would help. Could it be a cookie problem?

**michael_s** · 11-07-2003, 08:39 PM

Probably your IPN return url. Make sure that is correct.

**warrenthewindmill** · 11-13-2003, 07:49 AM

It seems to return ok to checkout_success.php but the item just purchased is staring right back at me from the cart.
This looks like the last problem before we go live...famous last words

**warrenthewindmill** · 11-15-2003, 05:40 AM

I've found further problems with Paypal IPN

All my orders are left at "PayPal Processing"
A TXN Id is not created
The shopping cart is not emptied
No email is sent to the customer from the store

The transactions ARE successful because Paypal emails both the store and the customer and debits and credits the right amounts. I have been trying to solve this for the last 2 days and having found this thread can see that someone with similar problems back in August did not appear to get an answer.
I assumed (always a mistake) that Paypal IPN would be a working contribution? If so what I am doing wrong? I have this one problem to solve to get a live site.
I have checked the addresses in osCommerce and in Paypal are set to paypal_notify.php and it seems to make no difference whether or not cURL is enabled.

If all else fails who would you recommend as a card processor, with an interface contribution that I can install?

Hoping someone can help please

**warrenthewindmill** · 11-15-2003, 08:48 AM

Could someone at least confirm this is a working contribution on a live site. At least I know then it is a problem with my install/configure/mistake and not a wider problem with the contribution?
Thanks

**warrenthewindmill** · 11-16-2003, 06:27 AM

A clue...anything appreciated. This thing is keeping me up at night

**michael_s** · 11-16-2003, 08:26 AM

warrenthewindmill, of course it is a working contribution. I have successfully tested it dozens of times. Tons of sites are using it without a problem. One clue - there is nobody responding to this thread. Usually that means 'it works for me.'

You have something screwy with your setup. That is what it has to be. Re-upload the IPN files. Have you made any other mods to the store? IPN hacks are in quite a few files. Perhaps you damaged one of the hacks inadvertantly.

**warrenthewindmill** · 11-16-2003, 10:53 PM

A thought. I don't think I have made changes to anything that would impact, although I can't be sure. Could it have anything to do with currencies? I'm a UK based store in £. Can't see why it would but I'll have a look later. then as you suggest I'll just do a reinstall of the files. Maybe look at the dates on the files first, if the same then I haven't amended them. If different it points me to the problem.
Either way you have sparked off new ideas for which I am grateful

**warrenthewindmill** · 11-17-2003, 10:44 AM

I've checked every file that either has paypal in the filename or in the content. The vast majority are dated 21st September and so I reckon haven't been changed.

The only ones with later dates are all from the english file and relate to shipping/delivery policies and are all text so I'm as sure as I can be that I haven't touched any of the files.

Then I tried setting the paypal IPN test mode to true and sending some test transactions. One by one it inserted the order numbers that had failed to send emails and recorded successful transactions.

Code:

TEST IPN Processed for order #103

I checked my emails and all the missing emails were arriving one after the other.

When all these transactions had been exhausted I was forced to enter item numbers to continues sending test IPN's.

Code:

You need to specify an order #Error&#58; no valid $paypal_response received.

I mistakenly entered the same item number twice and got the following error:

Code:

TEST IPN Processed for order #1061064 - You have an error in your SQL syntax near '' at line 1

delete from customers_basket where customers_id=

&#91;TEP STOP&#93;

and I now get this error every time I try and send a test IPN.
I've had a look at the database and there are now enties in the paypal_txn table with duplicate order numbers.

I feel sure that I haven't hacked about with the files. I decided when I started with MS2 Max that I wasn't going to do this to avoid just these sorts of problems. If so I must have some change to the config that has had an impact but I can't think what it might be.
Does any of this make sense and can anybody else reproduce these problems? The cart still does not empty by the way.