WPML

Missing the *_icl_strings and *_icl_string_translations data tables

Published 2016-06-28 · Updated 2022-03-28
Status
Open

Overview of the issue

The debug.log content has these errors:

WordPress database error Table 'wp_icl_strings' doesn't exist for query…

WordPress database error Table 'wp_icl_string_translations' doesn't exist for query…

These errors result in the following issues:

  • On the WPML → String Translation page there are no strings.
  • When scanning for theme and/or plugin strings on the WPML → Theme and plugins localization page there are no strings found.

You may also see the following notification that cannot be dismissed:

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

Array ( en =>

Workaround

These errors happen when the activation of WPML is not complete. We are not yet sure how this issue is exactly replicated.

Only if you have no translations, you can go to WPML > Support > Troubleshooting > Scroll down and Reset and Deactivate WPML

If you already have translations you can use the following workaround and continue to work with WPML.


  1. Make a full backup of your site (files and database). There are many free plugins on WordPress.org for this purpose.

  2. Add this code to the bottom of the functions.php file in your theme’s root folder. 
    function wpml_fix_missing_icl_tables() {

    if( function_exists( 'icl_sitepress_activate' ) )

        icl_sitepress_activate();

}

add_action( 'wp_footer', 'wpml_fix_missing_icl_tables' );


  1. Visit your site’s homepage at least one time.

  2. Remove the code.

All known issues →