After server move and OS upgrade, etc. Paypal IPN trouble?

[Randolph Hoppe]

We know we must upgrade!

Server OS: Linux 3.10.0-1160.21.1.vz7.174.13 Database: MySQL 5.5.5-10.3.34-MariaDB
Server Date: 03/02/2022 15:34:11 Database Date: 03/02/2022 15:34:11
Server Up Time: 15:34:11 up 28 days, 20:15, 0 users, load average: 0.28, 0.33, 0.37 HTTP Server: Apache
PHP Version: 5.4.45 (Zend: 2.4.0) PHP Memory Limit: 256M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 281,222 kB Database Index Size: 76,809 kB

SuperOrders, SBA, Apsona, Magic Toolbox/Scroll

Worked fine until server move with OS upgrade. We worked with server support to downversion PHP and get the server datetime set to Americas/New_York, but PayPal seems to not be talking back to the server.

After payment, customer sees this page:

https://XYZ/index.php?main_page=checkout_process

With this text displayed:

WARNING: An Error occurred, please refresh the page and try again.

Their order is not updated in ZC, cart is still there, and they are on the confirm page. Some think it didn't go through, so there are duplicates.

An example from the log:

[02-Mar-2022 14:12:23 America/New_York] PHP Fatal error: 1292:Incorrect datetime value: '' for column etc.


Any ideas, thoughts or pointers?

[carlwhat]

get your mysql implementation out of strict mode.

talk to your hosting company.

[swguy]

No. Upgrade. Stop screwing around. That version of PHP is ancient and vulnerable to hackers.
None of the plugins you have is as valuable as a store that can't easily be hacked.

Do the Quickie upgrade, then update your template then worry about plugins.
https://docs.zen-cart.com/user/upgra..._only_upgrade/

Would you drive your car for five years without changing the oil? Because that's what you're doing.