Mysql error ‚Row size too large’


„Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.”



Change your DB structure so that it fits in the InnoDb limits.


Quick fix:

Add the following to the my.cnf file under [mysqld] section.

And then execute:

ALTER TABLE mdl_lti ROW_FORMAT=Compressed;