Jump to content

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


VRPMMO
 Share

Go to solution Solved by VRPMMO,

Recommended Posts

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.

Screen Shot 2022-01-16 at 8.35.01 PM.png

Screen Shot 2022-01-16 at 8.38.13 PM.png

mysql_table_status.txt

Edited by VRPMMO
Link to comment
Share on other sites

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 by VRPMMO
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...