Tag Archives: Engine

SQL Error: 1030: Got error 139 from storage engine -solution

22 Tuesday Mar 2011

Posted by in MySQL

≈ 4 Comments

Tags

, ,


I developed a project and sometime later client faced that they are not able to saved data, so I checked database table, the table have more than 10 columns text type.

I googling and find out that table engine is InnoDB and InnoDB limitation row length of 8000 bytes, thats the problem,

I changed it to MyISAM and test, it working properly

 ALTER TABLE `table_name` ENGINE = MYISAM

Its work with me now.

Advertisement