V16: Migrating Existing DATA or Company error Row size too large

1

Hi all,

When migrating existing data from V15 to V16 i encountered the below 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

This happened while

Updating DocTypes for erpnext : [==================== ] 50%Failed to alter schema using query: ALTER TABLE tabCompany ADD COLUMN reporting_currency varchar(140), ADD COLUMN accounts_frozen_till_date date, ADD COLUMN role_allowed_for_frozen_entries varchar(140), ADD COLUMN default_sales_contact varchar(140), ADD COLUMN purchase_expense_account varchar(140), ADD COLUMN service_expense_account varchar(140), ADD COLUMN purchase_expense_contra_account varchar(140), ADD COLUMN enable_item_wise_inventory_account tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN valuation_method varchar(140) DEFAULT ‘FIFO’, ADD COLUMN default_wip_warehouse varchar(140), ADD COLUMN default_fg_warehouse varchar(140), ADD COLUMN default_scrap_warehouse varchar(140)

ERROR 1118 (42000): 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

2

Getting same error
Updating DocTypes for frappe : [========================================] 100%
Updating DocTypes for erpnext : [= ] 2%Failed to alter schema using query: ALTER TABLE tabSales Invoice ADD COLUMN apply_tds tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN is_created_using_pos tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN pos_closing_entry varchar(140), ADD COLUMN has_subcontracted tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN tax_withholding_group varchar(140), ADD COLUMN ignore_tax_withholding_threshold tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN override_tax_withholding_entries tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN coupon_code varchar(140), ADD COLUMN dont_create_loyalty_points tinyint(4) NOT NULL DEFAULT 0, ADD COLUMN utm_source varchar(140), ADD COLUMN utm_campaign varchar(140), ADD COLUMN utm_medium varchar(140), ADD COLUMN utm_content varchar(140)

There was an issue while migrating the DocType: Sales Invoice