contao:migrate fix for 1118 row size too large

by manu

If you ever encounter an error like this:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.

An easy way to fix this is to run:

OPTIMIZE TABLE tl_module;

Thanks to @ausi for this quick fix.

Back to the news overview