I know ZC156 is outdated, but I am still testing for ZC157, but still have to keep old site for time being.
The host migrating to new server with new PHP 7.4, but due to the old ZC156 does not fully support 7.4, I asked host to stay with the old server PHP version until testing is fully complete. However, while the old site is running... when customer checked out, it gave out this error on backend.
(Customer would be asked to refresh, it would ended up have this error 3 times before "timed out.")
Code:
1048 Column 'id' cannot be null
in:
[INSERT INTO authorizenet (id, customer_id, order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) VALUES (NULL, 3661, 14939, 1, '(TESTMODE) 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] => 20.08\n [x_currency_code] => USD\n [x_market_type] => 0\n [x_card_num] => XXXXXXXXXXXXX0027\n [x_exp_date] => ... )]
*removed the rest due to sensitive data
So for some reasons, I tried to find out why 'id' is all sudden became 'null' when it supposed to be +1 from the database. I am trying to find out where the trigger is, but I'm not positive if whether it is in authorizenet.php or in other files that deal with SQL connection.
Bookmarks