Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535

Error message in the middle of update or migrate - how to fix Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535

 · 1 min read


Error: 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')


The reason is your customization gone too much !


You have added many field than mysql ( mariadb ) can handle.


Ideally you can reduce the field size , mostly varchar(150) to varchar(50) or something on doctype fields.  ( Basically Data field with lenght of 0 is actually varchar with length of 150 ) . Change the length field from 0 to 50 in this case.


But if you are in the middle of a migrate or update, you can not get this front-end screen to do that. It will either show "Internal Error" or "site being updated" . So the only option you have is go directly to mariadb and do that.


bench --site yoursite.erpgulf.com mariadb

use select commands to see the fields in table

select name,length,owner,module,idx from  `tabCustom Field`;  

find the fields you have customized

then alter it

update   `tabCustom Field` set length = 100  where name = 'your-custom-field-name';


Try bench update or migrate again. If the error repeats, do it on one more field - repeat


Lets know your feedback.





Cloud support

Cloud support team provides hosting related support and technology updates. Cover technology like cloud printing, Cloud PBAX, VoIP, Kubernetes, Ubuntu, Linux etc. Contact us on support@ERPGulf.com

No comments yet

No comments yet. Start a new discussion.

Add Comment