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 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 3 replies, has 2 voices.

Last updated by Andrés 2 years, 7 months 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+02: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+02:00)

Great! 🙂
Have a nice day,
Andrés