Table ..._icl_strings doesn't exist error

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

Problem:
I have migrated the website from our staging server to the live server and I get this error:

We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.

Table 'himmelsg_wp991.wp0g_icl_strings' doesn't exist

Array
(
[language] => en
[context] => WP Endpoints
[gettext_context] =>
[domain_name_context_md5] => 8d0ee533eb6eaa9960c52ecb3fc80232
[name] => order-pay
[value] => order-pay
[status] => 0
[translation_priority] => optional
[allow_empty_value] =>
)

I followed the instructions here: https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

But the issue is still there, the code made no difference. The error doesn't appear on the staging server.

Solution:
We could solve the icl_table issue in your website following these steps:

- First, we excluded WPML plugins and reinstalled with their latest versions
- Then, we removed the code on functions.php that you've added in order to recreate the icl tables
- We went to your database and could find the entries "wpml_string_table_ok_for_mo_import" and "wpml_notices"
- After we deleted them, the issue was fixed and the notice on your WP Dashboard disappeared

Relevant Documentation:
https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

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

Last updated by heberT 3 years, 10 months ago.

Assisted by: Mateus Getulio.

Author	Posts
July 26, 2021 at 12:53 pm #9272117
heberT	I have migrated the website from our staging server to the live server and I get this error: We have detected a problem with some tables in the database. Please contact WPML support to get this fixed. Table 'himmelsg_wp991.wp0g_icl_strings' doesn't exist Array ( [language] => en [context] => WP Endpoints [gettext_context] => [domain_name_context_md5] => 8d0ee533eb6eaa9960c52ecb3fc80232 [name] => order-pay [value] => order-pay [status] => 0 [translation_priority] => optional [allow_empty_value] => ) I followed the instructions here: https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/ But the issue is still there, the code made no difference. The error doesn't appear on the staging server.
July 26, 2021 at 9:05 pm #9275015
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hey there, Thanks for your contact, and welcome to the WPML support forum! We’ve found some edge cases where this is a false positive message. If you verify in your database, the table 'icl_strings' is missing indeed? Moreover, please test the following steps in order to fix this issue: - Make sure to have a complete website and database backup before proceeding - Using a tool like phpmyadmin, access your options table (by default wp_options, where “wp_” is your database prefix) - Search for these entries: "wpml_string_table_ok_for_mo_import" and "wpml_notices" - Delete them If the problem remains, I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it. Our Debugging Procedures I will be checking various settings in the backend to see if the issue can be resolved. Although I won't be making changes that affect the live site, it is still good practice to backup the site before providing us access. In the event that we do need to debug the site further, I will duplicate the site and work in a separate, local development environment to avoid affecting the live site. Privacy and Security Policy We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ IMPORTANT - Please make a backup of site files and database before providing us access. - If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link Please, let me know if you need any additional details. Have a nice day.
July 27, 2021 at 5:28 pm #9282275
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hello there, Thank you for providing the credentials. We could solve the icl_table issue in your website following these steps: - First, we excluded WPML plugins and reinstalled with their latest versions - Then, we removed the code on functions.php that you've added in order to recreate the icl tables - We went to your database and could find the entries "wpml_string_table_ok_for_mo_import" and "wpml_notices" - After we deleted them, the issue was fixed and the notice on your WP Dashboard disappeared Can you check it and confirm that the problem is resolved? Let us know, please. We're looking forward to your reply. Kind regards, Mateus.