Issue with Authorize.net AIM updating table - error 1366 incorrect integer value

[DrByte]

Your log shows you were doing a refund. The transaction_id is blank when doing a refund, which is what is triggering that problem.

This is how we've fixed it for v1.5.5 and newer:
https://github.com/drbyte/zc-v1-seri...c5444994c6fea2

[SPython]

Your log shows you were doing a refund. The transaction_id is blank when doing a refund, which is what is triggering that problem.

This is how we've fixed it for v1.5.5 and newer:
https://github.com/drbyte/zc-v1-seri...c5444994c6fea2

I am having a similar problem with the AIM authorize.net module. I see from the AIM_debug logs that the transaction has been approved but no order is received or written to the database (except the logs) and no emails are sent to either the merchant or the client. We have previously used the SIM module which worked except for erratic timeouts.
This is the error I am seeing in myDebug log:
PHP Fatal error: 1366:Incorrect integer value: '' for column 'transaction_id' at row 1

I am using PHP v. 7.0.9

Would appreciate advice on how to remedy this.

[SPython]

Here is the myDebug.log with personal info removed

[01-Nov-2016 16:42:42 UTC] Request URI: /index.php?main_page=checkout_process, IP address: *.*.*.*
#1 trigger_error() called at [/home/**/**/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/**/**/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/**/**/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/**/**/includes/modules/payment/authorizenet_aim.php:753]
#5 authorizenet_aim->_debugActions() called at [/home/**/**/includes/modules/payment/authorizenet_aim.php:440]
#6 authorizenet_aim->before_process() called at [/home/**/**/includes/classes/payment.php:245]
#7 payment->before_process() called at [/home/**/**/includes/modules/checkout_process.php:83]
#8 require(/home/**/**/includes/modules/checkout_process.php) called at [/home/**/**/includes/modules/pages/checkout_process/header_php.php:14]
#9 require(/home/**/**/includes/modules/pages/checkout_process/header_php.php) called at [/home/**/**/index.php:36]

[01-Nov-2016 16:42:42 UTC] PHP Fatal error: 1366:Incorrect integer value: '' for column 'transaction_id' at row 1 :: insert into authorizenet (id, customer_id, order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) values (NULL, 2, 12, 1, 'This transaction has been approved.', 'auth_capture', '', 'Array\n(\n [x_login] => *******\n [x_tran_key] => *******\n [x_relay_response] => FALSE\n [x_delim_data] => TRUE\n [x_delim_char] => |\n [x_encap_char] => *\n [x_version] => 3.1\n [x_solution_id] => A1000003\n [x_method] => CC\n [x_amount] => 0.71\n [x_currency_code] => USD\n [x_market_type] => 0\n [x_card_num] => XXXXXXXXXXXXXXXXxxx\n [x_exp_date] => ****\n [x_card_code] => ****\n [x_email_customer] => TRUE\n [x_email_merchant] => TRUE\n [x_cust_id] => 2\n [x_invoice_num] => 12-BDlbtJ\n [x_first_name] => ***\n [x_last_name] => ***\n [x_company] => **** ****\n [x_address] => *** *** ave\n [x_city] => brooklyn\n [x_state] => New York\n [x_zip] => 11249\n [x_country] => United States\n [x_phone] => *********\n [x_email] => ***@***.com\n [x_ship_to_first_name] => ****\n [x_ship_to_last_name] => ****\n [x_ship_to_address] => **** *** ave\n [x_ship_to_city] => brooklyn\n [x_ship_to_state] => New York\n [x_ship_to_zip] => 11249\n [x_ship_to_country] => United States\n [x_description] => Deli Pint 16oz (qty: 1) \n [x_recurring_billing] => NO\n [x_customer_ip] => **.**.**.**\n [x_po_num] => Nov-01-2016 04:42:39\n [x_freight] => 0.00\n [x_tax_exempt] => FALSE\n [x_tax] => 0.06\n [x_duty] => 0\n [x_device_type] => 8\n [x_allow_partial_Auth] => FALSE\n [Date] => November 1, 2016, 4:42 pm\n [IP] => **.**.**.**\n [Session] =>*********\n [x_type] => AUTH_CAPTURE\n [url] => https://secure.authorize.net/gateway/transact.dll\n)\n', 'Array\n(\n [0] => 1\n [1] => 1\n [2] => 1\n [3] => This transaction has been approved.\n [4] => *****\n [5] => N\n [6] => ******\n [7] => 12-BDlbtJ\n [8] => Pint 16oz (qty: 1)\n [9] => 0.71\n [10] => CC\n [11] => auth_capture\n [12] => 2\n [13] => ****\n [14] => ****\n [15] => **** ****\n [16] => **** *** ave\n [17] => brooklyn\n [18] => New York\n [19] => 11249\n [20] => United States\n [21] => 2125290628\n [22] => \n [23] => ********######################\n [24] => ****\n [25] => ****\n [26] => \n [27] => **** *** ave\n [28] => brooklyn\n [29] => New York\n [30] => 11249\n [31] => United States\n [32] => 0.06\n [33] => 0.00\n [34] => 0.00\n [35] => FALSE\n [36] => Nov-01-2016 04:42:39\n [37] => *************\n [38] => M\n [39] => \n [40] => \n [41] => \n [42] => \n [43] => \n [44] => \n [45] => \n [46] => \n [47] => \n [48] => \n [49] => \n [50] => XXXX***\n [51] => Visa\n [52] => \n [53] => \n [54] => \n [55] => \n [56] => \n [57] => \n [58] => \n [59] => \n [60] => \n [61] => \n [62] => \n [63] => \n [64] => \n [65] => \n [66] => \n [67] => \n [68] => November 1, 2016, 4:42 pm\n [69] => **.**.**.**\n [70] => ******\n [71] => *********\n [Expected-MD5-Hash] => ***********\n [HashMatchStatus] => PASS\n)\n', 'November 1, 2016, 4:42 pm', '******' ) ==> (as called by) /home/**/**/includes/modules/payment/authorizenet_aim.php on line 753 <== in /home/**/**/includes/classes/db/mysql/query_factory.php on line 167

[SPython]

Fogot to add: Zencart version 1.5.5a

[SPython]

mysql Ver 15.1 Distrib 10.1.18-MariaDB, for Linux (x86_64) using EditLine wrapper

[SPython]

@@SESSION.sql_mode |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |