I'm getting this error:
Row Size Exceeding 65535
There are a lot of posts out there discussing the maximum row size in catalog_product_flat_x
exceeding 65535 bytes. I have only about 150 attributes including the double entry _values for the select attributes. If all attributes were 255 bytes (which they aren't), the maximum number of bytes that I could have is 38,250 bytes far less than the 65,535 byte limit. The actual data in each row is significantly lower than that.
I deleted all of the catalog_product_flat_x
tables, reindexed and am still getting this crazy error. I am on my way to having 4000 products and need this capability.
Any insight would be helpful
Best Answer
It is not depending on what your rows really hold for data but what is possible. According to official MySQL documentation https://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html
So you hit the wall way faster than in your example