Open

Topic Tags: Install and update

Symptoms

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.

Workaround

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

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.

30 Responses to “Missing the *_icl_strings and *_icl_string_translations data tables”

  1. when I visit the homepage, this apear Parse error: syntax error, unexpected ‘wpml_fix_missing_icl_tables’ (T_STRING) in /home/hudsonparkcom/public_html/hp/wp-content/themes/hotel-xenia/functions.php on line 400

  2. I have removed option key wpml_string_table_ok_for_mo_import from options table. but it’s getting added again if reload the page.

    • Hello Ronda,

      The best way to properly help you is through our support forum, so we can ask you some more details we can’t ask you in the errata’s comments.

      Could you please create a new support thread?

  3. Hello support team,

    I have updated the WPML plugins with latest updates but There is displaying a warning in WordPress backed as

    “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.”

    Please suggest that how to remove it.

    Thanks
    Thijs

  4. Hello support team,

    I have updated the WPML plugins with latest updates but There is displaying a warning in WordPress backed as

    “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.”

    Please suggest that how to remove it.

    – – –

    as it is the same problem i simply copied that stuff – saves time – it would be much better if you would simply provide a working solution here instead of keeping customers in line

    Thanks
    Andi

    • Hello!
      If you had the tables missing, and you re-created them – then you might need to only remove the key “wpml_string_table_ok_for_mo_import” from the option table(by default wp_options, where “wp_” is your database prefix) in order to hide the notice.
      If after removing the key, you still have the error – then probably your tables structure need patching.
      We can help you with the patch process in the ticket: @https://wpml.org/forums/topic/wpml-is-telling-me-that-it-has-a-broken-table-that-needs-fixing/
      However, we cannot provide manual steps on patching the database and retaining the strings and their translations, because this is something that has potentially hundreds of possibilities there that are tailored for the individual case and they vary greatly depending on the needed patch for the database.

  5. Hi, am also having the same problem when trying to remove ‘wpml_string_table_ok_for_mo_import’ from wp_options it keeps coming back.

    iv no table for ‘wp_strings’ what can i do, is it possible to give you access to site which iv got Adminer installed.

    • Hello Glyn
      I remember that you already contacted me in the ticket (@https://wpml.org/forums/topic/wpml-is-telling-me-that-it-has-a-broken-table-that-needs-fixing/ ) where we patch these cases.
      You told me that the key comes back – and in reply #2751444 I responded to you that this is perfectly normal.
      If you wish to proceed further, you can either share a database in that ticket or give access so that we can work on your site.

  6. Hello @George

    I have issue while editing and updating the post, not able to see the media pages under media library as well. Getting the same error.

    Thanks & Regards

  7. Hello
    I’ve got this message :

    Array
    (
    [language] => en
    [context] => Widgets
    [gettext_context] =>
    [domain_name_context_md5] => a48c6eb3c5890b18ba90320a27899305
    [name] => widget title – 69e7df6b9f7404b4007d936978a45c81
    [value] => Recent Comments
    [status] => 0
    [translation_priority] => optional
    [allow_empty_value] =>
    )

    How to resolve this ? I add the function and go to HP but still have this message.

    Thanks,
    Jonathan

    • Hi Jonathan,

      We found out some edge cases where this is a false positive message.

      You can verify if this is a false positive:
      1. Go to WPML -> String Translation
      2. Search for the string “Recent Comments”.

      If you manage to find the string with the same “context” (“Domain”), “gettext_context” (“Context”) and “Name”, the notice is a false alarm and you can dismiss it.

      Otherwise, please open a ticket on the support forum and you will get assistance to fix your problem.

      Thanks,
      Pierre

  8. Hi I have opened a ticket and the support team replied with a link that redirects me to this page. I followed the first step which is to backup the site. For the second step, I don’t understand how could I reach to the functions.php file or the theme’s root folder. I am currently using Xstore theme so does it mean I have to go to the CSS?

    • This was the error that i sent to the support team that redirected me to this site.

      “We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.
      Array
      (
      [language] => en
      [context] => wpv-views
      [gettext_context] =>
      [domain_name_context_md5] => 05b694accde8bab26286d380ef2cad1f
      [name] => dc770a451931e3eb28348451a1ef9896
      [value] => Text Search
      [status] => 0
      [translation_priority] => optional
      [allow_empty_value] =>
      ) “

    • Hi,

      We found out some edge cases where this is a false positive message.

      You can verify if this is a false positive:
      1. Write down the string mentioned in the “value” element of the “Array” (from the notice message)
      2. Go to WPML -> String Translation
      3. Search for the string

      If you manage to find the string with the same “context” (“Domain”), “gettext_context” (“Context”) and “Name”, the notice is a false alarm and you can dismiss it.

      Otherwise, if you don’t know how to edit the functions.php file of your theme, please ask for assistance in your support ticket. A supporter will help you to do this.

      Thanks,
      Pierre

  9. hello guys could you help me please i really got confuse and irradiated because of this problem , ido have the same problem and im losing my work and my time becouse i cant work with wpml with this problem 🙁 help me please

Leave a Reply

Please leave here comments about this page only.
For technical support and feature suggestions, head to our forum. We are waiting there!

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>