MySQL error when executing ALTER_TABLE_OBSERVATORIO_ESTADO_OAW_4.2.1.sql

[marcorcau]

Hello,

I am getting the following error when executing the /4.2.1/ALTER_TABLE_OBSERVATORIO_ESTADO_OAW_4.2.1.sql script on a fresh install:

ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

This is with following DB version, with Debian defaults:

Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11

Setting both fields length to 4000 instead of 8000 solves the problem:

ALTER TABLE observatorio_estadoCHANGEultima_url ultima_urlVARCHAR(4000); ALTER TABLEobservatorio_estadoCHANGEactual_url actual_url VARCHAR(4000);

¡¡ Thanks for a great app !!