Page 1 of 5 123 ... LastLast
Results 1 to 10 of 49
  1. #1
    Join Date
    Apr 2009
    Posts
    35
    Plugin Contributions
    0

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

    I'm using a fresh install of v154 on Windows.

    Have an issue with authorize.net aim payment module. Payments are being accepted ok and order transactions are fine.

    The issue is in admin when i'm trying to do a refund or void a transaction. Everything is processing on Authorize.net's end find, the refunds or voids are processing. The issue i'm getting is when it's posting back to update the table. I'm getting a "WARNING: An Error ocurred, please refresh the page and try again"

    I checked the error logs on one refund, which is below. Looks like it's not updating properly on the post back and it's, just trying to insert it.

    I've looked on the forum but haven't found a solution. Any help or pointing in the correct direction would be awesome.

    On a side note, i'm using another zen store using v150 on the same server, with authorize.net AIM and i'm not having in any issues.

    Thanks

    [14-Dec-2015 23:12:22 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, 0, 0, 3, 'A duplicate transaction has been submitted. DUPLICATE TRANSACTION ATTEMPT ', 'credit', '', '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_type] => CREDIT\n [x_card_num] => XXXX2491\n [x_amount] => 1.80\n [x_trans_id] => 7795201288\n [url] => https://secure.authorize.net/gateway/transact.dll\n [Note] => Refund Issued - sales tax charged in error\n)\n', 'Array\n(\n [0] => 3\n [1] => 1\n [2] => 11\n [3] => A duplicate transaction has been submitted.\n [4] => \n [5] => P\n [6] => 0\n [7] => \n [8] => \n [9] => 1.80\n [10] => CC\n [11] => credit\n [12] => \n [13] => \n [14] => \n [15] => \n [16] => \n [17] => \n [18] => \n [19] => \n [20] => \n [21] => \n [22] => \n [23] => \n [24] => \n [25] => \n [26] => \n [27] => \n [28] => \n [29] => \n [30] => \n [31] => \n [32] => \n [33] => \n [34] => \n [35] => \n [36] => \n [37] => 0845F2EA77CA726A3B6132F3551D8A49\n [38] => \n [39] => \n [40] => \n [41] => \n [42] => \n [43] => \n [44] => \n [45] => \n [46] => \n [47] => \n [48] => \n [49] => \n [50] => XXXX2491\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)\n', 'December 14, 2015, 3:12 pm', '' ) ==> (as called by) C:\inetpub\wwwroot\paisano-store\includes\modules\payment\authorizenet_aim.php on line 692 <== in C:\inetpub\wwwroot\paisano-store\includes\classes\db\mysql\query_factory.php on line 155


    ======

    Dec-14-2015 03:12:22
    =================================

    Response Code: 3.
    Response Text: A duplicate transaction has been submitted.

    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_type] => CREDIT
    [x_card_num] => XXXX2491
    [x_amount] => 1.80
    [x_trans_id] => 7795201288
    [url] => https://secure.authorize.net/gateway/transact.dll
    [Note] => Refund Issued - sales tax charged in error
    )


    Results Received back from Authorizenet: Array
    (
    [0] => Response from gateway
    [1] => 3
    [2] => 1
    [3] => 11
    [4] => A duplicate transaction has been submitted.
    [5] =>
    [6] => P
    [7] => 0
    [8] =>
    [9] =>
    [10] => 1.80
    [11] => CC
    [12] => credit
    [13] =>
    [14] =>
    [15] =>
    [16] =>
    [17] =>
    [18] =>
    [19] =>
    [20] =>
    [21] =>
    [22] =>
    [23] =>
    [24] =>
    [25] =>
    [26] =>
    [27] =>
    [28] =>
    [29] =>
    [30] =>
    [31] =>
    [32] =>
    [33] =>
    [34] =>
    [35] =>
    [36] =>
    [37] =>
    [38] => 0845F2EA77CA726A3B6132F3551D8A49
    [39] =>
    [40] =>
    [41] =>
    [42] =>
    [43] =>
    [44] =>
    [45] =>
    [46] =>
    [47] =>
    [48] =>
    [49] =>
    [50] =>
    [51] => XXXX2491
    [52] => Visa
    [53] =>
    [54] =>
    [55] =>
    [56] =>
    [57] =>
    [58] =>
    [59] =>
    [60] =>
    [61] =>
    [62] =>
    [63] =>
    [64] =>
    [65] =>
    [66] =>
    [67] =>
    [68] =>
    )


    CURL communication info: Array
    (
    [url] => https://secure.authorize.net/gateway/transact.dll
    [content_type] => text/html
    [http_code] => 200
    [header_size] => 263
    [request_size] => 414
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 1.389
    [namelookup_time] => 0
    [connect_time] => 0.063
    [pretransfer_time] => 1.264
    [size_upload] => 225
    [size_download] => 308
    [speed_download] => 221
    [speed_upload] => 161
    [download_content_length] => 308
    [upload_content_length] => 225
    [starttransfer_time] => 1.389
    [redirect_time] => 0
    [certinfo] => Array
    (
    )

    [redirect_url] =>
    )


    RAW data received:
    *3*|*1*|*11*|*A duplicate transaction has been submitted.*|**|*P*|*0*|**|**|*1.80*|*CC*|*credit*|**|**|**|**|**|**|**|**|**|**| **|**|**|**|**|**|**|**|**|**|**|**|**|**|**|*0845F2EA77CA726A3B6132F3551D8A49*| **|**|**|**|**|**|**|**|**|**|**|**|*XXXX2491*|*Visa*|**|**|**|**|**|**|**|**|** |**|**|**|**|**|**|**



    Also some other details.:

    server OS: Windows NT 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586
    Database: MySQL 5.1.57-community
    HTTP Server: Microsoft-IIS/7.5
    PHP Version: 5.3.13 (Zend: 2.3.0)
    MYSQL is running in strict mode

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

    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
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

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

    Quote Originally Posted by DrByte View Post
    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.

  4. #4
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

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

    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

  5. #5
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

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

    Fogot to add: Zencart version 1.5.5a

  6. #6
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

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

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

  7. #7
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

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

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

  8. #8
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

    Default Checkout Process error Incorrect integer value: '' for column 'transaction_id'

    I am using Zen Cart 1.5.5b,Apache/2.4.23 (Unix) OpenSSL/1.0.2h PHP/7.0.9 mod_fcgid/2.3.9 and Authorize AIM module to process transactions. All was working smoothly until I upgraded the server to Fedora 25. Now the client receives an error on checkout though the Authorize.net transaction goes through. Unfortunately, the client does not know this and so refreshes their browser and resubmits the order - multiple times. The transaction is not recorded in Zen Cart.
    Relevant info from myDebug.log is:

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

    [29-Nov-2016 20:20:03 UTC] PHP Fatal error: 1366:Incorrect integer value: '' for column 'transaction_id' at row 1 :: insert into authorizenet

    Would greatly appreciate any advice or pointers. Something about this error seems familiar.

  9. #9
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Checkout Process error Incorrect integer value: '' for column 'transaction_id'

    Are you using the Authorize.net AIM to process payments for Eprocessing's AIM emulator, and not actually for Authorize.net itself?

    Ref: #15 & #17
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  10. #10
    Join Date
    Jun 2016
    Location
    New York, NY
    Posts
    78
    Plugin Contributions
    0

    Default Re: Checkout Process error Incorrect integer value: '' for column 'transaction_id'

    I believe I am using the default Authorize.net AIM module with Zen Cart. The client who I configured and host the cart for has an account with Authorize.net.

 

 
Page 1 of 5 123 ... LastLast

Similar Threads

  1. v153 Communications Error with Authorize.net (AIM)
    By ajhoover in forum Addon Payment Modules
    Replies: 6
    Last Post: 13 Nov 2014, 08:24 PM
  2. Replies: 2
    Last Post: 22 Jun 2013, 03:48 AM
  3. 1366 Incorrect integer value Problems with MySQL 5 strict-mode
    By Max70 in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 13
    Last Post: 10 Dec 2009, 07:11 PM
  4. Replies: 4
    Last Post: 14 Jan 2009, 11:45 AM
  5. VAT error message (1366 Incorrect decimal value)
    By Typhoon in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 5
    Last Post: 18 Jul 2006, 11:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR