New Zenner
- Join Date:
- Oct 2012
- Posts:
- 65
- Plugin Contributions:
- 0
Error whenever someone places an order after upgrading to MariaDB 10.3
Yesterday I upgraded MySQL to MariaDB 10.3. Now whenever someone places an order, the credit card is approved, but they get "WARNING: An Error occurred, please refresh the page and try again." Zen-Cart does not record the order.
Here is the error that is saved in the Debug file.
[13-Jun-2019 12:41:06 America/New_York] Request URI: /index.php?main_page=checkout_process, IP address: 76.73.213.28
#1 trigger_error() called at [/home/patriot/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/patriot/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/patriot/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/patriot/public_html/includes/modules/payment/authorizenet_aim.php:753]
#5 authorizenet_aim->_debugActions() called at [/home/patriot/public_html/includes/modules/payment/authorizenet_aim.php:440]
#6 authorizenet_aim->before_process() called at [/home/patriot/public_html/includes/classes/payment.php:245]
#7 payment->before_process() called at [/home/patriot/public_html/includes/modules/checkout_process.php:83]
#8 require(/home/patriot/public_html/includes/modules/checkout_process.php) called at [/home/patriot/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#9 require(/home/patriot/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/patriot/public_html/index.php:36]
[13-Jun-2019 12:41:06 America/New_York] PHP Fatal error: 1366:Incorrect integer value: '' for column patriot_copy.authorizenet.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, 11969, 14884, 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] => 10.11\n [x_currency_code] => USD\n [x_market_type] => 0\n [x_card_num] => XXXXXXXXXXXXXXXX3419\n [x_exp_date] => ****\n [x_card_code] => ****\n [x_email_customer] => FALSE\n [x_email_merchant] => TRUE\n [x_cust_id] => 11969\n [x_invoice_num] => 14884-crIYTq\n [x_first_name] => Kyle\n
[HashMatchStatus] => PASS\n)\n', 'June 13, 2019, 12:41 pm', 'b1c9a81eb31dbd21f8bf0cfcc63cf5a3' ) ==> (as called by) /home/patriot/public_html/includes/modules/payment/authorizenet_aim.php on line 753 <== in /home/patriot/public_html/includes/classes/db/mysql/query_factory.php on line 167
