Results 1 to 10 of 15

Threaded View

  1. #1
    Join Date
    Apr 2008
    Plugin Contributions

    Default PHP Fatal error: 1406:Data too long for column 'ip_address' at row 1

    Hello everyone.

    I'm encountering a really weird issue at the moment I'm going to need some help with.

    I'm running v1.5.6a on one of my stores and getting this intermittent issue whenever some customers pay using SquareUp.

    This is what I keep getting in the log file:
    [10-Jul-2019 01:42:39 America/Detroit] Request URI: /, IP address: e:21:DaabaeDe:3::2:fc:17:eeFac:0::21:000dcecadea:1::0a:2::0:9:ee:5::8:ae:20:DaabaeDe:0::8:feed:56:ded5DECEAAFac::eCfe:19:caceaefc:6:ae:5:caceb:1:11:caceca:20:DaabaeDe:0::1:4::13:000cecb:1
    #1  trigger_error() called at [/xxxxx/includes/classes/db/mysql/query_factory.php:171]
    #2  queryFactory->show_error() called at [/xxxxx/includes/classes/db/mysql/query_factory.php:143]
    #3  queryFactory->set_error() called at [/xxxxx/includes/classes/db/mysql/query_factory.php:270]
    #4  queryFactory->Execute() called at [/xxxxx/includes/functions/whos_online.php:93]
    #5  zen_update_whos_online() called at [/xxxxx/includes/init_includes/init_special_funcs.php:19]
    #6  require(/xxxxx/includes/init_includes/init_special_funcs.php) called at [/xxxxx/includes/autoload_func.php:48]
    #7  require(/xxxxx/includes/autoload_func.php) called at [/xxxxx/includes/application_top.php:170]
    #8  require(/xxxxx/includes/application_top.php) called at [/xxxxx/index.php:26]
    --> PHP Fatal error: 1406:Data too long for column 'ip_address' at row 1 :: insert into whos_online
                    (customer_id, full_name, session_id, ip_address, time_entry,
                     time_last_click, last_page_url, host_address, user_agent)
                  values ('0', '&yen;Guest', 'ee7ea5fb75af673eead6ef4183e7c17e', 'e:21:DaabaeDe:3::2:fc:17:eeFac:0::21:000dcecadea:1::0a:2::0:9:ee:5::8:ae:20:DaabaeDe:0::8:feed:56:ded5DECEAAFac::eCfe:19:caceaefc:6:ae:5:caceb:1:11:caceca:20:DaabaeDe:0::1:4::13:000cecb:1', '1562737359', '1562737359', '/', '', 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Win64; x64; Trident/4.0)') ==> (as called by) /xxxxx/includes/functions/whos_online.php on line 93 <== in /xxxxx/includes/classes/db/mysql/query_factory.php on line 171.
    Right now the issue is happening to only one client that I'm aware of as other orders paid using the SquareUp module seem to go through just fine. Whenever that client tries to make a purchase with her credit card if the order goes through which I don't know how she manages, I end up with an order and no SquareUp segment on the orders.php page to approve/process the credit card at all, which we've had to decline several times in the past couple of weeks.

    I have the SquareUp payment module set up to Authorize as we need to verify the order before capturing the payment.

    I've tried looking for answers on the forum but couldn't locate any threads discussing this issue.

    Any help would be appreciated.
    Last edited by mvstudio; 17 Jul 2019 at 03:35 PM.



Similar Threads

  1. Replies: 3
    Last Post: 26 Mar 2018, 07:08 AM
  2. Data too long for column
    By yd29999 in forum General Questions
    Replies: 0
    Last Post: 8 Sep 2017, 06:45 PM
  3. Direct Bank Deposit - 1406 Data too long for column 'shipping_method'
    By remoteone in forum Addon Payment Modules
    Replies: 13
    Last Post: 31 Mar 2009, 12:24 AM
  4. 1406 Data too long for column "last_page_url" at row 1
    By time4fishing in forum PayPal Website Payments Pro support
    Replies: 2
    Last Post: 11 Jan 2008, 01:00 AM
  5. Data too long for column 'shipping_method' - Big Royal Mail
    By pwhyles in forum Addon Shipping Modules
    Replies: 3
    Last Post: 9 Nov 2006, 08:49 AM


Posting Permissions

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