1118 Row size too large

One of our client received an exception while trying to reindex Flat Catalog Product that eventually stuck in 'Processing' stage:
"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. You have to change some columns to TEXT or BLOBs".
The fun part about this one is that its not a Magento issue :) That is a limitation of MySQL.

The solution would be to minimize usage of the varchar (Text Field, Multiple Select) product attributes on the frontend by avoiding them in flat index: "Used in Product Listing" = No, "Use in Layered Navigation" = No, "Used for Sorting in Product Listing" = No . You may also use "Dropdown" input type instead of "Multiple Select" (int instead of varchar).


We Love Our Customers

    Team of US based Certified Magento Engineers will work directly with you (no middle-men) to make sure MagePhobia provides best quality technical services. Some of our Magento Engineers are ex-Magento employees who built Magento for several years and know Magento inside-out.
    MagePhobia provides affordable
Magento Services with one of the best quality on the market.
    Our US based Technical Support is provided exclusively by our Certified Magento Developers and System Administrators, and is available 24/7 via ticketing, chat, and phone.
    MagePhobia offers short and long-term contracts as well as 'per job' basis contracts. We refund in case of unsatisfactory results which, we believe, will not occur ever.

We are all-in for customer satisfaction!