Deleting translated post causes post to disapear from dashboard

Dear Chouby

I just came across a strange error. Deleting translation posts causes the post to disappear from the ‘All posts’ admin dashboard.

While testing the plugin, I created translations for 2 default language posts. Worked fine.

In my ‘All Post’ I have
Post 1 – default language
Post 2 – translated post 1
Post 3 – default language
Post 4 – translated post 3
Post 5 – default language
Post 6 – default language

However, when I deleted Post_2 all the posts with translations disappeared from dashboard, I am now left with:

Post 5 – default language
Post 6 – default language

in other words, even though I deleted only Post_2, Post_1, Post_3 and Post_4 all disappeared.

The ‘All post’ table headers still stays that I have 1 trashed post and 5 published posts, but they these cannot be displayed.

Looking at the my DB, I realised that the table wp_term_taxonomy still has the post_translations taxonomy reference to the deleted post. The table wp_term_relationships still holds a reference of the deleted post ID and the taxonomy ID.

I proceeded to delete those table entries, but it still did not fix the issue.

Finally I deleted all post_trasnlations entries and related relationship rows.

This partially fixed the problem, I now have:

In my ‘All Post’ I have
Post 1 – default language
Post 3 – default language
Post 5 – default language
Post 6 – default language

ie all the default posts, the Post_4 (translation of post_3) does not show up, even though it is still there in the DB.

Any idea how to get a clean delete of translation posts?

kind regards

https://www.ads-software.com/plugins/polylang/