Sqlstate[42000] Syntax Error Or Access Violation Row Size Too Large

I am getting the following error while running my joomla xmlImport.php file. SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some c

Solution 1:

innodb_log_file_size setting does not affect this error. The error is about a row exceeding mysql's 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.