I’m using WPML and did duplicate all posts and pages for another language and then got overwritten the content when the original is saved. And now I know that I need to set to ‘Translate Independently’ each post/page to avoid the overwritten.
However, I have more than 100 posts and page so I should delete all of them by SQL command via phpmyadmin rather update the Translate Independently one by one.
Delete All Translate Independently In WPML
When duplicate a post, it creates a mete key ‘_icl_lang_duplicate_of’ in the post meta table, you can verify by running this SQL:
SELECT * FROM `vnw_postmeta` WHERE meta_key='_icl_lang_duplicate_of'; |
So to delete all Translate Independently, you can run this SQL:
DELETE FROM `vnw_postmeta` WHERE meta_key='_icl_lang_duplicate_of'; |
Note:
- 1. You will need to replace my database table prefix ‘vnw_’ with yours.
- 2. Please backup your database before running any SQL command.