authorize.net errors when checking out but orders go through.

[jimmie]

I only disabled the warnings while I work on other parts of site. I have undid that on server and still can never find that error. Immediately after undoing I place order and still no error from that time stamp.

[dbltoe]

I only have a .com name with godaddy, I host my own website or sites if I want, been that way for years.

And now you bring up the fact that you self-host.

IMHO, you are never going to get this resolved unless you go back through all the posting tips and explain every thing that is different from your site and an out-of-the-box installation on a current webhost's server.

Seven years of the same modules is a lot of room for error.

[jimmie]

i do i fix this
--> PHP Fatal error: MySQL error 1292: Incorrect datetime value: '' for column `c1JNSWOKIEE`.`so_payments`.`last_modified` at row 1 :: INSERT INTO so_payments (orders_id, payment_number, payment_name, payment_amount, payment_type, date_posted, last_modified) VALUES ('11390', '11390-XXXXXX0015', 'James Warren', '107.2268', 'MasterCard', '2025-03-02 19:07:04', '') ==> (as called by) /includes/functions/database.php on line 134 <== in /includes/classes/db/mysql/query_factory.php on line 733.

[barco57]

INSERT INTO so_payments

So you have a 1.5.7 plugin added to a 2.1.0 site?
What made you think a plugin made for an old version that hasn't been updated will just work in 2.10?

[jimmie]

So you have a 1.5.7 plugin added to a 2.1.0 site?
What made you think a plugin made for an old version that hasn't been updated will just work in 2.10?

someone said try the github version is compatible with 210

[balihr]

So, just for anyone else who might get the same error...
After updating my commercial mod that @jimmie is using, I had a chance to take a quick look at this issue. It was caused by Super Orders, specifically includes/classes/super_order.php at line 735. A change from

$auto_payment['last_modified'] = $item['last_modified'];

to

$auto_payment['last_modified']##=##'now()';

fixed it and now everything's working fine.

But still - Super Orders (current github version) is a plugin that was built for Zen Cart 1.5.8 and is something I would never use on a live site. So, anyone experiencing this same issue, your best bet is to uninstall Super Orders...