There is a problem with the String Translation table in your site

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.

Tagged: String Translation

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.