Please make sure to update to WPML 4.3.6 and check our list of Known Issues before reporting

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 topic contains 6 replies, has 3 voices.

Last updated by George Botsev 1 year, 2 months ago.

Assigned support staff: George Botsev.

Author Posts
November 4, 2018 at 9:25 pm #2874885

davidA-29

I'm receiving this message on one site.

“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, can you set this thread so I can upload the necessary tables as a zip.

November 5, 2018 at 5:50 am #2875428

Riffaz
Supporter

Languages: English (English )

Timezone: Asia/Colombo (GMT+05:30)

Hi David,

Thank you for contacting WPML support.

This is a common issue.
The solution is explained here: https://wpml.org/errata/missing-_icl_strings-_icl_string_translations-data-tables/

Please follow the steps and let me know the results.

Regards,
Riffaz.

November 5, 2018 at 6:34 am #2875499

davidA-29

Hi, thanks but that's not the issue. The table isn't missing - it's throwing the warning as above. This has happened on other sites, I've exported the string tables for your team to fix.

November 5, 2018 at 7:08 am #2875538

George Botsev
Supporter

Languages: English (English )

Timezone: Europe/Sofia (GMT+02:00)

Hello!
I am George and I am in charge of fixing these kinds of issues.
In order to fix the problem, I would need access to the site in question.
Please make a backup before providing access.
Please do note that I will need to install a plugin like Adminer - from the WordPress repository - so that I can work with the database.
If that plugin cannot work for some reason on your site, I will need to have FTP access for deploying adminer manually.

I am enabling the private reply where you can provide securely credentials - in your next reply.

November 5, 2018 at 7:24 pm #2878160

davidA-29

Hi, I cannot give you direct server access. Please, can I send you the exported _icl_string tables and you send them back fixed? We've done this several times before.

November 6, 2018 at 7:16 am #2879630

George Botsev
Supporter

Languages: English (English )

Timezone: Europe/Sofia (GMT+02:00)

Of course that you can send me just the icl_string* tables.
In order to patch your database we need as a minimum these tables:
-icl_strings
-icl_string_translations
-icl_string_packages
-icl_string_pages
-icl_string_positions
-icl_string_status

November 7, 2018 at 8:09 am #2883992

George Botsev
Supporter

Languages: English (English )

Timezone: Europe/Sofia (GMT+02:00)

Hello again @davida-29
We patched your database and I just sent you an invite from Dropbox for a dropbox folder with the patched database and import manual.
Please follow the manual and if you have problems, please let me know.