Jump to content

Featured Replies

Posted

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

Solved by VRPMMO

Go to solution
  • Community Expert

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

 

  • Author

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?

  • Author

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

  • Author
  • Solution

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

  • Community Expert

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

 

Recently Browsing 0

  • No registered users viewing this page.