"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".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).