Skip Navigation

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

Problem:
The client encountered an issue with the 'There is a problem with the String Translation table in your site.' error message and discovered that the uc_domain_name_context_md5 index was missing from the icl_strings table. Additionally, there were many duplicate entries in the icl_strings table, which prevented the creation of the index.
Solution:
We resolved the issue on the staging site and requested access to the live site or a database dump to apply the fix. Our 2nd tier support team planned to log in to the dashboard, install a database admin plugin such as Adminer, patch the table, and ensure everything was functioning correctly. We emphasized the importance of not making changes during this process and the necessity of having a database backup.

If you're experiencing a similar issue, we recommend you ensure that you have a recent backup of your database before proceeding. If the solution provided here seems outdated or not applicable to your case, please check the related known issues, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. If the problem persists, we highly encourage you to open a new support ticket in the WPML support forum.

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.

Tagged: 

This topic contains 16 replies, has 2 voices.

Last updated by Osama Mersal 1 year, 1 month ago.

Assisted by: Osama Mersal.

Author Posts
May 2, 2024 at 9:19 am #15586355

nicolasG-72

Hi Osama,

I have loaded the tables, cleared the cache with 'wp cache flush', but the error is till displayed.

I have verified that the icl_strings has the necessary uc_domain_name_context_md5 index and that it is unique.

What else can be done to suppress this message?

Thanks,
--Nicolas.

May 2, 2024 at 9:29 am #15586421

Osama Mersal
WPML Supporter since 02/2020

Languages: English (English ) Arabic (العربية )

Timezone: Africa/Cairo (GMT+03:00)

Hi Nicolas,

Please delete this key (wpml_string_table_ok_for_mo_import) from the wp_options table, and make sure that it's created again.

Best regards,
Osama

May 2, 2024 at 2:43 pm #15588073

nicolasG-72

Thanks, resolved now.