Structure table Erorr :Row size too large

I have implemented 25 rows and 3 columns in by using structure table in one of the class.

I got this error while saving class and in rebuild.

In PDOConnection.php line 78:

[PDOException (42000)]
SQLSTATE[42000]: Syntax error or access violation: 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
l. You have to change some columns to TEXT or BLOBs

Any suggestions

1 Like

@vaishaliPimcore How many fields/attributes are there in your class?
If it is more than 150/200, you can fix it through some MySQL configuration changes.
it’s working fine for me.

@rahulshrivastava Thanks for the information.

There are 2 different types of data types “Structured Table” and Table. I am using a Structured Table data type. I resolved it by clicking on the Indexed option and reduce the varchar input column length.

1 Like