Problem: We were following your instructions to delete duplicate contents.
Step 1 was successful but in step 2 we got the following error: "#1093 - You can't specify target table 'wp_icl_translations' for update in FROM clause"
Solution: The problem is that MySQL, for whatever reason, doesn't allow you to write queries like this. The solution is to replace the instance of myTable in the sub-query with (SELECT * FROM myTable).
Example code:
DELETE FROM wp_icl_translations
WHERE element_type = 'post_post' AND element_id IN (
SELECT * FROM ( SELECT pm.post_id
FROM wp_postmeta pm
JOIN wp_icl_translations t ON t.element_id = pm.meta_value
WHERE meta_key = '_icl_lang_duplicate_of' AND meta_value > 0 AND t.language_code = 'en' ) AS A
);
Problem: Some of my pages already exist in the 2 languages of my website. I want to link the translations together but some of them have a "translation in progress" status that I can't get rid of.
Solution:
1) Go to the original language page, use a language switcher to switch to the translated page. Then in the sidebar under "Language> This is translation of" section, unlink this page from the original language page. Please check the attached screenshot.
If this option greyed out for you you will need to finish 100% translation for that page.
2) You can then link the correct translated page using the Connect with the translations feature.
Problem:Linking Page (different content) to my Main Language Page
Solution:You were experiencing this issue because there was an empty entry in the database.
Within the database table icl_translations there was a NULL entry for the ES translation of your default language page, therefore since it seemed that the page already had an ES translation it wouldn't allow you to connect the page.
After i removed the NULL entry i was able to connect them by going to
Pages->Declaracion page->Connect with translations->Connect with [en] data-security-... -> and made sure to leave the option to make Spanish the default language unchecked as you want English to remain the default language.
