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 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
Last edited by webjuggler; 15 Oct 2009 at 03:37 PM. Reason: 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.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
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.
Last edited by tfharman; 10 Mar 2010 at 07:12 PM.
Bookmarks