Paypal IPN orders not being relayed to cart or emailed to owner or buyer

Ajeh:

Go to the Tools ... Install SQL Patches ... and run these:

ALTER TABLE paypal CHANGE txn_type txn_type varchar(32) NOT NULL default '';
ALTER TABLE paypal CHANGE payment_type payment_type varchar(40) NOT NULL default '';
ALTER TABLE paypal_testing CHANGE txn_type txn_type varchar(32) NOT NULL default '';
ALTER TABLE paypal_testing CHANGE payment_type payment_type varchar(40) NOT NULL default '';

Is that for me, or everyone having this problem?

Anyone using PayPal that is experiencing a problem ...

Ajeh,

I will try that patch to see if it helps. I just had another weird thing happen which may or may not be related, but I'm recording it here in case anyone else experiences the same thing.

A paypal customer just wrote me asking where his merchandise was. He emailed me a copy of the invoice, and the Order Number was for an order that happened MONTHS ago (early September) for a completely different customer, with completely different merchandise.

However, I do see a paypal deposit from him in our account on the day in question (December 31st).

My first thought is that I am being scammed, with someone spoofing our emails to look like they ordered something, especially since they have no customer account, and the invoice he provided is not even close to being accurate. But there is money deposited into our account from him for the amount of the item he wants.

Still no fix but i did download that paypal stuck veiwer mod. and read the readme file > $Id: view_stuck_paypal_orders.php, v 1.0 2005/04/25 DrByte $

Sometimes paypal orders don't get returned by paypal's IPN feature reliably.
Yet, Zen Cart stores the information on these orders while waiting for confirmation from PayPal.
If PayPal never returns an IPN confirmation successfully, these orders sit in Zen Cart's database
waiting... and waiting...

The good news is that it's still in the database.

As such, the enclosed viewer will display the contents of the order information so that you can
still process the customer's order.

The display of information is rather cryptic, but after looking at it for a bit, you'll find
that all the information you need is usually right there.

Anyway installed this and sure enough the information came up when i ran the mod in admin. still cant see what the customer order but there is alot more detail than, that of what paypal sent. So from reading that and running the mod i am guessing paypal or ZenCart is stuck at some point . i hope this help someone figure out what the problem is .....

Yes, this is an ongoing thing. Happened twice yesterday. Incidentally, both paypal orders were eChecks. I had to contact the customer and ask what they bought, and then manually create the order for them. It's becoming a real nightmare because we are starting to miss orders.

We are not running the PayPal Express module, otherwise I would think that had something to do with it.

Did you add this patch yet to your site?

http://www.zen-cart.com/forum/showthread.php?t=56216

Note: there are a couple of files shared ... so update all your files with that patch file ...

Ajeh:

Did you add this patch yet to your site?

http://www.zen-cart.com/forum/showthread.php?t=56216

I wasn't using the PayPal Express module....that is why I was wondering if this weird behavior was due to this NOT being enabled or something weird like that.

No, but due to shared files I'd say load the patch to see if this helps the problem you are having ... at least then the code is on the same page ... :smile:

I'm also having PayPal problems since upgrading from 1.3.5 to 1.3.7. I've tried the suggested patch and Ajeh's SQL code, but to no avail. Order confirmations aren't going through to either the customer or the seller.

I'm confused as to why, since it was working fine before I upgraded this afternoon. I've uninstalled the PayPal module and re-installed it, but still no joy.
Any help would be greatly appreciated.

Sorry for the double post, but I thought I'd better let you know that the site in question is www.beebasic.co.uk. I also am getting from time to time the warning "CURL functions not found - required for Linkpoint API payment module" at the top of the Admin screen, although I haven't got the Linkpoint module installed.

Hi
I have a new install 1.3.7, set all the setting as per this whole thread, i get redirected back, but no info is passed, and nothing in admin

temp url is https://www.realraptors.co.uk/synergy/

If i go to http://www.realraptors.co.uk/synergy/ipn_main_handler.php the page just hangs but no errors

what do i do? i would like to go live with the updated site

Andy

Sorry to miss lead, my version is 1.3.6

Andy

ipn dubugging, gave only this

IPN NOTICE::Got past language loads

no other text

Andy

just got these, all on seperate emails

IPN NOTICE::Got past language loads

IPN FATAL ERROR::Could not find stored session in DB, cannot re-create session

IPN FATAL ERROR::No saved session data available

IPN FATAL ERROR::No POST data available

IPN FATAL ERROR::Transaction did not validate

IPN WARNING::Transaction was not marked as VERIFIED. IPN Info = ,,,,,,,,,,,,,,

what have i missed? the account im testing with is verified

Andy

Can you zip up the log files in the /includes/modules/payment/paypal/logs folder (with a password on the zip), and post the zip here?
PM me with the password to the zip file so I can review it.

Note: you'll need to make that folder "read-write" ... ie: permissions of 777 ... or else the log files won't be saved.

To DrByte

PM Sent

Andy

andy:

IPN WARNING::Transaction was not marked as VERIFIED. IPN Info = ,,,,,,,,,,,,,,

"IPN Info = ,,,,,,,,,,,,,," ... is this literally what it says, or did you simply use the commas to remove potentially sensitive data from public posting?

I've never seen it only show a batch of commas like that ;)

Hi
As i posted it, was how it was in the emails

Andy

I don't know if this is any help, but the latest customer of ours has this happen with EVERY ORDER, where we get his PayPal deposit and nothing gets relayed to ZenCart......and he is paying with an ECHECK, so his status on paypal shows up as "uncleared."