Bỏ qua điều hướng
Trang chủ » 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 phản hồi sang “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

    Bình luận

  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

    Bình luận

  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

    Bình luận

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

      Bình luận

  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.

    Bình luận

  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

    Bình luận

    • 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

      Bình luận

  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?

    Bình luận

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

      Bình luận

    • 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

      Bình luận

  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

    Bình luận

  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.

    Bình luận

  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

    Bình luận

  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.

    Bình luận

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

      Bình luận

Để lại câu trả lời

Please stay on topic and be respectful to others. If you need help with issues not related to this post, use our Support Forum to start a chat or submit a ticket.

Bạn có thể sử dụng các thẻ này:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>