Row size too large error: how to add max fields in single table?

[sheetal5]

We are using Fabrik 3.2
While saving field it is showing
500 alter structure: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs SQL=ALTER TABLE `aod` ADD COLUMN `eol_db_creditor2_pcity` VARCHAR(255) AFTER `eol_db_creditor2_pcode`

How can we add it in single table?
We have single form and many fields

 

[troester]

This is no Fabrik but a MySQL restriction.

You can shorten your field elements (set maxlength <255),
you can change field element to text area (which will use TEXT instead of VARCHAR in the DB).

We have single form and many fields

In general you should check if you have a reasonable and normalized database setup.