1406 Data too long for column 'ip_address' at row 1 error

[OopsIbrickedIT]

[Zencart 1.5.0 & cache from 1.5.2, Mariadb,Php fpm 5.6, hestia control panel, Ubuntu 18.04 LTS server, CLoudflare CDN]

hi again folks, I had to move our webshop very fast to new server (above settings). It works fast but I started getting following error: 1406 Data too long for column 'ip_address' at row 1 error

any help would be greatly appreciated, aka support for ipv6, I have newer 1.5.6 series running on other server with 250K products but it is not production ready yet

[OopsIbrickedIT]

Sorry I forgot this:
in:
[insert into zen_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', 'f78701ed7a27074ea67e9865845da5b7', '2001999208884748803744', '1571558909', '1571558909', '/kauppa/', 'OFFICE_IP_TO_HOST_ADDRESS', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36')]

I changed to use pseudo ipv6 to ipv4 translation on cloudflare cdn as an temporary solution.

[OopsIbrickedIT]

Also it makes me wonder is there charset encoding problems: ¥Guest. I use utf-8 on db or actually it is utf8mb4 if I remember correctly

[swguy]

Zen Cart 1.5.0 is quite old. The length of the IP Address field in that version was only 20; the length in 1.5.6c is 45. This and other bugs would be fixed by an upgrade.

[OopsIbrickedIT]

Zen Cart 1.5.0 is quite old. The length of the IP Address field in that version was only 20; the length in 1.5.6c is 45. This and other bugs would be fixed by an upgrade.

I understand. But for clarity is it ok to increase it to 45 in old 1.5.0 ? Or will it cause problems when exporting db to upcoming 1.5.6?

[swguy]

If it was me, I'd bump it for now to keep going but get the upgrade scheduled. If you are running Zen Cart 1.5.0 then you are on an old version of PHP which is not receiving security patches, so upgrading should be a priority.

[OopsIbrickedIT]

Thanks. I will bump it up

Upgrading is a priority but the time I have is limited. Php 7.0 needs lots of upgraded modules which I dont have yet and seems I have to learn more zencart & php 7 first because for example part of old payment modules dont work with zc 1.5.6 & php 7.0 I would need good links to payment module development too. Especially what have changed from 1.5.0 to 1.5.6 in db structure & handling.

Shop is not a small one. Soon over 100K products and at the end of year over 150K products. I finally got my own servers and bigger runs php 7.0 with new template and 1.5.6. Old one is still on old template & 1.5.0& php 5.6 which I have tuned & added cache etc.

[dbltoe]

Just follow DrByte's instructions on the newer server. https://www.zen-cart.com/entry.php?3...d-of-upgrading

It gives you time to get the new working while the old is still running AND, all the information about changed files is in the docs.