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 ...

[PotzUK]

For the record, I'm also getting this error message. It's a completely fresh install and I'm using the Feb 15th patch. It's running on Win2k, IIS and MySQL 5.

I'm also using the UK Paypal, I know that's caused issues with the shipping address, which I've gotten around by using the hardcoding 'GB' fix from another thread.

1292 Incorrect datetime value: '2007-02-19T09:58:20Z' for column 'payment_date' at row 1

[PotzUK]

Reckon the problem lies in the parsing in this function:

function datetime_to_sql_format($paypalDateTime) {
//Copyright (c) 2004 DevosC.com
$months = array('Jan' => '01', 'Feb' => '02', 'Mar' => '03', 'Apr' => '04', 'May' => '05', 'Jun' => '06', 'Jul' => '07', 'Aug' => '08', 'Sep' => '09', 'Oct' => '10', 'Nov' => '11', 'Dec' => '12');
$hour = substr($paypalDateTime, 0, 2);$minute = substr($paypalDateTime, 3, 2);$second = substr($paypalDateTime, 6, 2);
$month = $months[substr($paypalDateTime, 9, 3)];
$day = (strlen($day = preg_replace("/,/" , '' , substr($paypalDateTime, 13, 2))) < 2) ? '0'.$day: $day;
$year = substr($paypalDateTime, -8, 4);
if (strlen($day)<2) $day = '0'.$day;
return ($year . "-" . $month . "-" . $day . " " . $hour . ":" . $minute . ":" . $second);
}

But I'm not an expert enough to figure it out! Maybe adding another step to change the T to a space and to drop the Z off the date that's getting sent to the database?

[mitchcecg]

To PotzUK
Just to see if there are any other commonalities
did you install any add-ons or templates