Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Mohammad Afaneh Posted July 20, 2022 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?
Solution Jim M Posted July 20, 2022 Solution 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
Marco Junior Posted August 3, 2022 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
Recommended Posts