Hello all,
I'm working on installing SAP Commerce 2105 locally on a mac, and I'm using mysql 8.0.31 community server. When running the 'ant initialize' command, it's failing with the following error:
bad SQL grammar [ CREATE TABLE cmscomponent ...
I have confirmed that it's failing on the creation of the cmscomponent table, and I've confirmed that other tables have been successfully created. I've tried running the 'ant initialize' command several times, and it fails at the same spot each time.
Doing some googling on the error that I'm getting, the problem seems to be related to the number and size of the columns that are being created. I can get a more specific error by manually executing the sql statement to create the cmscomponent table:
ERROR 1118 (42000): 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.
The solutions that I've seen for this problem say to change the data type for columns of type varchar to text. Unfortunately, I don't know how to do that with Commerce, and it seems to me like this would be a setting somewhere in the configuration of Commerce.
Does anyone have an idea of what I should do here?