Error "Data too long for column 'ip' at row 1"

19.02.2026 17:49
#1
El Tucan
Joomshopping forum user no avatar
Name: El Tucan
04.04.2022
Posts: 38
Quote
Error "Data too long for column 'ip' at row 1"

Hi,
some visitors have an error on product details:
Data too long for column 'ip' at row 1

But since the last update of Joomshopping and Statistics about two weeks ago we have much less orders.

This is really urgent for us - thanks!
Error "Data too long for column 'ip' at row 1"


Website Url: https://www.eltucan.ch/
 
19.02.2026 18:50
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28243
Quote
Aw: Error "Data too long for column 'ip' at row 1"

Now.
Disable all plugins 'JoomShopping - Statistics'

------------

mysql version?


Last change: 19.02.2026 18:52
 
19.02.2026 19:12
#3
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28243
Quote
Aw: Error "Data too long for column 'ip' at row 1"

Use mysql:
execute query (# - prefix your Joomla)
ALTER TABLE `#_jshopping_jstat_pvs` CHANGE `ip` `ip` VARCHAR(40) NOT NULL;

or wait new version addon.

 
19.02.2026 19:46
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 28243
Quote
Aw: Error "Data too long for column 'ip' at row 1"

New version
Joomshopping Stats 2.9.8

 
20.02.2026 12:01
#5
El Tucan
Joomshopping forum user no avatar
Name: El Tucan
04.04.2022
Posts: 38
Quote
Aw: Error "Data too long for column 'ip' at row 1"

yes that works - thank you!

 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.