Try ERPNext Buy Support Partners Foundation

InternalError: (1118, 'Row size too large

Hey there,

when I am trying to add a new field to my custom doctype I get the following error:

2020-08-20%2011_10_51-Window

As far as I have searched for it this means that there are to many “Text”-Fields in the Mariadatabase. What is the best workaround / solution for adding more fields to this doctype?

Hello,

today I did some research and found out the following.

  • The SQL-Error is primarily caused by to many Attributes in the Database-Table of the Doctype
  • The Database-Table of the Doctype grows with Changes made to the Doctype (probably due to backwards compatibilty
  • It is possible to delete deprecated columns manually, but proceed with care and backup everything prior to such operations