SQLSTATE[42000]: Syntax error or access violation: 1118 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, BL OB prefix of 768 bytes is stored inline.
Suggestions to fix the errors:
The error is about a row exceeding mysql max row length limitation. You need to review the create table statement and either; *Reduce certain column lengths *Change some varchar columns' data type to text or blob *Change the row format as suggested in the error message *Change character encoding to sg that fits your requirements, but uses less bytes. *Change table engine from InnoDB to MyISAM
SQL syntax or access violation error while running joomla xmlImport.php file
27 July 2016 22:27Error:
SQLSTATE[42000]: Syntax error or access violation: 1118 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, BL OB prefix of 768 bytes is stored inline.
Suggestions to fix the errors:
The error is about a row exceeding mysql max row length limitation. You need to review the create table statement and either; *Reduce certain column lengths *Change some varchar columns' data type to text or blob *Change the row format as suggested in the error message *Change character encoding to sg that fits your requirements, but uses less bytes. *Change table engine from InnoDB to MyISAM