Trying to publish changes in one of 3 locales of an entry gives error:
Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1030 Got error 139 from storage engine
It is basically a row size problem.
The entry has many fields and there are 3 locales. It is possible to save a draft of the changes made.
What i tried:
On staging server I have solved the problem with changing the database config
innodb_file_format = Barracuda
and then changing row format of some tables (entries, content and fields) to compressed.
This is not possible on live production server since host does not allow it. And also it probably is not the best solution.
I also tried to change the table engine to MyISAM but this gave error:
SQL Error  : Cannot delete or update a parent row: a foreign key constraint fails
I hope there is a simple solution to all this.
Thank you for your help, I am a bit green in all this, my background is in design.