Salta la navigazione
Home » Errata » Missing the *_icl_strings and *_icl_string_translations data tables

Missing the *_icl_strings and *_icl_string_translations data tables

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.

41 risposte a “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

    Rispondi

    • 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?

      Rispondi

  6. 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

    Rispondi

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

    Rispondi

    • 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.

      Rispondi

  8. 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.

    Rispondi

    • 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.

      Rispondi

  9. 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

    Rispondi

  10. 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

    Rispondi

    • 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

      Rispondi

  11. 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?

    Rispondi

    • 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] =>
      ) “

      Rispondi

    • 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

      Rispondi

  12. 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

    Rispondi

  14. this message came out on my website, how can i fix it? thank you!

    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.

    Rispondi

  16. 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.

    in my database F. PHP as below

    <?php
    if ( !defined( 'ICL_LANGUAGE_CODE' ) && !defined('TOPDEAL_THEME') ){
    define( 'TOPDEAL_THEME', 'topdeal_theme' );
    }else{
    define( 'TOPDEAL_THEME', 'topdeal_theme'.ICL_LANGUAGE_CODE );
    }

    what i should do to remove this red note and solve problem

    Rispondi

  17. Hi guys

    re. “There is a problem with the String Translation table in your site. This problem is not causing a problem running the site right now, ” ETC ….

    will you PLEASE update WPML we can easily dismiss this annoying message. It’s a simple matter of actually including an ‘X’ in the top right corner to dismiss the message and there have been so many customers asking you about this. Still it continues.

    Rispondi

    • Hello Andi,

      Make sure you followed step 3 (Visit your site’s homepage at least one time), it’s important to activate the code.

      If the issue still occurs after this, please open a ticket or chat on our support forum and we will investigate.

      Rispondi

Lasciare una risposta

Ti preghiamo di rimanere in tema e di essere rispettoso nei confronti degli altri. Se hai bisogno di aiuto per questioni non correlate a questo post, utilizza il nostro Forum di supporto per avviare una chat o inviare un ticket.

Potete usare questi tag:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>