SQL syntax or access violation error while running joomla xmlImport.php file

Error:

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

Revisions

There are no revisions for this post.

Tags: , ,

No comments yet.

Leave a Reply