Error when upgrading to v 4.7

[Mohammad Afaneh]

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?

[Jim M]

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.

[Marco Junior]

@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