Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 10, 20169 yr Hello after testing the upgrade process on our IP.Board 3.4.9 to IPB 4.1.x (latest) I see mixed collations. The UTF8 Converter stated: "The database tables are UTF-8, collations are correct and there is nothing to convert. You can proceed with the upgrade." Upgrade run fine, but now I see mixed collations, like e.g.: ipb_conv_link_topics utf8mb4_unicode_ci ipb_core_acp_search_index utf8_unicode_ci ipb_core_acp_tab_order utf8_unicode_ci ipb_core_acronyms utf8mb4_unicode_ci ipb_core_admin_login_logs utf8mb4_unicode_ci ipb_core_admin_logs utf8mb4_unicode_ci ipb_core_admin_permission_rows utf8mb4_unicode_ci ipb_core_advertisements utf8_unicode_ci When running UTF8 Converter Tools after the upgrade the output is as follows: 86 tables are utf8mb4 57 tables are utf8 0 tables have incorrect collations Why is that, I guess this shouldn't be mixed collations... How can I fix this, I can easily convert the tables myself if this is safe to be done, but it is a PITA to convert the columns as well manually... Thanks, Thomas
Archived
This topic is now archived and is closed to further replies.