{"id":7405999,"date":"2020-11-16T15:29:31","date_gmt":"2020-11-16T15:29:31","guid":{"rendered":"https:\/\/wpml.org\/?post_type=faq&#038;p=7405999"},"modified":"2023-09-06T13:27:14","modified_gmt":"2023-09-06T13:27:14","slug":"how-to-deal-with-error-messages-about-a-broken-table-that-needs-fixing","status":"publish","type":"faq","link":"https:\/\/wpml.org\/he\/faq\/how-to-deal-with-error-messages-about-a-broken-table-that-needs-fixing\/","title":{"rendered":"How can I solve error messages about a broken table that needs fixing?"},"content":{"rendered":"<p class=\"lead\">You can solve broken table error messages by bringing the issue to our support team.<\/p>\n<p>There are two error messages you might see if WPML has a broken table that needs to be fixed in the database:<\/p>\n<ol>\n<li><a href=\"#problem-with-string-translation-table\">&quot;There is a problem with the String Translation table in your site.&quot;<\/a><\/li>\n<li><a href=\"#problem-with-some-tables-in-the-database\">&quot;We have detected a problem with some tables in the database.&quot;<\/a><\/li>\n<\/ol>\n<h2 id=\"problem-with-string-translation-table\">How can I solve the \u201cThere is a problem with the String Translation table in your site\u201d error?<\/h2>\n<p>If you see this message, please back up your site and <a href=\"https:\/\/wpml.org\/forums\/forum\/english-support\/\">create a new ticket in our forum<\/a> for our support team to investigate further.<\/p>\n<p>The full error message reads:<\/p>\n<blockquote><p>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.<\/p><\/blockquote>\n<p>This message appears when a column or index is missing from the <strong>icl_strings<\/strong> table in your database. Our support team can assist you with identifying and regenerating the missing information.<\/p>\n<h2 id=\"problem-with-some-tables-in-the-database\">How can I solve the \u201cWe have detected a problem with some tables in the database\u201d error?<\/h2>\n<p>In most cases, the issue causing the message resolves itself, but the notification remains. You can simply close the error message.<\/p>\n<p>The full error message reads:<\/p>\n<blockquote><p>We have detected a problem with some tables in the database. Please contact WPML support to get this fixed.<\/p>\n<p>Array ( he =><\/p><\/blockquote>\n<p>If you can't dismiss the message, you can remove the <code>wpml_notices<\/code> key from the <code>option<\/code> table in your database (by default, this table is called <code>wp_options<\/code>, but <code>wp_<\/code> will be your database's prefix).<\/p>\n<p>If you are still experiencing issues, please follow the workaround provided in our erratum about <a href=\"https:\/\/wpml.org\/he\/errata\/missing-_icl_strings-_icl_string_translations-data-tables\/\">missing the *_icl_strings and *_icl_string_translations data tables<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can solve broken table error messages by bringing the issue to our support team.<\/p>\n","protected":false},"author":228164,"featured_media":0,"menu_order":20,"template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"ep_exclude_from_search":false,"footnotes":""},"faq-category":[26129],"class_list":["post-7405999","faq","type-faq","status-publish","hentry","faq-category-error-messages"],"_links":{"self":[{"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/faq\/7405999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/users\/228164"}],"version-history":[{"count":8,"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/faq\/7405999\/revisions"}],"predecessor-version":[{"id":14352895,"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/faq\/7405999\/revisions\/14352895"}],"wp:attachment":[{"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/media?parent=7405999"}],"wp:term":[{"taxonomy":"faq-category","embeddable":true,"href":"https:\/\/wpml.org\/he\/wp-json\/wp\/v2\/faq-category?post=7405999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}