MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB

The Solution to MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB is


I tried all the solutions here, but only this parameter

innodb_strict_mode             = 0

solved my day...

From the manual:

The innodb_strict_mode setting affects the handling of syntax errors for CREATE TABLE, ALTER TABLE and CREATE INDEX statements. innodb_strict_mode also enables a record size check, so that an INSERT or UPDATE never fails due to the record being too large for the selected page size.

~ Answered on 2016-05-06 15:25:38


Most Viewed Questions: