Friday, May 31, 2024

ERROR 1118 (42000) at line 33: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

ERROR 1118 (42000) at line 33: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

 

 

This generally happens, when innodb_strict_mode is active, 

make it off / deactivate using this command in sql prompt,

 

MariaDB [(none)]> SET GLOBAL innodb_strict_mode = 0;
Query OK, 0 rows affected (0.000 sec)

then it will works,

That's it.

Cheers...!

0 comments: