Help With PayPal Express on MySQL 5

[mitchcecg]

[FONT=Calibri]I have been working on getting PayPal Express checkout to work for the last 2 days UNSUCCESSFULLY.[/FONT]
[FONT=Calibri]Firstly PayPal IPN does work[/FONT]
[FONT=Calibri]I started with the 1.3.7 base added the apple zen template I have patched the paypal module with both the FEB 8th and the Feb 15th patch I have set up a sandbox account for testing and have the appropriate credentials.[/FONT]
[FONT=Calibri]If I turn on debugging /logging or logging with email and I return from paypal I just get a blank explorer screen. No log file is created.[/FONT]
[FONT=Calibri]When I have debugging off and I complete the checkout I am taken to a paypal login screen after logging in it shows no $amounts on it just basically has a pay now button when clicked it returns to zencart/mysite with the following message[/FONT]
[FONT=Calibri][/FONT]
[FONT=Calibri]“[/FONT]we were not able to process your order. Please try again, select an alternate payment method, or contact the store owner for assistance. (Transaction refused because of an invalid argument. See additional error messages for details.)”
[FONT=Calibri]Any help would be appreciated[/FONT]
[FONT=Calibri][/FONT]
[FONT=Calibri]THANX
MITCHCECG[/FONT]
[FONT=Calibri][/FONT]

[Ajeh]

See if the February 15th patch helps you ... PayPal changed some things the other day ... surprise surprise surprise ...

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

[Ajeh]

NOTE: the sandbox is using one set of constants and the Live site another ... go figure?

Switch to Live ...

[mitchcecg]

Thanks for getting back to me so quickly

I turned on live and set the appropriate credentials
[FONT=Calibri] Paypal Processes the order [/FONT]
[FONT=Calibri]However, when I return to ZenCart I now get the following ERROR[/FONT]
[FONT=Calibri][/FONT]
1292 Incorrect datetime value: '2007-02-17T16:29:15Z' for column 'payment_date' at row 1
in:
[INSERT INTO hi_paypal (zen_order_id, txn_type, 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, parent_txn_id, num_cart_items, mc_gross, mc_fee, mc_currency, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo) VALUES ('5', 'cart', 'None', 'PayPal Express Checkout (instant)', 'Completed', 'None', 'EC-1KK28351KK007574U', 'test', ‘user', '', 'test user', '2000 Lenox Drive, Suite 100', 'Lawrenceville', 'NJ', '08648', '', 'Confirmed', '[email protected]', 'LRW9TN2L5E49S', 'verified', '2007-02-17T16:29:15Z', '', 'admin.cecg.com', '', '1C857737LF707714E', '', '1', '0.01', '0.01', 'USD', '0', 'USD', '1', '', '', now(), '')]

Any Ideas
Thanks in advance
MITCHCECG

[DrByte]

Hmmm ... will have to dig on that one. That date is supposed to be translated before insertion into the database, hence the error.

[Ajeh]

I just made a clean install of v1.3.7 ...

Tried checkout which naturally fails ...

Then applied the Patch for February 15th ... and all is working ...

[mitchcecg]

OK now I feel dumb. I have reapplied the feb 15th patch and I am still getting the "1292 Incorrect datetime value error".
I am at a total loss as to solving this mistery any help would be appreciated

THANX
MitchCECG

[Ajeh]

While this is a pain to do on a test ...

Can you make a test directory with a test database with the demo data ... from a clean Zen Cart v1.3.7 ... and apply the February 15th patch ...

Then set this up for your PayPal Express ... make sure you are set to Live ...

Do you still get this date error?

So far I just cannot reproduce this at all on a clean install with the February 15th patch ...

[mitchcecg]

I will do that on Monday if we don't reach a resolution before then.
FYI This is a clean install which is not live yet I have added a few items to the cart and am using the apple zen template. I applied the FEB 8th patch before I applied the FEB 15th patch if that is a clue to the problem.

You can view the site at igethigh.cecg.com and I am able to give you remote access to the server if you desire since it is at my location and not a hosting service
I will be out of town most of tomorrow (Sunday) but should be back in the evening.

Thanks again for the help

MitchCECG

[Ajeh]

Drop me a PM when you get back ... maybe we can work out what the issue is ...