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 content is archived.
New page created for this, deleting this one as the link for the new page is shared with a client on support ticket

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

 

Got feedback or spotted a mistake?

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