Please, can you help me to understand how to delete all the media translations.
I have many languages and many images.
When "Post Types Translation - Media (attachment)" is "Translatable"
I can see my images on all my languages.
Images are not duplicated on the upload folder but are duplicated on the database.
I need some way to delete all the translations when I delete any image from the main language.
I already try the "When deleting a post, delete translations as well" and don't do the job.
Hello Andreas and thank you for your update.
1.- I can't do manually, we are talking about more than 100K imagenes.
2.- I say the link you share and I also share, but can you detail more about the way to use that? should be added on the function.php or somewhere else? About that code, don't look like an official solution, is that correct?
I will wait for your update.
Thank you in advance.-
WPML will not remove any translated content when deactivating a language or even when deinstalling or even resetting the WPML plugin.
The reset action does not delete translated images, translated posts, and translated taxonomies. It only affects the translation and language information that WPML associates with each content type inside the database.
All pages, posts, taxonomies, and media will need to be removed manually.
Now, we even could run some custom MySQL queries on your database and simply delete any media attachments inside the table wp_posts that are assigned to a different language than the ones you desire to use.
The same we might need to do on the wp_postmeta and the icl_translations tables as well.
Anyhow, as in the following ticket suggested by another user, the recommended way is using the WordPress backend for removing the media content, as each media element that you upload to WordPress is connected to various tables, and running an incomplete query could lead to unexpected DB entries that were missing or forgotten to get removed while running the queries.
