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:
Code:
[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', '¥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.
Bookmarks