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
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