The associated translation of a page is disappearing in WPML

Have you ever faced associated translation of a page disappearing in WPML? If you have are facing this problem and have to this page for a solution then chances are that the solution presented here will help you just like it helped us.

Our scenario: We added Spanish translation to translation jobs under the “Translation Management” section of WPML plugin. Later on we deleted the translation job and didn’t realize that this will cause translation of a page disappearing in WPML later on.



Once started translating the pages using “WPML’s Classic Translation Editor” then pages for Spanish language started disappearing as soon as we would click on Duplicate button.

WPML's Classic Translation Editor

After going through WPML settings numerous times and searching through Google for hours finally we found a clue to fix the problem. What happened is that when we deleted the translation from the translations jobs then WPML added some NULL values in the wp_icl_translations table.  The solution was to sort the “element_id” column in ascending order to get all the NULL values for the “element_id” column. Next was to select all the rows having NULL values for column “element_id” and delete them.



Try this solution carefully as you might get to other problems if you don’t know this much technical stuff. Luckily we were on wpengine hosting so first we created a staging site, applied the solution there and once we confirmed that the solution works then we applied it to live site as well.

Hope this solution helps some of you to fix the problem of associated translation of a page disappearing in WPML.

40 Comments

  • Set Stock price alerts for your portfolio and view list and get them delivered to your e-mail box. Mechelle Delmer Ehrsam
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • I think you have noted some very interesting details , appreciate it for the post. Althea Benson Regina
  • This also results in a foremost sensation of tiredness most of the time which manifests itself differently. Elvira Bat Amarillas
  • Mijn kinderen zijn dol op zulke boekjes daarom doe ik super graag mee voor ze. Stacee Burl Elyn
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • There is apparently a bunch to realize about this. I consider you made certain good points in features also. Keeley Aldo Ruprecht
  • These are genuinely impressive ideas in regarding blogging. Vilma Ellis Merce
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!
  • You made some nice points there. I looked on the internet for the subject matter and found most individuals will agree with your site.
  • Real Estate Agent houses for sale selling your home Dori Brandow
  • I really liked your blog post.Much thanks again. Will read on… Abram Lacava
  • A quality site is really satisfying, you are doing great work
  • I am glad for writing to make you know what a incredible encounter my friend's girl gained studying your web site. She learned plenty of pieces, which include what it's like to possess an awesome helping nature to let other folks very easily know just exactly several multifaceted subject matter. You truly exceeded people's expectations. Thank you for presenting these powerful, safe, explanatory and in addition fun tips about this topic to Julie.

Leave a comment