Skip Navigation

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

Problem:
The client received an error message indicating a problem with the String Translation table in their site, which could become a critical issue in the future.

Solution:
1. Installed the 'Database Management tool - Adminer' plugin to identify that the '_icl_strings' table was missing.
2. Added the following code to the child theme's functions.php file to recreate the missing database tables:

function wpml_fix_missing_icl_tables() {
    if( function_exists( 'icl_sitepress_activate' ) )
        icl_sitepress_activate();
}
add_action( 'wp_footer', 'wpml_fix_missing_icl_tables' );

3. Visited the home page to trigger the function.
4. Removed the code added in step 2.
5. Deleted the 'wpml_string_table_ok_for_mo_import' key from the '_options' database table.
We also provided a link to our documentation for more details: Missing _icl_strings and _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.

Tagged: 

This topic contains 2 replies, has 2 voices.

Last updated by Noman 1 year, 2 months ago.

Assisted by: Noman.

Author Posts
January 31, 2024 at 2:22 pm #15249814

alexandraO-2

We got this eroor message: There is a problem with the String Translation table in your site. This problem is not causing a problem running the site right now, but can become a critical issue in the future. WPML support team knows how to fix it. Please add a message in the relevant support thread and we'll fix it for you.

so i chattet with somebody and after reading the debug info he told me to do this:

IMPORTANT: Please take full backup of your website and database beforehand.

1) Fix “WP Memory Limit” to at least 128MB while 256MB is recommended. See
https://wpml.org/home/minimum-requirements/
for detailed information. You can set this in your wp-config.php file by adding following code:

define( 'WP_MEMORY_LIMIT', '128M' );

define( 'WP_MAX_MEMORY_LIMIT', '256M' );

Remember to add these lines before the line where it says:

/* That's all, stop editing! Happy publishing. */

2) Then update WPML plugins to the latest version.

3) After that try these Troubleshooting options:
https://wpml.org/documentation/support/wpml-troubleshooting-options/

I made the settings in the WP-Config file and also updated the two WPML-related plugins.

Then I looked at point 3 and triggered the following actions:

Cleanup and optimize string tables Clear invalid strings Remove ghost entries from the translation tables Clear the Cache in WPML None of these actions cleared the warning message.

The debug info is uploaded

January 31, 2024 at 3:26 pm #15250120

Noman
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Hi,

Thank you for contacting WPML Support. The debug info seems fine. To take a closer look at this issue, please provide temporary access (WP-Admin and FTP Login info) to your site (preferably staging site), so that I can look into your setup and debug the issue.

Your next answer will be private, meaning only you and I can access it.

=== Please backup your database and website ===

✙ I would additionally need your permission to deactivate and reactivate Plugins and the Theme and to change configurations on the site. This is also a reason the backup is essential.

Thank you

February 1, 2024 at 3:27 pm #15255715

Noman
Supporter

Languages: English (English )

Timezone: Asia/Karachi (GMT+05:00)

Thanks for sharing the login details. I’ve followed the below steps in order to fix this issue:

1. Installed the “Database Management tool - Adminer” plugin and find out that “_icl_strings” table was missing from database and WPML >> String Translation page doesn’t show any string for translation.

2. To add the missing database tables, added the below code in child theme functions.php file:

function wpml_fix_missing_icl_tables() {
 
    if( function_exists( 'icl_sitepress_activate' ) )
 
        icl_sitepress_activate();
 
}
add_action( 'wp_footer', 'wpml_fix_missing_icl_tables' );

3. Visited the home page once.

4. Removed the above code that in step #2.

5. Removed the “wpml_string_table_ok_for_mo_import” key from “_options” database table.

Here is a doc for more details: https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

Now it seems to be working correctly, could you please check and confirm?

Thank you

February 2, 2024 at 11:13 am #15258783

alexandraO-2

Thanks for your help!! 🙂 It is working perfectly now.