Skip to content Skip to sidebar

Home › Support › English Support › [Assigned] Disfunctional translation

[Assigned] Disfunctional translation

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 7:00 – 12:00 7:00 – 12:00 7:00 – 12:00 7:00 – 12:00 7:00 – 12:00 -
- 13:00 – 15:00 13:00 – 15:00 13:00 – 15:00 13:00 – 15:00 13:00 – 15:00 -

Supporter timezone: Europe/Madrid (GMT+02:00)

Tagged: 

This topic contains 20 replies, has 0 voices.

Last updated by Dan 3 hours, 58 minutes ago.

Assisted by: Carlos Rojas.

Author Posts
August 20, 2025 at 12:46 pm #17334283

Dan

and here are a couple of debug.log items that could be relevant:

[19-Aug-2025 11:03:01 UTC] WordPress database error Duplicate entry '22505-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '38607' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 11:03:01 UTC] WordPress database error Duplicate entry '24388-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43376' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 11:03:01 UTC] WordPress database error Duplicate entry '26442-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48988' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 11:03:04 UTC] WordPress database error Duplicate entry '26441-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48987' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 11:03:04 UTC] WordPress database error Duplicate entry '24328-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '51720' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 11:03:05 UTC] WordPress database error Duplicate entry '24381-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43375' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 12:50:06 UTC] WordPress database error Duplicate entry '22505-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '38607' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 12:50:06 UTC] WordPress database error Duplicate entry '24388-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43376' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 12:50:06 UTC] WordPress database error Duplicate entry '26442-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48988' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 12:50:09 UTC] WordPress database error Duplicate entry '26441-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48987' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 12:50:10 UTC] WordPress database error Duplicate entry '24328-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '51720' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 12:50:10 UTC] WordPress database error Duplicate entry '24381-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43375' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[19-Aug-2025 15:53:28 UTC] [PublishPress Authors] Warning - The author_id is empty so the link for the author page was changed to the home URL.
[20-Aug-2025 09:50:11 UTC] WordPress database error Duplicate entry '22505-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '38607' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 09:50:12 UTC] WordPress database error Duplicate entry '24388-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43376' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 09:50:12 UTC] WordPress database error Duplicate entry '26442-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48988' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 09:50:15 UTC] WordPress database error Duplicate entry '26441-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48987' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 09:50:15 UTC] WordPress database error Duplicate entry '24328-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '51720' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 09:50:15 UTC] WordPress database error Duplicate entry '24381-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43375' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 10:19:54 UTC] WordPress database error Duplicate entry '22505-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '38607' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 10:19:54 UTC] WordPress database error Duplicate entry '24388-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43376' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 10:19:55 UTC] WordPress database error Duplicate entry '26442-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48988' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 10:19:57 UTC] WordPress database error Duplicate entry '26441-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '48987' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 10:19:57 UTC] WordPress database error Duplicate entry '24328-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '51720' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
[20-Aug-2025 10:19:58 UTC] WordPress database error Duplicate entry '24381-en' for key 'wp_icl_translations.trid_lang' for query UPDATE `wp_icl_translations` SET `language_code` = 'en' WHERE `translation_id` = '43375' made by include('/plugins/sitepress-multilingual-cms/menu/troubleshooting.php'), TranslationManagement->add_missing_language_information, TranslationManagement->add_missing_language_to_posts, TranslationManagement->add_missing_language_to_post
August 21, 2025 at 7:41 am #17336185

Carlos Rojas
WPML Supporter since 03/2017

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Hi Henri,
Thank you very much for sharing this information

There is a known issue with an erratum page describing this problem: https://wpml.org/errata/wordpress-database-error-duplicate-entry/

To solve this database problem, I kindly ask you to run the following query in the database:

DELETE FROM `wp_postmeta`
WHERE `meta_key` = '_icl_lang_duplicate_of';
DELETE FROM `wp_icl_translations`
WHERE `language_code` = '';

And then double-check if the problem has disappeared.
August 21, 2025 at 10:24 am #17336910

Dan

Thanks Carlos,

I have done that:
mysql> DELETE FROM wp_postmeta WHERE meta_key = '_icl_lang_duplicate_of';
Query OK, 13 rows affected (0.00 sec)

mysql> DELETE FROM wp_icl_translations WHERE language_code = '';
Query OK, 6 rows affected (0.08 sec)

And flushed the database cache to be sure we are looking at the right thing:
/var/www/html# wp cache flush
Success: The cache was flushed.

that didnt fix the issue.

Then I did the earlier troubleshooting steps on:
hidden link

- clear the cache in WPML
- remove ghost entries from translation tables
- set language information
- fix post type assignment for translations -> Post type and source language assignment have been fixed for 130 elements
- fix WPML translation jobs "tp_id_field"
- fix element_type collation
- fix wpml tables collation

Result:
This has definitely fixed the issue when you click on "Modifier la traduction" and you will see that it will keep staying on the same page but the url slightly changes to hidden link

Also, the translation editor seems now to work almost, except that it contains English instead of French content in the right column, see the editor hidden link

and see the correct French display on the frontend: hidden link

Most importantly I think the page "2023 Year in Review" should not be in the "Needs translation" status.

At last, but not least, I am trying to understand if that issue isn't just existing on some specific pages and that it's not a larger/global issue. In such a case it would be best to recreate the affected pages -> just not easy to figure out if that's the case.

My next step would also be trying to switch to the advanced editor in the settings. What do you think? Can you try that and see what happens?

Thanks again!
August 21, 2025 at 10:37 am #17337007

Carlos Rojas
WPML Supporter since 03/2017

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Hi,

Please create the credentials again and share them in your next message, which I have set private. After restoring the database, I can't access the site 🙂
August 21, 2025 at 11:28 am #17337125

Carlos Rojas
WPML Supporter since 03/2017

Languages: English (English ) Spanish (Español )

Timezone: Europe/Madrid (GMT+02:00)

Hello again,

I double-checked the translation for hidden link and it seems the page wasn't originally translated with the Translation Editor, or that the problem in the database affected this (or these) page.

If you create a new test page and translate it to all languages, does the issue appears again?
August 21, 2025 at 12:15 pm #17337328

Dan

yes new pages seem indeed to work - I have tested this once more - but that's not really the problem we are trying to solve.

The question is how we can fix this for all the old pages that were translated with the old translation editor?

Is there a way to identify them so that we could, if there are not too many of them, eventually fix them by recreating them manually?

Or: is there a way to switch back to the old translation editor?