CODEWITHSUNDEEP
mysqlsql
Techiescorner
Techiescorner

Reputation: 811

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 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.

As many of them suggested I have increased innodb_log_file_size to 128M but still I am getting the same error. Can sombody help me on this?

Upvotes: 1

Views: 3262

Answers (1)

Shadow
Shadow

Reputation: 34294

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.

Upvotes: 4

Related Questions