Skip to main content

How can I resolve the Row Size Too Large error?

In rare instances users have reported the following error when attempting to upgrade:
"SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126"
This is due to an incompatible Row Format setting. Please check the Row Options set on your FusionInvoice database's tables and change the setting to "Don/'t Use" or "Dynamic".
It is recommended that you change the setting on all tables within your database. Below is an example command to run to change these settings for the clients table:

            alter table clients ROW_FORMAT=DYNAMIC;
Back to top