This thread is resolved. Here is a description of the problem and solution.
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.
If this solution does not seem relevant to your issue, please open a new support ticket with us.
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.
This topic is split from https://wpml.org/forums/topic/the-translation-of-my-blogpost-is-not-showing-up-despite-being-created/
