Skip to content

Syntax error or access violation: 1118 Row size too large Reindexing

I am facing : 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. You have to change some columns to TEXT or BLOBs, query was: CREATE TEMPORARY TABLE catalog_product_entity_int_tmp_indexer_value

while trying to reindex. I can’t update mysql configurations as my site is on shared hosting. Let me know what I am missing or what can do to solve this issue?
How can I update the table structure and which table I need to change the fields.