PayPal IPN - 1292 Incorrect datetime value

[keylesslocks]

When I login to my admin it says: Your version of Zen Cart™ appears to be current.

[DrByte]

And if you click the "Version Info" link beside the logout link in the top right of your admin panel, what version info does it give you?

[keylesslocks]

Zen Cart 1.3.8a

[DrByte]

If that's the case, then you've done something to break one or more of the paypal-related files under your /includes/modules/payment folder and subfolders.
Time to compare them all and fix whatever differences exist.

[keylesslocks]

when I put the code back to the original everything works fine, but we still are getting these double orders... only sometimes...

[jazznuts699]

does anyone know what the function datetime_to_sql_format does? this is not a mysql function from what i can tell.

i too am getting the error stated at the start of this thread -- and when i implement the code to fix it i get a blank screen.

i think this is because the function datetime_to_sql_format is not defined however i may be wrong. Please advise.

[DrByte]

Your blank screen will be a result of an incorrect edit, perhaps even by leaving extra blank lines at the end of the file.
Related FAQ (posted earlier in this discussion for the same reason): https://www.zen-cart.com/tutorials/index.php?article=82

[jazznuts699]

Your blank screen will be a result of an incorrect edit, perhaps even by leaving extra blank lines at the end of the file.
Related FAQ (posted earlier in this discussion for the same reason): https://www.zen-cart.com/tutorials/index.php?article=82

i forgot i already had error reporting enabled, and the error is as i suspected undefined function, please see below.


undefined method paypal::datetime_to_sql_format() in E:\Website_data\tw2_test\includes\modules\payment\paypal.php on line 413

line 413 is that new line i added...

'payment_date' => $this->datetime_to_sql_format($this->pdtData['payment_date']),

[DrByte]

That function is defined in /includes/modules/payment/paypal/paypal_functions.php
If it's missing from yours, then you've got a very old version of the file or you've got addons/customizations which have broken core functionality.

[jazznuts699]

That function is defined in /includes/modules/payment/paypal/paypal_functions.php
If it's missing from yours, then you've got a very old version of the file or you've got addons/customizations which have broken core functionality.

i have that function in there... but same error... i resorted to turning off strict mode which fixed the problem but now i have to ensure it did not create other problems.

forum.mambo-foundation.org/showthread.php?t=5254