Skip to content

Row size too large#

Problem#

I want to update i-doit. During the update, an error message appears, such as:

Solution#

A backup should already exist because of the update.
We set the row size and run the update again, first we log in to mysql:

1
mysql -u root -p

Now the affected database is selected. 

1
USE idoit_data;
If the error occurs for multiple databases, this step must be performed for all affected databases.
This may be the case if there are multiple clients.

Now we set the ROW_FORMAT of the table from Fixed to Dynamic:

1
ALTER TABLE isys_cats_person_list ROW_FORMAT=DYNAMIC;