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

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 means, you have too much fields in the table.

First lets try to find tables ( In this example we use table tabCompany )

SELECT

   TABLE_NAME,

   COLUMN_NAME,

   DATA_TYPE,

   CHARACTER_MAXIMUM_LENGTH AS Max_Length,

   (CASE

       WHEN DATA_TYPE IN ('varchar', 'text', 'tinytext') THEN

           COALESCE(CHARACTER_MAXIMUM_LENGTH * 4, 0) -- Assuming utf8mb4 encoding

       WHEN DATA_TYPE = 'int' THEN 4

       WHEN DATA_TYPE = 'tinyint' THEN 1

       WHEN DATA_TYPE = 'smallint' THEN 2

       WHEN DATA_TYPE = 'bigint' THEN 8

       WHEN DATA_TYPE IN ('datetime', 'timestamp') THEN 8

       WHEN DATA_TYPE = 'date' THEN 3

       ELSE 0

   END) AS Estimated_Column_Size,

   IS_NULLABLE,

   (CASE WHEN IS_NULLABLE = 'YES' THEN 1 ELSE 0 END) AS Nullable_Overhead

FROM

   INFORMATION_SCHEMA.COLUMNS

WHERE

   TABLE_NAME = 'tabCompany';

Now find how much is the row-size

SELECT

   TABLE_NAME,

   SUM(CHARACTER_MAXIMUM_LENGTH) AS Total_Varchar_Length,

   COUNT(*) AS Total_Columns,

   SUM(CASE WHEN IS_NULLABLE = 'YES' THEN 1 ELSE 0 END) AS Nullable_Columns,

   ROUND(SUM(CHARACTER_MAXIMUM_LENGTH) + SUM(CASE WHEN IS_NULLABLE = 'YES' THEN 1 ELSE 0 END), 2) AS Estimated_Row_Size

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'tabCompany';

If you find unnecessary fields, that are uninstalled from apps but still there in database, use the below command to fix that

bench trim-tables

Or

Change the field type from "custom fields" from data ( varchar ) to small-text or text . These types will not be counted