WordPress database error Duplicate entry '562593-en' for key

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.

This topic is split from https://wpml.org/forums/topic/acf-blocks-are-not-showing-for-translation/

Our wait time is higher than usual, please make sure you are meeting the minimum requirement - https://wpml.org/home/minimum-requirements before you report issues, and if you can take a look at current Known Issues - https://wpml.org/known-issues/. Thank you.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	-
-	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	-

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

Tagged: Bug

This topic contains 7 replies, has 0 voices.

Last updated by Bigul 4 days, 15 hours ago.

Assisted by: Bigul.

Author	Posts
April 2, 2025 at 2:48 pm #16887672
Frameworks AS	``` 591811#0: *9659221 FastCGI sent in stderr: "PHP message: WordPress database error Duplicate entry '562593-en' for key 'trid_lang' for query INSERT INTO `wp_icl_translations` (`element_type`, `language_code`, `trid`) VALUES ('tax_nav_menu', 'en', '562593') made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Nav_Menu->init, WPML_Nav_Menu->_set_menus_language, SitePress->set_element_language_details, WPML_Set_Language->set, WPML_Set_Language->insert_new_row; PHP message: WordPress database error Duplicate entry '562829-en' for key 'trid_lang' for query INSERT INTO `wp_icl_translations` (`element_type`, `language_code`, `trid`) VALUES ('tax_nav_menu', 'en', '562829') made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Nav_Menu->init, WPML_Nav_Menu->_set_menus_language, SitePress->set_element_language_details, WPML_Set_Language->set, WPML_Set_Language->insert_new_row" while reading response header from upstream ``` I'm getting this in the logs constantly
April 2, 2025 at 3:43 pm #16887902
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hello, Welcome to the WPML support forum. I will do my best to help you resolve the issue. It looks like a database issue and is related to the following errata. https://wpml.org/errata/wordpress-database-error-duplicate-entry/ So please run the following query after a full site backup using a tool like PHPMyAdmin. Delete the duplicate entries from the query results. SELECT * FROM wp_icl_translations WHERE trid = 562593 AND language_code = 'en' Refer to this similar ticket for more details: https://wpml.org/forums/topic/duplicate-entry-2028-en-for-key-trid_lang/page/2/#post-8232421 Please note that the same issue may occur with a different trid. In that case, change the query and run it again until the issue is resolved. -- Thanks! Bigul
April 3, 2025 at 10:24 am #16891277
Frameworks AS	MySQL returned an empty result set (i.e. zero rows). (Query took 0.0001 seconds.)
April 3, 2025 at 10:41 am #16891448
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hello, Thank you for the updates. This may require further debugging. Therefore, are you still getting this error in the Debug.log? If so, please let us know the exact steps to reproduce the issue on your site. It will help us a lot in testing, and we will troubleshoot this error with the main ticket. -- Thanks! Bigul
April 3, 2025 at 11:28 am #16891661
Frameworks AS	The website is slowing down now the database is getting full, WPML will not stop. The issue is unknown, the database is just getting spammed by WPML adding tax_nav_menu to the translations and incrementing the ID of them. we're at 2 million in IDs now
April 3, 2025 at 1:18 pm #16892581
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hello, Thank you for the updates. Please try the following troubleshooting steps after a full site backup{mandatory} and check if there is any difference in the result. 1) Visit WPML>>Translation Management and disable the automatic translation of Advanced Translation Editor 2) Go to WPML>>Support page, click on the Troubleshooting link (blue link in the middle of the page) 3) On the Troubleshooting page, please click on the following options of the Clean up section. Wait for confirmation of processing after each one. - Clear the cache in WPML - Remove ghost entries from the translation tables - Fix element_type collation - Set language information - Fix WPML tables collation - Assign translation status to duplicated content - Fix terms count - Fix post type assignment - Cleanup and optimize string tables -- Thanks! Bigul
April 4, 2025 at 10:32 am #16896816
Frameworks AS	All of the above didn't solve the issue.
April 4, 2025 at 6:15 pm #16898723
Bigul Supporter Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hello, Thank you for the updates. To make sure it happens randomly, am I correct? Please confirm. Please share the Debug.log file for further checking. You can share it via Google Drive or Dropbox. -- Thanks! Bigul