WPML is telling me that it has a broken table that needs fixing

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

This thread is resolved. Here is a description of the problem and solution.

We are no longer responding here in this ticket.

If you have the message:

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 create a new ticket in our forum.

If you have message like this one:

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

Array ( [language] =>

Please visit our errata page here: https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

That issue can be resolved by using the [x] button in the upper right corner of the message to close and dismiss that message.

Do you have issues dismissing that message? If you do - then you can try to remove the key "wpml_notices" from the option table(by default wp_options, where "wp_" is your database prefix).

23% of people find this useful.

Tagged: Install and update, WPML All Import

This topic contains 2,053 replies, has 575 voices.

Last updated by Jan 3 weeks, 6 days ago.

Assigned support staff: George Botsev.

Author	Posts
September 1, 2017 at 7:45 am #1355750
Amir Supporter	WPML 3.8 includes major updates to the String Translation tables. As part of this, we rely on indexes that were supposed to be there already. We learned that in some sites, these indexes are missing and cannot be created automatically because of data conflicts. We know how to fix this, but it's something that needs to be done with a lot of care. If you got this message, please add a comment here. We'll contact you, get a backup of your site, test the migration logic and make sure that it's working for you. Note: You might encounter a false positive where this message appears, but it is a separate issue. You should check if you have the table "icl_strings" - e.g. "wp_icl_strings" (if your WordPress prefix is "wp_") and if you don't have that table - then you can follow the guide https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/ to re-create the missing tables. Once the tables are re-created, you can then remove the key "wpml_string_table_ok_for_mo_import" from the option table(by default wp_opions, where "wp_" is your database prefix). Please do note, in order to protect your data, when we send you your patched databases - we send an invite to your WPML profile e-mail for a shared folder via Dropbox. That link is available only to that e-mail and it will not work with another e-mail. If you need the folder to be shared to another e-mail, just add it to the official ticket here with your database. Screen Shot 2017-09-04 at 11.00.13.png
September 4, 2017 at 8:46 am #1357076
julienF-5	Hello Team Since update on my dev version, I have this warning message : 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. Can you help me Thx Regards
September 4, 2017 at 8:52 am #1357080
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	Hello @julienf-5 and thank you for contacting us. In order to confirm and give you steps on how to fix the problem, and that there are no other issues with your database, we would need a database dump or export with the plugin "Duplicator" of your site. I am enabling a private reply for your next reply so that you can share that information with us securely and privately.
September 4, 2017 at 9:55 am #1357340
pabloQ	Hi there, I do have the same problem. Won't be able to use Duplicator as it's not compatible with my page builder. But I can make a manual DB and files backup if that's OK. How may I proceed?
September 4, 2017 at 11:18 am #1357580
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	Hello @pabloq Manual database export (dump) is also just fine. I am activating the private reply for your next post. You can upload it to a dropbox, google drive, private hosting or whenever you want and just share the link to the dump.
September 4, 2017 at 4:21 pm #1358316
david	Hello I have this message on my site? = hidden link This client is using godaddy stupid wp manager and i cant do anything with it... so now what?
September 4, 2017 at 4:24 pm #1358319
david	Hello again.. ref to = hidden link Going to have to remove the plugin as its not looking good on the site, but i need it working to get on with the work.. i am removing the wpml string translation plugin, Whats the next step? Kind regards MY Bad, its this message you need ? 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.
September 4, 2017 at 5:37 pm #1358446
ideaspace	Hi there, I do have the same problem. Please help me on this.
September 5, 2017 at 6:58 am #1359089
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	@david and @rondap - if you have that message, it is required for us to check your site in order to verify the problem and if there is also other problems too. For this, I would need a database export or a site dump created by the Duplicator plugin. If you find this hard - you can just give me access to your site and FTP and I will do it. When I get that - I will verify the problem and I can then fix it on your site, so credentials are also welcome. I am activating the private reply for your next reply so that you can share the information privately and securely.
September 5, 2017 at 7:03 am #1359099
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	@pabloq - thank you for the database dump. I will analyze the problems and contact our developers and get back to you as soon as we have completed the analysis.
September 5, 2017 at 9:14 am #1359395
leopoldR	Hello, I am getting this error message aswell. Best regards Leopold
September 5, 2017 at 9:29 am #1359422
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	@leopoldr Hello Leopold. As I mentioned to the other people here, we need to verify the problem. So, I am activating the private reply, where you can share credentials, Duplicator package link or database dump.
September 5, 2017 at 11:23 am #1359705
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	@julienf-5 thank you for providing the database dump. I will consult with our devs and get back to you.
September 5, 2017 at 12:11 pm #1359859
George Botsev Supporter Languages: English (English ) Timezone: Europe/Sofia (GMT+03:00)	@leopoldr the link that you send returns error 404 not found.
September 5, 2017 at 2:02 pm #1360211
julienB-5	Dear, I have the same problem: 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. regards