MySQL Error message: SQLSTATE: Syntax error or access violation: 1118 Row size too large (> 8126)
Posted on 2015-01-05
I have never seen this error message before - and am struggling to find a solution!
CDbCommand failed to execute the SQL statement: SQLSTATE: Syntax error or access violation: 1118 Row size too large (> 8126).
The offending row in the table was varchar 500, so the first thing I did was change that to LONGTEXT in the vain hope this would help - but to no avail.
The error message goes on to say "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."
There is unsual (at all) about the text being entered for this row and I've got other columns which are LONGTEXT with no problem at all !
Any help much appreciated !!!