Error while Creating new field in Doctype

Hello friends,
I have some custom fields added in my sales invoice doctype and it worked with no issues. But now when i tried adding one more field to the doctype it showed me following error while saving.

Traceback (innermost last):
File “/home/erpnext/frappe-bench/apps/frappe/frappe/desk/form/save.py”, line 18, in savedocs
doc.save()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 240, in save
self.run_post_save_methods()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 561, in run_post_save_methods
self.run_method(“on_update”)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 509, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 626, in composer
return composed(self, method, *args, **kwargs)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 609, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/document.py”, line 503, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 101, in on_update
updatedb(self.name)
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 62, in updatedb
tab.sync()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 87, in sync
self.alter()
File “/home/erpnext/frappe-bench/apps/frappe/frappe/model/db_schema.py”, line 255, in alter
raise e
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’)

@Deep how many custom fields have you added ? The error shows that you have exceeded the maximum limit.

1 Like