/
Error 'Row size too large'
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

Error 'Row size too large'

This error is expected when creating a form if the number of fields exceeds 80. This is because the underlying MySQL database has a limitation (click here) on how many columns a table can support.

Note: This error can come when syncing forms from other applications like REDCap or OpenClinica.

To fix the error:

This problem has no fix since the underlying database imposes the limitation.

Workarounds:

  1. If the Form is being created in OpenSpecimen: create multiple forms

  2. If the Form is being synced from OC/RC: Ignore unwanted fields

 

Related content

OC FAQs and Errors
OC FAQs and Errors
More like this
Custom Forms
Custom Forms
Read with this
How to fix 'Malformed Query' error?
How to fix 'Malformed Query' error?
More like this
How to fix corrupted specimen event forms?
How to fix corrupted specimen event forms?
More like this
How to solve "Error creating bean with name 'importSpeForms' defined in ServletContext resource"?
How to solve "Error creating bean with name 'importSpeForms' defined in ServletContext resource"?
More like this
Fixing database constraint errors
Fixing database constraint errors
More like this
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com