Help With PayPal Express on MySQL 5

[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

[mitchcecg]

Linda
It looks like I am not the only one with this problem.
I have tried a reinstall in a different virtual dir on IIS and it does not work no matter what I do.
Let me know when we can communicate I have PM’d you with my contact info
THANX

[DrByte]

Mitch,

I have duplicated the problem you mention using a test windows server running PHP 5 and MySQL 5.

I took the same SQL statement that's failing on MySQL 5 and ran it on a MySQL 4 server, without error.

It seems that MySQL 5 (if running in strict_trans mode) disallows auto-translation from the supplied date data to MySQL date format.

I'm now working on a translator so we send the right format to the database, to accomodate the MySQL 5 enforced standards ...

[Ajeh]

/me continues to twist the good DrBytes arm on this one ... or else go bald ...

[DrByte]

.......

[DrByte]

Here's the skinny:

Based on the Feb 19 patch, make these changes:
/includes/modules/payment/paypalwpp.php

line 780 says:

                          'payment_date' => $this->payment_time,

change to:

                          'payment_date' => trim(preg_replace('/[^0-9-:]/', ' ', $this->payment_time)),

line 793 says:

                          'notify_version' => '',

change to:

                          'notify_version' => '0',

Ajeh is doing some testing to be sure she, er, um, I didn't bust nothin ...


UPDATE: Patch issued:
http://www.zen-cart.com/forum/showth...514#post332514

[mitchcecg]

Thanks all for the help. It is now working You nailed it.

MITCHcecg

[PotzUK]

Confirmed, that did the trick :)