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

Hi, Amit here, I am the WPML Support Manager, our current ticket queue is high, update your WPML plugins and make sure you meet the minimal requirements for running WPML before reporting an issue please - many tickets are resolved doing that

Please look at our updated list of Known Issues and you can also use our support search to find helpful information and of course review our documentation before opening a ticket.

If you do need to open a ticket please make sure to provide us with all the needed information as described in this page

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.

Problem:
Clean up the icl_string_translations table to not include the entire WordPress core locales for every language installed. Is this intended behaviour? Can I safely delete the "offending" db rows?

Solution:
- Run the following query on your database:

DELETE FROM `wp_icl_strings` WHERE status = 0;

This topic contains 3 replies, has 2 voices.

Last updated by Andrés 2 years ago.

Assigned support staff: Andrés.

Author Posts
November 8, 2017 at 3:30 pm #1424775

tobiv

I am trying to:
Clean up the icl_string_translations table to not include the entire WordPress core locales for every language installed. Is this intended behaviour? Can I safely delete the "offending" db rows?

Link to a page where the issue can be seen:
(In my database.)

I expected to see:
Reasonable size of table entries. I do not want or need every wordpress core string in the database.

Instead, I got:
Over 20000 rows. I included a screenshot of a random page from phpmyadmin.

Note: I'm not concerned about database size per se, but it makes backups painfully slow. I use BackupBuddy.

November 9, 2017 at 5:32 pm #1426357

Andrés
Supporter

Languages: English (English ) Spanish (Español ) French (Français )

Timezone: Europe/Paris (GMT+01:00)

Hello there,

Welcome to WPML support forum.

You can remove your untranslated strings from your database with a query like the following:

DELETE FROM `wp_icl_strings` WHERE status = 0;

Please, keep in mind of making a full backup of your site before performing this procedure.

Let us know if it helps.
Andrés

November 13, 2017 at 7:54 am #1428509

tobiv

Hi Andrés

November 13, 2017 at 11:57 am #1428806

Andrés
Supporter

Languages: English (English ) Spanish (Español ) French (Français )

Timezone: Europe/Paris (GMT+01:00)

Great! 🙂
Have a nice day,
Andrés