Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home Tips And Tricks WPML Delete All Translate Independently

WPML Delete All Translate Independently

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

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

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.
Sep 21, 2014Hoan Huynh
Google Email Domain Does Not Designate Permitted Sender HostsJQuery Dialog Hide Or Remove Close Button
You Might Also Like:
  • How To Track Website With Multiple Google Analytisc Accounts
  • Facebook Like Button And Recommend Button With fb:like, iframe and html5
  • Delete Bulk Draft And Trash WordPress Posts Includes All Tags, Comments, Meta Fields And Terms Associated
  • PHP Delete File Function
  • Delete WordPress Revision Posts, Its Relationships And Meta Data
  • Auto Delete Old IIS Logs, FTP Logs, SMTP Logs In Windows
  • WordPress Delete Unused Post Tags By SQL Command
  • PHP Completely Delete A Directory Include Sub Directories And Files
  • How To Delete Application In Facebook Developers
  • JavaScript Get Radio Button Value
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

6 years ago Tips And Tricks_icl_lang_duplicate_of, WPML455
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
21,931 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
19,760 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
15,595 views
JQuery Allow only numeric characters or only alphabet characters in textbox
13,112 views
C# Read Json From URL And Parse/Deserialize Json
9,564 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Essay Writing Service Tips For The Online Essay
  • Research Paper Writing Service
  • Annotated Bibliography Example – How it Can Help You
  • Essay Writing Online Tips – How to Write Essays Online With Essay Proof Editing
  • Get Research Paper Assistance From Professional Help
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (28)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (64)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development