SQL error: Row size too large because of many varchar(255) fields
When installing the extension, creating the table tx_sgcookieoptin_domain_model_optin
fails with this error message:
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
This is causes by the total sum of all the varchar(255)
fields. I think you could change some of them to tinytext
or varchar(32)
. Especially the many color fields do not need 255 characters. For example lightgoldenrodyellow
has only 20 characters. ;-)