Specified key was too long; max key length is 1000 bytes

[VRPMMO]

Upgrading from v4.4.10 to v.4.6.9 w/ MySQL 8 for DB. All tables are InnoDB w/ utf8mb4_unicode_ci engine. Stuck with the error shown in the attached screenshots. How can I resolve and complete the upgrade? Also included MySQL table status and status output for reference.

NOTE: I would open a support ticket, but the Client Area says Email support expired 5 days ago, but our license is through June 2022. We seem to have no easy way to remedy this either.

mysql_table_status.txt

Edited January 17, 2022 by VRPMMO

[Marc]

That issue is generally caused by the columns on tables in your database being set to the Compact row formant. You would need to speak to your hosting company on this, and have them switch them to dynamic

 

[VRPMMO]

If you look at the mysql_table_status.txt file I attached to my original post, you'll see that all tables are currently set to dynamic. Unless there's more I should be looking at?

[VRPMMO]

It looks like it has something to do with this query... captured in the general MySQL query log.

ALTER TABLE `core_search_index` ADD KEY `followed_content` (`index_class`(248),`index_is_last_comment`,`index_hidden`,`index_date_commented`,`index_date_updated`);

 

Edited January 18, 2022 by VRPMMO

[VRPMMO]

a HA! Darn table is MyISAM! Fixing that. 🤣 Well, thanks anyways! Please delete the topic if that's ok.

[Marc]

We would not usually delete topics once the solution is found, as it can help others to resolve similar issues