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

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, 9 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+03: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+03: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+03: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.