Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126.

Problem:

Fatal error: Uncaught exception 'Exception' with message 'exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs' in /var/www/html/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/html/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/html/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /var/www/html/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `setting...', Array) #4 /var/www/html/library/Zend/Db/Adapter/Abstract.php(632): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `setting...', Array) #5 /var/www/html/application/controllers/TWController.php(239): Zend_Db_Adapter_Abstract->update('settings', Array, 'id=1') #6 /var in /var/www/html/index.php on line 307

When I tried to copy values from one table to another using phpmyadmin I get #1030 – Got error 139 from storage engine.

After googling for similar problems I found http://forums.mysql.com/read.php?22,63584,63584#msg-63584

Solution: Changing table’s storage engine from “InnoDB” to “MyISAM” helped me.

3 thoughts on “Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126.

Leave a Reply

Your email address will not be published. Required fields are marked *


*