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

I Cant edit or delete any of them

ID	Payment Method	Customers	Zone	Order Total	Date Purchased	Status	Customer
Comments	Action
11385	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders steve Heinen
Heinendrywall INC	 steve Heinen
Heinendrywall INC	Minnesota
United States	$31.14	03/01/2025 21:20:31	Pending		  
11384	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$132.93	03/01/2025 01:07:49	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 
11383	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$30.29	02/28/2025 19:52:44	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 
11382	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$30.29	02/28/2025 19:52:14	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 
11381	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$30.29	02/28/2025 19:36:31	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 
11380	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$32.68	02/28/2025 19:32:48	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 
11379	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$32.68	03/01/2025 00:29:33	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 
11378	authorizenet_aim
advshipper	Preview Customers  Show Customer's Profile Show Customer's Orders James Warren
1st Choice	 James Warren
1st Choice	Florida
United States	$32.68	03/01/2025 00:28:46	Pending		 Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info 

this is what customers are redirected too.
https://jnsflooringandsupplies.com/index.php?main_page=checkout_process
with this on a white page
WARNING: An Error occurred, please let us know!
when manually type this after i test order
https://jnsflooringandsupplies.com/index.php?main_page=checkout_success
i see the order but no products

jimmie:

yes this is exactly what is happening
Maybe Auth net cannot communicate to store the return response.
everything is correct in the configure files

• Enter the domain for your Admin URL. If you have SSL, enter the correct https address in the HTTP_SERVER setting, instead of just an http address.
  /
  define('HTTP_SERVER', 'https://jnsflooringandsupplies.com');
  /*
• Note about HTTPS_SERVER:
• There is no longer an HTTPS_SERVER setting for the Admin. Instead, put your SSL URL in the HTTP_SERVER setting above.
  */

/**

• Note about DIR_WS_ADMIN
• The DIR_WS_ADMIN value is now auto-detected.
• In the rare case where it cannot be detected properly, you can add your own DIR_WS_ADMIN definition below.
  */

/**

• Enter the domain for your storefront URL.
• Enter a separate SSL URL in HTTPS_CATALOG_SERVER if your store supports SSL.
  */
  define('HTTP_CATALOG_SERVER', 'https://jnsflooringandsupplies.com');
  define('HTTPS_CATALOG_SERVER', 'https://jnsflooringandsupplies.com');

All 5 instances in both configure.php files?

jimmie:

I Cant edit or delete any of them

ID Payment Method Customers Zone Order Total Date Purchased Status Customer
Comments Action
11385 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders steve Heinen
Heinendrywall INC steve Heinen
Heinendrywall INC Minnesota
United States $31.14 03/01/2025 21:20:31 Pending
11384 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $132.93 03/01/2025 01:07:49 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info
11383 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $30.29 02/28/2025 19:52:44 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info
11382 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $30.29 02/28/2025 19:52:14 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info
11381 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $30.29 02/28/2025 19:36:31 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info
11380 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $32.68 02/28/2025 19:32:48 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info
11379 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $32.68 03/01/2025 00:29:33 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info
11378 authorizenet_aim
advshipper Preview Customers Show Customer's Profile Show Customer's Orders James Warren
1st Choice James Warren
1st Choice Florida
United States $32.68 03/01/2025 00:28:46 Pending Display Order Details Display Shipping Label Display Invoice Display Packing Slip Print Data Sheet Delete Order Info

Where is this from?

That is from the orders page, and yeah all five places

jimmie:

Logs is working just not getting any logs when this happens...

you have lost sight of the problem and it's resolution.

as @lat9 says, i would start with why you are not getting those logs.

logs are NOT working; despite what you are saying. when ZC says an error occurs, it makes an attempt to intercept the error log and place it in the ZC logs directory.

now, zc says an error occurred, where is the log?

i would contact your hosting company, and find the logs. there are access logs and there are error logs. without the error log, it is all a shot in the dark.

jimmie:

...I looked up the words let us know and it is a database error...

well, if you think it is a database error, there is really only 1 table in play here:

TABLE_AUTHORIZENET

have you tried inserting something into that table?

but again, keep your eye on the ball. saying something is true does not make it true.

find the logs.

This has actually been going on for a few years now at first on zen version 1.51 to 1.56 it has happened sporadically only a handful of orders errored, but now on 2.10 it happens on every order now. I've been a zencart user for more than 7 years. Have used all the same plug-ins on every version. Can I give u site details so u can take a look?

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

I added somethings to server to stop getting warnings.
display_errors = off
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
But I get fatal errors

jimmie:

I added somethings to server to stop getting warnings.
display_errors = off
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
But I get fatal errors
Just so you know, disabling those logs instead of correcting the root cause of the PHP warnings will result in my ignoring further posts by you requesting assistance.

Those logs provide meaningful information for "remote debugging"; without that information, there's not much help I can provide.

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.

jimmie:

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

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.

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.

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?

barco57:

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

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