January 17, 2022 in Technical Problems
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.
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
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?
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`);
a HA! Darn table is MyISAM! Fixing that. 🤣 Well, thanks anyways! Please delete the topic if that's ok.
We would not usually delete topics once the solution is found, as it can help others to resolve similar issues
Started February 26
Started March 13, 2023
Started 42 minutes ago