Pay Pal IPN is not carring over my orders

[katrobb]

Dear Wishy,
One of the problems I had originally, was that I was missing a PayPal table after I up graded to 1.3.7. I currently have 5 PayPal tables:
paypal, paypal_payment_status, paypal_payment_status_history, paypal_session, and paypal_testing.
I found it by doing a test install at home and noticed the discrepancy. After I built the missing table, it work fine (until the eCheck issue). I didn't know that Zen Cart had further update patches. I guess I will have to check from time to time.
Good Luck.
Katrina

[DrByte]

wishy's unique issues are being addressed in a separate thread here:
http://www.zen-cart.com/forum/showthread.php?t=64859

[golowenow]

OK Dr. Byte. Whatever you did with the new patch the PayPal IPN module is now working correctly. Items are posting to invoices and emails are being sent on and on. When being redirected to the success page there is an error page displayed reading this:

1264 Out of range value adjusted for column 'customer_notified' at row 1
in:
[INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, comments, customer_notified) VALUES ('9', '2', now(), 'PayPal status: Completed @ 20:44:19 May 11, 2007 PDT Trans ID:5JU16798HB251572C Amount: 0.60 USD', '')]

I refreshed the page and the payment successful page opened up fine and whew the invoice was correct.

I read another post about this type of error and the solution was to edit out the sql-mode="STRICT_TRANS_TABLES" segment in the MySQL My.ini file. Remember I am running MySQL 5.0 and PHP 5.2.1. the full line of code in the My.ini file is:

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Would really like NOT to change this. Any other work arounds to this?

Once again BOTH of my zencarts are rockin!

[DrByte]

Yay ! glad it's working !

To get rid of that error under MySQL5, do this:
/includes/modules/payment/paypal.php
line 314:

                              'customer_notified' => false

change to:

                              'customer_notified' => 0

[golowenow]

This last bit of code made the IPN module run perfectly! It redirected back to the web site after hitting the PAY button perfectly and the invoice and emails are now posting correctly! WHEEEEE! Thank you Dr. Byte!

[ezskratch]

Dr Byte or anyone that can help -

Small problem with Paypal - this is what is in my ZC at "confirm order"

Shopping Cart Contents

Edit

Qty. Item Name Total 10 x Spiritual Church 2 $100.00 10 x 4 Our Kids $100.00 10 x Coins for our Cause $100.00 $300.00
Sub-Total:


$0.00
Shipping:


$300.00
Total:



BUT in Paypal I get this...

Payment For Quantity Price EzSkratch.com Purchase
Item #1 1 $300.00 USD Subtotal: $300.00 USD Shipping & Handling: $0.00 USD Sales Tax: $0.00 USD
Total Amount: $300.00 USDwith no order detail

Is this something I can fix?

Also - is there a way to make this option more attractive instead of the standard "checkout" click box such as a Paypal button? The Google Checkout button looks much nicer.

thanks

skratch

cart in progress so be kind

http://ezskratch.com/zencart/index.php?main_page

[DrByte]

...with no order detail

Is this something I can fix?

Also - is there a way to make this option more attractive instead of the standard "checkout" click box such as a Paypal button? The Google Checkout button looks much nicer.

Yes to both. Switch to using PayPal Express Checkout instead of IPN.
As for aesthetics, you could try styling your "CSS Buttons" to make your checkout button look differently, or turn off that feature altogether.