Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
You are trying to translate a specific message 'Your order qualifies for free shipping 🎉' on your WordPress site using WPML, but cannot find the message in WPML for translation.
Solution:
If you're experiencing this issue, we recommend you first ensure you have a complete backup of your website database. Then, install the plugin from https://wordpress.org/plugins/database-collation-fix/. Next, add the following code to your wp-config.php file:

define('DB_COLLATE', 'utf8mb4_unicode_ci');

After activating the plugin and completing the conversion, you should scan the Flatsome theme from WPML > Themes and plugins localization and then translate the string. The steps are necessary because your database uses a collation that is not compatible with emojis.

This solution might be irrelevant if it's outdated or not applicable to your case. We highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket.

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 contains 2 replies, has 2 voices.

Last updated by Christopher Amirian 1 year ago.

Assisted by: Christopher Amirian.

Author Posts
May 29, 2024 at 11:43 am

marcD-40

Background of the issue:
I am trying to translate a specific message on my WordPress site using the WPML plugin. The message I want to translate is 'Your order qualifies for free shipping 🎉'.

Symptoms:
I cannot find the specific message 'Your order qualifies for free shipping 🎉' to translate in WPML.

Questions:
How can I locate the message 'Your order qualifies for free shipping 🎉' in WPML for translation?
Is there any specific documentation or guide on translating messages that do not appear readily in WPML?

May 29, 2024 at 12:26 pm
May 29, 2024 at 2:18 pm #15684474

Christopher Amirian
WPML Supporter since 07/2020

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi there

The issue is reported to the second-tiers support. I will get back to you as soon as I have news.

June 4, 2024 at 11:01 am #15701595

Christopher Amirian
WPML Supporter since 07/2020

Languages: English (English )

Timezone: Asia/Yerevan (GMT+04:00)

Hi there,

I have an answer from the second tier support.

To follow the steps mentioned below you need to make sure that you have complete backup of your website database.

Install the plugin below:

https://wordpress.org/plugins/database-collation-fix/

Then add the code below to your wp-config.php file of WordPress:

define('DB_COLLATE', 'utf8mb4_unicode_ci');

After that activate the plugin.

After the conversion is complete you should scan from WPML > Themes and plugins localization the Flatsome theme and translate the string.

The reason that you need to do the steps above is that your database uses a collation that is not compatible with emojis.

Thanks.

image.png