I have recently counted 167 attributes in my new platform, where I have 51 filterable.
It’s more than obvious, that the problem is the Product Flat Data indexing.
I have checked out the error.log and I get the following:
Exception message: SQLSTATE: Syntax error or access violation: 1118 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
I studied the issue on the Internet… and found Sonassi’s solution: LINK
But his solution is out of date / version.
So… I would like to change the way the indexing is done. I have to keep all the attributes. When the catalog_product_flat_1 is created, the main problem is the row size of the table. I want to tell Magento to create columns that are varchar(255) with varchar(64) instead.
Where is the file that does that, so that I can change the size of the column?