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

Tags

Engine, MySQL Error, Storage

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