Hello everyone,
I’ve got an error upgrading one of my test sites; I’m not sure why I’d be getting this because there really isn’t much data even in there. Using MariaDB 10.4
The issue arises after I’ve updated composer and run the php bin/magento setup:upgrade command, which results in the following error message:
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 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs, query was: ALTER TABLE inventory_source
ADD COLUMN is_pickup_location_active
BOOLEAN NOT NULL DEFAULT 0 , ADD COLUMN frontend_name
varchar(255) NULL DEFAULT “” , ADD COLUMN frontend_description
text NULL
I’d really prefer to not have to mess with my MySQL tuning, but if I have to, I will. The installation is a blank installation with customer data uploaded. Theme is the default Luma theme.
submitted by /u/charlotte-living1
[link] [comments]