Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 17, 20223 yr 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, 20223 yr by VRPMMO
January 17, 20223 yr 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
January 18, 20223 yr 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?
January 18, 20223 yr 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 January 18, 20223 yr by VRPMMO
January 18, 20223 yr Author Solution a HA! Darn table is MyISAM! Fixing that. 🤣 Well, thanks anyways! Please delete the topic if that's ok.
January 18, 20223 yr Community Expert We would not usually delete topics once the solution is found, as it can help others to resolve similar issues