cotonti.com : SQL error 22001: String data, right truncated https://www.cotonti.com Neueste Themenbeiträge Cotonti en Mon, 04 May 2026 06:20:47 -0000 aiwass Workaround:
Fast workaround try to extend online_ip field in cot_online table to 45 char length as follows

ALTER TABLE `cot_online` CHANGE `online_ip` `online_ip` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';
]]> So, 03 Nov 2019 19:26:25 -0000 foxhound https://github.com/Cotonti/Cotonti/issues/1634#issuecomment-489830360

 

Uhm, I guess that is your ticket :)

]]> Mi, 15 Mai 2019 19:37:16 -0000 pieter Does anybody has an idea how to solve this?

SQL error 22001: String data, right truncated: 1406 Data too long for column 'online_ip' at row 1

#0  cot_diefatal(SQL error 22001: String data, right truncated: 1406 Data too long for column 'online_ip' at row 1) called at [/customers/6/4/a/xxxxxxxx/httpd.www/system/database.php:451]
#1  CotDB->insert(cot_online, Array ([online_ip] => 2a02:1810:1d33:9700:ddca:e0f4:feb9:b41,[online_name] => v,[online_lastseen] => 1556694430,[online_location] => home,[online_subloc] => ,[online_userid] => -1,[online_shield] => 0,[online_hammer] => 0)) called at [/customers/6/4/a/xxxxxx/httpd.www/plugins/whosonline/whosonline.header.main.php:62]
#2  include(/customers/6/4/a/xxxxx/httpd.www/plugins/whosonline/whosonline.header.main.php) called at [/customers/6/4/a/xxxxxx/httpd.www/system/header.php:87]
#3  require_once(/customers/6/4/a/xxxxx/httpd.www/system/header.php) called at [/customers/6/4/a/xxxxx/httpd.www/modules/index/index.php:44]
#4  require_once(/customers/6/4/a/xxxxxx/httpd.www/modules/index/index.php) called at [/customers/6/4/a/xxxxxx/httpd.www/index.php:176]
]]> Mi, 01 Mai 2019 07:12:17 -0000