And if you want to hide specific posts, you can mark them as a draft by going to the post listing page selecting all posts that you want to edit and using "Quick Edit" and setting them as "Draft" in the post status.
I disabled all lang from here, hidden link
Then tried to remove translations one by one, hidden link
It doesn't show any progress bar, it just keeps spinning, but after 20 to 30, it stops, and when i check, all the translations are still there. This is why i asked for help from you so that you will help remove all the translations on my site, as your guide to remove translations is not working.
I dont want to keep translated content, so RESET is not what i want, i first want to remove all data then i will reset.
Will you help me here? My site login as well as SSH is already shared. PLease help me remove all the data by WPML inside database, e.g. WPML STRING TRANSLATION PLUGIN DATA, WPML MEDIA PLUGIN DATA, WPML Multilingual CMS PLUGIN DATA, etc
I think that I can help you.
I will login to your site and check right away.
I suspect that the action to remove the language contents fails because there are too many elements - our developers are in the process of improving that in future versions.
We always can do the following as a workaround:
- Re-enable the language (re-add it from WPML > Languages)
- Make sure to disable auto translation for the posts in WPML > Settings > Custom Post Translation section.
- Visit the post type in question (e.g. Products) and switch to the language that we want to remove
- Select the posts in batch of 20 or more (depending on server powers as it might fail again if we overload the limits) and delete them.
Okay, I see the issue. You have more than 10k attachments (Media elements) per language.
This indeed is overloading the logic to delete the posts.
As our policy explicitly forbids me to do destructive actions on a production instance, I can only provide you with SQL queries that you can execute on your MySQL server and that can help with removing the attachments (media elements), and after that is done, perhaps you can try to re-run the same process - but this time it should not fail and should remove the posts.
As usual, I cannot stress enough that this is a highly destructive action and you should have a backup and consider that this is not reversible in any other way.
First, this has to complete without errors in order to not leave orphaned entries:
This removes post-meta attachment information
DELETE
FROM `wp_postmeta`
WHERE `post_id` IN (SELECT `element_id` FROM `wp_icl_translations` WHERE `source_language_code` IS NOT NULL AND `element_type` LIKE 'post_attachment')
Second, this has to complete without errors in order to not leave orphaned entries:
This removes the post entry for the attachment
DELETE
FROM `wp_posts`
WHERE `ID` IN (SELECT `element_id` FROM `wp_icl_translations` WHERE `source_language_code` IS NOT NULL AND `element_type` LIKE 'post_attachment')
Third - remove the entries from the WPML table related to attachments (media elements) only:
DELETE FROM `wp_icl_translations` WHERE `source_language_code` IS NOT NULL AND `element_type` LIKE 'post_attachment'
So after you test the queries and remove the attachments, you can go to WPML > Languages and try again the process to remove the languages from there.
Once you have removed the languages from there, you can do the final procedure - WPML Reset. This should clear all entries that WPML made.
Do note that if you execute the queries with PHPMyAdmin for example, it might fail due to the sheer amount of elements that have to be processed at the same time. So in that case you might have to retry until you get 0 rows affected.
As long as you know what you are doing, there should be no issue running any sql query you gave above. This should not be destructive if command is right.
Do you want me to run all the SQL query from start to end? Or you want to do it? I want you to do it because you are expert in this so you will exactly know what you are doing? I have full backup of server incase anything goes wrong, yo can tell me. But i want you to be sure on what you are doing because we have already wasted alot of time and our business is going down.
I am sorry but I am not allowed to run destructive actions in a production environment.
If you have a staging environment, I can run the queries as proof of the concept for you there, but in the end, it is up to you to decide if you should execute them on your main production site.
I have backup, i can restore from it. I cant waste my time creating staging site, i dont have time. Please understand, and proceed with the task. I want to fast forward the issue. SO please do that.
I am telling you to do because if i did and see any error while running the given query, i will not be able to understand that. So i want you to do it with your expertise.
Think that this is my staging site, and proceed with the cleanup, let me know when you are proceeding?
Please dont take more time because our business is already down from last 3 days, lost 1000s $ of sales.
Unfortunately, I am not allowed to do this on a production site.
I am only allowed to do such changes on testing or on a staging server and doing this on a production site is beyond the scope of what I am permitted and what our support offers to do in general.
I have provided you with the queries which will clear the duplicated media items and the same queries can be adapted for other post types - products, pages, posts & etc.
If you need further assistance with this, perhaps you can hire one of the contractors: https://wpml.org/contractors/
