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

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

version 210
when checking out with authorize.net aim it errors to a blank page. order went through, but cant see the details i can see the order, no details.

Code:

Feb-17-2025 01:03:38 ================================= Response Code: 1. Response Text: This transaction has been approved. Sending to Authorizenet: Array ( [x_login] => ******* [x_tran_key] => ******* [x_relay_response] => FALSE [x_delim_data] => TRUE [x_delim_char] => | [x_encap_char] => * [x_version] => 3.1 [x_solution_id] => A1000003 [x_method] => CC [x_amount] => 31.24 [x_currency_code] => USD [x_market_type] => 0 [x_card_num] => XXXXXXXXXXXX7659 [x_exp_date] => **** [x_card_code] => **** [x_email_customer] => TRUE [x_email_merchant] => TRUE [x_cust_id] => 1 [x_invoice_num] => 11312-ygclDO [x_first_name] => James [x_last_name] => Warren [x_company] => 1st Choice [x_address] => 12625 Litewood Dr [x_city] => Hudson [x_state] => Florida [x_zip] => 34669 [x_country] => United States [x_phone] => 7272474589 [x_email] => [email protected] [x_ship_to_first_name] => James [x_ship_to_last_name] => Warren [x_ship_to_address] => 12625 Litewood Dr [x_ship_to_city] => Hudson [x_ship_to_state] => Florida [x_ship_to_zip] => 34669 [x_ship_to_country] => United States [x_description] => Better Tools 20101N Round End Carpet Blades - 100 Pack (qty: 1) [x_recurring_billing] => NO [x_customer_ip] => 192.168.1.33 [x_po_num] => Feb-17-2025 01:03:36 [x_freight] => 18.35 [x_tax_exempt] => FALSE [x_tax] => 0.78 [x_duty] => 0 [x_device_type] => 8 [x_allow_partial_Auth] => FALSE [Date] => February 17, 2025, 1:03 pm [IP] => 192.168.1.33 [Session] => lfq9ri9mf783tnnjiasuagsv6i [x_type] => AUTH_CAPTURE [url] => https://secure2.authorize.net/gateway/transact.dll ) Results Received back from Authorizenet: Array ( [0] => Response from gateway [1] => 1 [2] => 1 [3] => 1 [4] => This transaction has been approved. [5] => 048478 [6] => Y [7] => 120885890571 [8] => 11312-ygclDO [9] => Better Tools 20101N Round End Carpet Blades - 100 Pack (qty: 1) [10] => 31.24 [11] => CC [12] => auth_capture [13] => 1 [14] => James [15] => Warren [16] => 1st Choice [17] => 12625 Litewood Dr [18] => Hudson [19] => Florida [20] => 34669 [21] => United States [22] => 7272474589 [23] => [24] => [email protected] [25] => James [26] => Warren [27] => [28] => 12625 Litewood Dr [29] => Hudson [30] => Florida [31] => 34669 [32] => United States [33] => 0.78 [34] => [35] => 18.35 [36] => FALSE [37] => Feb-17-2025 01:03:36 [38] => [39] => M [40] => [41] => [42] => [43] => [44] => [45] => [46] => [47] => [48] => [49] => [50] => [51] => XXXX7659 [52] => Visa [53] => [54] => [55] => [56] => [57] => [58] => [59] => 585048470179274 [60] => [61] => [62] => [63] => [64] => [65] => [66] => [67] => [68] => [69] => February 17, 2025, 1:03 pm [70] => 192.168.1.33 [71] => lfq9ri9mf783tnnjiasuagsv6i [72] => ) CURL communication info: Array ( [url] => https://secure2.authorize.net/gateway/transact.dll [content_type] => text/html [http_code] => 200 [header_size] => 204 [request_size] => 1344 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 1.358841 [namelookup_time] => 0.278643 [connect_time] => 0.317032 [pretransfer_time] => 0.403316 [size_upload] => 1146 [size_download] => 666 [speed_download] => 490 [speed_upload] => 843 [download_content_length] => 666 [upload_content_length] => 1146 [starttransfer_time] => 1.35881 [redirect_time] => 0 [redirect_url] => [primary_ip] => 198.241.207.102 [certinfo] => Array ( ) [primary_port] => 443 [local_ip] => 97.76.140.174 [local_port] => 35590 [http_version] => 2 [protocol] => 2 [ssl_verifyresult] => 0 [scheme] => HTTPS [appconnect_time_us] => 403229 [connect_time_us] => 317032 [namelookup_time_us] => 278643 [pretransfer_time_us] => 403316 [redirect_time_us] => 0 [starttransfer_time_us] => 1358810 [total_time_us] => 1358841 [effective_method] => POST [capath] => /etc/ssl/certs [cainfo] => /etc/ssl/certs/ca-certificates.crt ) RAW data received: *1*|*1*|*1*|*This transaction has been approved.*|*048478*|*Y*|*120885890571*|*11312-ygclDO*|*Better Tools 20101N Round End Carpet Blades - 100 Pack (qty: 1)*|*31.24*|*CC*|*auth_capture*|*1*|*James*|*Warren*|*1st Choice*|*12625 Litewood Dr*|*Hudson*|*Florida*|*34669*|*United States*|*7272474589*|**|*[email protected]*|*James*|*Warren*|**|*12625 Litewood Dr*|*Hudson*|*Florida*|*34669*|*United States*|*0.78*|**|*18.35*|*FALSE*|*Feb-17-2025 01:03:36*|**|*M*|**|**|**|**|**|**|**|**|**|**|**|*XXXX7659*|*Visa*|**|**|**|**|**|**|*585048470179274*|**|**|**|**|**|**|**|**|**|*February 17, 2025, 1:03 pm*|*192.168.1.33*|*lfq9ri9mf783tnnjiasuagsv6i*|**

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

its like customer not returning to comfirmation

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

Still need help here, don't know where to look.
I can see orders placed but no details about what is in order.
I had to turn it off for now, so now Noone can checkout

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

Not familiar with .net but could the items ordered in your example be:

Quote:

RAW data received:
*1*|*1*|*1*|*This transaction has been approved.*|*048478*|*Y*|*120885890571*|*11312-ygclDO*|*Better Tools 20101N Round End Carpet Blades - 100 Pack (qty: 1)*|*31.24*|*CC*|*auth_capture*|*1*|*....

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

Yes, but does not show in order details. It does show order total, but when I click details whoops happens. No log to know the error. The customer is not redirected back to checkout success, other modules like cod and money order work.

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

I have un-installed and reinstalled module but same thing happens

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

In the authorize.net logs you can see the items ordered and their quantity, and the order total etc. So you can use that in the short term to fulfill the orders that have been placed.

As for why the customer is not getting redirected to checkout_success, that's a mystery. It could be that the order-confirmation email is failing to send due to email server failure, and that's stopping the cycle of actions from completing. It could be some other thing that your store is configured to "do" when saving an order.
Normally error logs should be generated if a PHP error is occurring.
(But email connection errors are suppressed, not logged, else logs could blow out mass quantities of space).

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

Paypal works fine

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

this is what happens when i take a payment and it is approved WARNING: An Error occurred, please let us know!

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

Quote:

Originally Posted by jimmie

this is what happens when i take a payment and it is approved WARNING: An Error occurred, please let us know!

Then there's a myDEBUG*.log file present in the site's /logs directory containing information that further identifies the error.

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

There is no error log, hence my problem to try and fix it.

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

Quote:

Originally Posted by jimmie

There is no error log, hence my problem to try and fix it.

I'd start with why you're not getting those error logs written to the site's /logs directory.

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

Logs is working just not getting any logs when this happens. It looks like I will have to start from scratch if I can't figure this out. I looked up the words let us know and it is a database error.

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

All other payment modules work.
jnsflooringandsupplies.com

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

Quote:

Originally Posted by jimmie

All other payment modules work.
jnsflooringandsupplies.com

Does the issue occur in the default template? What version of PHP? Might check the url rewriter as well.

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

yes issur occures with default template

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

issue is still there with ceon url remapping turned off

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

im on php 8.3, tried 8.0 and same issue

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

Quote:

Originally Posted by jimmie

im on php 8.3, tried 8.0 and same issue

Can you verify your configure.php files are both using the SSL link for all HTTP_CATALOG_SERVER, HTTP_SERVER & HTTPS_SERVER (there are 5 locations),
All should say

'https://jnsflooringandsupplies.com'

Maybe Auth net cannot communicate to store the return response.

~Melanie

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

Quote:

Originally Posted by mprough

Can you verify your configure.php files are both using the SSL link for all HTTP_CATALOG_SERVER, HTTP_SERVER & HTTPS_SERVER (there are 5 locations),
All should say

'https://jnsflooringandsupplies.com'

Maybe Auth net cannot communicate to store the return response.

~Melanie

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');

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

I Cant edit or delete any of them

HTML Code:

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

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

this is what customers are redirected too.
https://jnsflooringandsupplies.com/i...eckout_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/i...eckout_success
i see the order but no products

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

Quote:

Originally Posted by 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?

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

Quote:

Originally Posted by jimmie

I Cant edit or delete any of them

HTML Code:

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?

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

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

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

Quote:

Originally Posted by 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.

Quote:

Originally Posted by 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.

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

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?

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

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

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

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

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

Quote:

Originally Posted by 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.

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

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.

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

Quote:

Originally Posted by 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.

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

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.

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

Quote:

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?

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

Quote:

Originally Posted by 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

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

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

Code:

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

to

Code:

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