Mysql error ‚Row size too large’

Error:

„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.”

 

Solution:

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;