[Resolved] WPML is missing some records in the languages tables and it cannot fully work until this issue is fi...

Problem:
You are experiencing an issue where WPML is missing some records in the languages tables, which prevents it from fully working. Despite following the suggested troubleshooting steps like clearing language information and repopulating languages, removing ghost entries, fixing terms and taxonomy relationships, setting language information, assigning translation status to duplicated content, and fixing post type assignment for translations, the problem persists.

Solution:
If you're facing this issue, we recommend you try the following steps after taking a database backup:
1- Open your database manager, for example, PhpMyAdmin.
2- Navigate to the "wp_options" table (note: 'wp_' is a standard prefix, yours might be different but the table name will be similar to xx_options).
3- Execute the following SQL query to search for the 'icl_admin_messages' key:

SELECT *
FROM `wp_options`
WHERE `option_name` LIKE '%icl_admin_messages%'
LIMIT 50;

4- Delete this key from your database.
5- Clear your cache, refresh your dashboard, and check if the message has disappeared.

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 at WPML support forum for further assistance.