pymysql.err.OperationalError: (1118, 'Row size too large. The maximum row size for the used table

[Darshit_Patel]

pymysql.err.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’)

[NCP]

Please check this.

[Darshit_Patel]

@NCP Thanks

I tried this using the size field in the customize form and deleted some unusual data fields, but at deployment time, it keeps giving this error again and again. I’m trying to add new fields and also remove unusual fields.

Deploy in frappe cloud.

Failed to alter schema using query: ALTER TABLE tabItem ADD COLUMN custom_other_contact_person int(1) not null default 0, ADD COLUMN custom_contact_detail varchar(140), ADD COLUMN custom_supplier_designation varchar(140)

I’m adding this data fields

[NCP]

@Darshit_Patel

deleted some unusual data fields, but at deployment time, it keeps giving this error again and again.

I think, You have to trim the table. so first take a backup and test it.

How to delete Fields From Database also

Remove the field from the UI, but ensure it remains in the database. Trim the table and verify. Before proceeding, make sure to take a backup. [image]

[Darshit_Patel]

@NCP

I’m used version 14 and i’m delete field from UI in local bench and after save customization in custom app and test in one live instance. In test live instance update successfully but production instance i’m getting this error.

[NCP]

@Darshit_Patel

For example, the “data” type field is typically set to a maximum size of 20. The default data field size in the database is 140, allowing for customization and allocation of space for new fields in the form.

@NCP

Please check this .

If you read the documentation carefully, the solution you provided is there.