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.
Printable View
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
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.p...7s_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/showth...352#post854352
P.S. There are alot of posts for this issue. I hope this makes it to those posts and it fixes your issues.