WPML is missing some records in the languages tables

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

Problem:
The client is experiencing a warning message after a WordPress multisite migration indicating that 'WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed.' The client is unable to find the action button/link to 'Clear language information and repopulate languages' on the WPML Troubleshooting page.
Solution:
1. We recommend creating a full backup of the site.
2. Check if the tables '

wp_icl_strings

' and '

wp_icl_string_translations

' are present in the database.
3. If the warning persists, navigate to WPML -> Support -> Troubleshooting and click on 'Remove all messages and notifications, for all users.' Alternatively, go to the database >

wp_options

table, find the key '

icl_admin_messages

' and delete it.
4. If the issue is not resolved, we suggest following the workaround provided in the WPML errata: Missing _icl_strings _icl_string_translations data tables.

If this solution does not seem relevant to your situation, please 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: Exception

This topic contains 4 replies, has 3 voices.

Last updated by Nikhil Vishwanath 11 months, 2 weeks ago.

Assisted by: Bruno Kos.

Author	Posts
January 8, 2024 at 4:59 am #15158108
Nikhil Vishwanath	Hi, We are working on a wordpress multisite migration and there is a warning message on our site. It states - "WPML is missing some records in the languages tables and it cannot fully work until this issue is fixed." When we go to the WPML Troubleshooting page we cannot see the action button/Link to "Clear language information and repopulate languages". Can you please help us with this? Please let me know if you need any more details on this. Thank you.
January 8, 2024 at 8:06 am #15158554
Marcel Supporter Languages: English (English ) German (Deutsch ) Timezone: Europe/Madrid (GMT+01:00)	Hi, before your ticket is assigned to one of my colleagues, please allow me to walk you through some initial debugging steps. This will help speed up the support process. Please create a full backup of your site and try to delete this row: https://wpml.org/forums/topic/clear-language-information-and-repopulate-languages/. Does this work for you? Best Regards Marcel
January 8, 2024 at 8:21 am #15158734
Nikhil Vishwanath	Hi Marcel, Thanks for your response. I checked the tables on my database. As it is a multisite, 3 such tables have the name "_icl_languages" with the different "wp_" prefix as per the different subdomains. These tables have 64 to 65 records/rows within them. The post you referred to does not specify what exactly should be cleared in this table. Please let me know and I'll apply it and check it again. Thank you, Nikhil
January 8, 2024 at 12:38 pm #15160382
Bruno Kos Supporter Languages: English (English ) German (Deutsch ) French (Français ) Timezone: Europe/Zagreb (GMT+01:00)	Can you try this workaround? https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/ And confirm that these tables are there? If the warning is still there, can you go to WPML - > Support -> Troubleshooting and click "Remove all messages and notifications, for all users." You can also go to database > wp_options table find the key "icl_admin_messages" and delete it.
January 8, 2024 at 2:07 pm #15160841
Nikhil Vishwanath	Hi Bruno, Thanks for the response. The tables are present in the database - 'wp_icl_strings' and 'wp_icl_string_translations' As you mentioned above, I clicked on the "Remove all messages and notifications" button and the warning message is now gone. I hope there are no other internal issues. So far, the translations are working on the pages as expected. Thanks and Regards, Nikhil