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 TABLEobservatorio_estadoCHANGEultima_url`ultima_url VARCHAR(4000);
ALTER TABLE observatorio_estado CHANGE actual_urlactual_url VARCHAR(4000);`
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 BLOBsThis 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 TABLEobservatorio_estadoCHANGEultima_url`ultima_urlVARCHAR(4000); ALTER TABLEobservatorio_estadoCHANGEactual_urlactual_urlVARCHAR(4000);`¡¡ Thanks for a great app !!