Skip Navigation

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: 

This topic contains 1 reply, has 2 voices.

Last updated by Bruno Kos 10 months, 1 week ago.

Assisted by: Bruno Kos.

Author Posts
May 24, 2023 at 10:08 am #13706017

szymonP-2

Tell us what you are trying to do?
Remove unused rows from icl_translation_status and icl_translate tables when i remove posts.

Is there any documentation that you are following?
This topic- https://wpml.org/forums/topic/heavy-tables-in-database-icl_translation_status-and-icl_translate/

Here is topic i write about https://wpml.org/forums/topic/heavy-tables-in-database-icl_translation_status-and-icl_translate/ - I need SQL query that will clean those tables based of existence of post ID.

If "_icl_translate & _icl_translation_status tables contain a snapshot of the _posts and _postmeta tables" i want to clean them when post is removed

Based on that resolution I need to clean those tables because i removed some of my posts with post_meta. Please provide valid SQL query for that clean. Thanks

May 24, 2023 at 3:11 pm #13709095

Bruno Kos
Supporter

Languages: English (English ) German (Deutsch ) French (Français )

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

Hi,

Thank you for contacting WPML support!

There is no set of queries to offer per se, but we can provide you with a plugin intended for this you can download here:
hidden link

So it is this case:
https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/

Regards,
Bruno Kos

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.