Mohammad Afaneh Posted July 20, 2022 Share Posted July 20, 2022 Hi, I am receiving the following error when upgrading to the newest version (4.7) of the community: 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 <site>/community/applications/core/setup/upg_107006/queries.json - query #3 ALTER TABLE `core_members` ADD COLUMN `latest_alert` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Indicates the last alert that was viewed' Any ideas how to fix this? Link to comment Share on other sites More sharing options...
Solution Jim M Posted July 20, 2022 Solution Share Posted July 20, 2022 Please ensure your database tables are set to dynamic, not compact. Otherwise, you will run into this issue. Please contact your hosting provider for assistance. SeNioR- 1 Link to comment Share on other sites More sharing options...
Marco Junior Posted August 3, 2022 Share Posted August 3, 2022 (edited) @Mohammad Afaneh Open your MySQL and execute this: Quote ALTER TABLE core_members ROW_FORMAT=DYNAMIC; OPTIMIZE TABLE core_members; And click retry on button upgrade ! Edited August 3, 2022 by Marco Junior Link to comment Share on other sites More sharing options...
Recommended Posts