Paypal IPN, suddenly no more orders?

wygk:

This morning I was seeing the same problem as everyone else.

After reading your post just now, I ran a test and was successfully able to place an order. One data point, anyway!

We got a positive one too. Hopefully we're on the outset of this issue.

I just did a test order and it showed up in the cart now, and the order was successful =)

I still am having issues. Just tweaking some settings and going to run another test. This is very frustrating!

hello -- i am now getting positive orders however i am missing the paypal transaction details on the orders page. Please see images of before/after IPN bug.

Also, the redirect back to my shop is taking forever and is timing out ( a refresh gets me to the page after the time out)... how can i decrese the amount of time it takes to redirect... thanks

before IPN bug

after IPN bug fix

As of 01:10 (1:10AM) Mountain Time (3:10AM Eastern) I made a test payment through the Paypal IPN module using my personal Paypal account.
The transaction went through normally and the Payment Details section of the order details screen appeared normal with all necessary data.

I will next do the same test except make the payment using a VISA card through the Paypal IPN and post the results shortly.

Ron

ronlee67:

As of 01:10 (1:10AM) Mountain Time (3:10AM Eastern) I made a test payment through the Paypal IPN module using my personal Paypal account.
The transaction went through normally and the Payment Details section of the order details screen appeared normal with all necessary data.

I will next do the same test except make the payment using a VISA card through the Paypal IPN and post the results shortly.

Ron

As of 0120 (2:20AM) Mountain Time (3:20AM Eastern) I made a sucessful test payment through the Paypal IPN using a VISA card (bypassing the Paypal account login). The transaction went through normally and the Payment Details section of the order details screen appeared normal with all necessary data.

Ron

Ron
Are you saying that everything will be restored back to pre 10/14? or
How can I restore back to my site back to 10/13?
Jerry
https://www.glasseyesonline.com

:clap: YAY its working with me...

What did uyou do to have it restored?
Jerry

It is working for me on one site, but not another. I cannot figure out why. They share the same email address. I'm getting payments to one, but no record of orders or confirmation for the buyer.

I had orders go through just fine as of 5:28am EDT....but an order that was placed at 6:17am EDT did NOT go through. So I don't know if the problem has reappeared or not or if this other order is a separate issue.

I had the same problem and went crazy several days. No I solved. Iread all the threads on all the forum possible. Here my lesson learned.

Zencart 1.3.8a from the scratch
some addons but the did not created problems

once you confugured all PayPal profile correctly and the PayPal Zencart IPN modole too
Once you have test your communicatios with paypal servers with ipncheck and works correctly
once you are aware that your host company in not godaddy

take a look tou your PHP logs

if you find something similar

1292 Incorrect datetime value: '02:20:07 15 2009' for column 'payment_date'
at row 1
in:
[INSERT INTO sap_paypal (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, etc...

you catched the problem.

i founded it before http://www.zen-cart.com/forum/showthread.php?p=484125

but did not linked this solution to my problem.

you have to turn off "satic mode" in MySql

run sql query

SET @@global.sql_mode= '';

this was redundant - please ignore/delete

I am having the same issues as well. I read through the forum and it seems that it isn't quite fixed. Has anyone heard differently. I will also put the express checkout button on. Please keep us updated if anyone finds this stuff out. Thanks for everyone's hard work!!

Yea ! Mine is working fine, and I didn't have to do a thing.
Orders are coming in that are paid by Paypal. Keeping my fingers crossed.
Jerry

gothstone:

Paypal sessions viewer: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=84

[snip...] and rainbows fall from the sky.

Thanks for this -- that's exactly what I was looking for.

Worked like a charm. My database and paypal are reconciled now and I see the rainbows -- it's a very beautiful, colourful day!

mlbacher:

Thanks for this -- that's exactly what I was looking for.

Worked like a charm. My database and paypal are reconciled now and I see the rainbows -- it's a very beautiful, colourful day!

so this add on will allow you to see what paypal did not post?

If PayPal did not post it successfully, then you can have them re-send it. See the list of troubleshooting steps here: http://www.zen-cart.com/wiki/index.php/PayPal#Things_to_check_if_it.27s_not_working
There's a tip (around #21) on how to ask PayPal to re-send the ones that failed.

Hi all,

If you don't have access to your MySQL Server here is the fix and you can leave your MySQL server set to strict by doing this. The latest release of MySQL is default to strict and any MySQL Server updates could have started all of these problems.

I have had the double order issue as well and it looks to me as if this has been going on now for over 2 years. If you're like me you need the IPN because you want to use all of the checkout screens to gather other information (e.g. delivery date). I have found a fix for at least all the ills I have had with the Paypal IPN module to this point.

http://www.zen-cart.com/forum/showthread.php?p=854352#post854352

P.S. There are alot of posts for this issue. I hope this makes it to those posts and it fixes your issues.