Maxing out the DB

Hi all, I am in the process of configuring V6 on a new server to migrate the data over from V4 which we currently use. I keep getting this error below in ERPNext v6 which is strange as it has less fields than the current one we use V4. Is there anything else I can do to add more fields or is this a limitation/bug with the newer version? So far I am editing the ‘Employee’ tab which is giving the following error.

Hosted on Debian 7, Google compute Engine

OperationalError: (1118, 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs')

Thank you for your continued support!

1 Like

We will push a patch to reduce “Data” size to 140.

For now, you will have to convert one of your Data custom fields to Small Text.

You are welcome and we look forward to your contributions and participation :smile:

Excellent,

I’ll keep an eye on github and will keep my server updated.

Thank you for the quick reply!