Problem: The client is experiencing issues with translations not appearing correctly on their website. Some pages are partially translated, while others are not translating at all, even after manual retranslation. The client suspects emojis might be causing issues on some pages, and there are also problems with the translation of the footer template and the shop page title.
Solution: We have identified that the problem is related to the database collation settings. To resolve this issue, we recommend the following steps: 1. Perform a backup of your database to ensure you can restore your site if necessary. 2. Run the following SQL queries in your database panel:
ALTER TABLE wp_icl_strings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE wp_icl_string_translations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
3. After running these queries, make some changes to the pages (you can bulk update them) and send them again for translation. If you're not comfortable running these queries, we can assist you, but please ensure you have a full backup of your database before proceeding.
Problem:
The issue is that the English pages, intended as translations of French pages, are incorrectly tagged as French, and the user is unable to change their language tag or link them to the corresponding French pages.
Solution:
Edit the French page on the right sidebar, change the language from French to English.
If unable to change the language, switch to the English translation by using the language switcher at the top header while in the edit page.
Dismiss any warnings and review the language settings to switch the language of the translation.
If the above steps don't work, delete the English version of the pages and then remap the connection. Relevant Documentation:
