Database Error with Large Data Object


#1

Hi all,

I trying to set up a class data object that have more than 70 fields then i input values then i got belows error.

My application is ran on Ubuntu server
Please help me.

Thanks.


#2

Would help to see the full error message :wink:


#3

Hi,
the problem is, that our exceed the row size limit of mysql. The only chance to overcome this is to change your data model.
Either reduce the length of the input fields, or change some input fields to text area or wysiwyg fields (because they are stored as TEXT and therefore don’t count to the row size limit) or refactor your data model more extensively and for example move some of the input fields to object bricks.

BR
Christian


#4

Thanks all for support
I’ve just fixed this by working arround : ALTER TABLE object_localized_data_5 ROW_FORMAT=COMPRESSED;