Skip Navigation

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client reported that the website's language switcher was not functioning properly.
Solution:
We recommended clearing the WPML caches through WPML>>Support>>Troubleshooting and resaving the Elementor Header template along with the WPML Language switcher settings from WPML>>Languages. Additionally, we noted that the Homepage was not showing the language switchers because it had not been translated into secondary languages yet.

If this solution does not resolve your issue, or if it seems outdated or irrelevant to your case, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. Should you need further assistance, please do not hesitate to open a new support ticket at WPML support forum.

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.

Tagged: 

This topic contains 5 replies, has 2 voices.

Last updated by Bigul 8 months, 3 weeks ago.

Assisted by: Bigul.

Author Posts
August 1, 2024 at 4:57 pm #16030851

Thomas

In addition, I found that the website's language switcher seemed to be out of action and could not provide the switching function properly.

Thanks.

16027801-E709F74A_FAD3_426D_98BA_2AEB549F20C2.png
16027801-F55DB6A4_2BD9_4321_9D88_BE116B5622C6.png
August 1, 2024 at 4:59 pm #16030881

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

Welcome to the WPML support forum. I will do my best to help you to resolve the issue.

This looks like a compatibility conflict. I will debug it further locally and get back to you as soon as possible. Please wait.

--
Thanks!

Bigul

August 2, 2024 at 4:51 pm #16034283

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

I am getting the expected results (for Header and Footer Language switchers) after clearing the WPML Caches (WPML>>Support>>Troubleshooting) and resaving the Elementor Header template and WPML Language switcher settings (from WPML>>Languages).

The Homepage is not showing the language switchers because it has not been translated into secondary languages yet.

Please check the attached images for more details and the following URLs for more details and let us know your feedback.

hidden link

hidden link

--
Thanks!

Bigul

2024-08-02_22h19_42.png
2024-08-02_22h19_09.png
2024-08-02_22h14_43.png
2024-08-02_22h14_16.png
August 4, 2024 at 2:16 am #16036023
Thomas

Hi Bigul,

Based on your suggestion, I have created English and German translation pages for the homepage.

However, even though I completed the translation process, the translated content does not appear on the webpage. It looks like the page is created, but the content is not loaded.

How should I troubleshoot this issue?

New threads created by Bigul and linked to this one are listed below:

https://wpml.org/forums/topic/translated-content-does-not-appear-on-the-webpage/

00F4DCD7-F94E-40A6-B70D-2D0D06CDB1D2.png
196B008E-9314-4F21-A89C-C2944026C172.png
3A68C41C-FAAC-4DFD-A784-C4C734F9561A.png
August 4, 2024 at 2:18 am #16036067
Thomas

And I get some messages from debug.log as listed below:

[04-Aug-2024 02:08:00 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = 'titelseite'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\PublicReceive->receive_ate_job, WPML\FP\Just->chain, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Just->ap, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\TM\API\ATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:00 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
							SELECT ID FROM wp_posts p
							JOIN wp_icl_translations t
								ON t.element_id = p.ID AND t.element_type='post_any'
							WHERE post_name='titelseite' AND post_type='any' AND t.language_code='de'
							LIMIT 1
						 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\PublicReceive->receive_ate_job, WPML\FP\Just->chain, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Just->ap, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\TM\API\ATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query
[04-Aug-2024 02:08:01 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = 'titelseite-2'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\PublicReceive->receive_ate_job, WPML\FP\Just->chain, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Just->ap, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\TM\API\ATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Page_Builders_Hooks->pro_translation_completed_action, WPML_TM_Page_Builders->pro_translation_completed_action, do_action('wpml_pb_finished_adding_string_translations'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_PB_Integration->save_translations_to_post, WPML_PB_Integration->with_strategies, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML_PB_Integration->{closure}, WPML_PB_String_Translation_By_Strategy->save_translations_to_post, WPML_PB_Update_Post->update, WPML_PB_Update_Post->update_post, WPML_PB_Update_API_Hooks_In_Content->update, do_action('wpml_page_builder_string_translated'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Elementor_Data_Settings->save_post_body_as_plain_text, WPML_Elementor_DB->save_plain_text, Elementor\DB->save_plain_text, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:01 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'page' AND  p.post_name = '催化劑'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\PublicReceive->receive_ate_job, WPML\FP\Just->chain, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Just->ap, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\TM\API\ATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Page_Builders_Hooks->pro_translation_completed_action, WPML_TM_Page_Builders->pro_translation_completed_action, do_action('wpml_pb_finished_adding_string_translations'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_PB_Integration->save_translations_to_post, WPML_PB_Integration->with_strategies, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML_PB_Integration->{closure}, WPML_PB_String_Translation_By_Strategy->save_translations_to_post, WPML_PB_Update_Post->update, WPML_PB_Update_Post->update_post, WPML_PB_Update_API_Hooks_In_Content->update, do_action('wpml_page_builder_string_translated'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Elementor_Data_Settings->save_post_body_as_plain_text, WPML_Elementor_DB->save_plain_text, Elementor\DB->save_plain_text, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Sticky_Links->save_default_urls, AbsoluteLinks->process_post, AbsoluteLinks->convert_text, AbsoluteLinks->_process_generic_text, url_to_postid, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:01 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = '8931-revision-v1'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\PublicReceive->receive_ate_job, WPML\FP\Just->chain, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Just->ap, WPML\FP\Just->map, WPML\FP\{closure}, call_user_func_array, WPML\TM\API\ATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Page_Builders_Hooks->pro_translation_completed_action, WPML_TM_Page_Builders->pro_translation_completed_action, do_action('wpml_pb_finished_adding_string_translations'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_PB_Integration->save_translations_to_post, WPML_PB_Integration->with_strategies, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML_PB_Integration->{closure}, WPML_PB_String_Translation_By_Strategy->save_translations_to_post, WPML_PB_Update_Post->update, WPML_PB_Update_Post->update_post, WPML_PB_Update_API_Hooks_In_Content->update, do_action('wpml_page_builder_string_translated'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Elementor_Data_Settings->save_post_body_as_plain_text, WPML_Elementor_DB->save_plain_text, Elementor\DB->save_plain_text, wp_update_post, wp_insert_post, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:02 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = 'titelseite-2'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:02 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
							SELECT ID FROM wp_posts p
							JOIN wp_icl_translations t
								ON t.element_id = p.ID AND t.element_type='post_any'
							WHERE post_name='titelseite-2' AND post_type='any' AND t.language_code='de'
							LIMIT 1
						 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = '8931-revision-v1'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_update_post, wp_insert_post, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
							SELECT ID FROM wp_posts p
							JOIN wp_icl_translations t
								ON t.element_id = p.ID AND t.element_type='post_any'
							WHERE post_name='8931-revision-v1' AND post_type='any' AND t.language_code='de'
							LIMIT 1
						 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_update_post, wp_insert_post, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = 'titelseite-2'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
							SELECT ID FROM wp_posts p
							JOIN wp_icl_translations t
								ON t.element_id = p.ID AND t.element_type='post_any'
							WHERE post_name='titelseite-2' AND post_type='any' AND t.language_code='de'
							LIMIT 1
						 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, WPML_Create_Post_Helper->insert_post, wp_update_post, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'page' AND  p.post_name = '催化劑'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Page_Builders_Hooks->pro_translation_completed_action, WPML_TM_Page_Builders->pro_translation_completed_action, do_action('wpml_pb_finished_adding_string_translations'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_PB_Integration->save_translations_to_post, WPML_PB_Integration->with_strategies, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML_PB_Integration->{closure}, WPML_PB_String_Translation_By_Strategy->save_translations_to_post, WPML_PB_Update_Post->update, WPML_PB_Update_Post->update_post, WPML_PB_Update_API_Hooks_In_Content->update, do_action('wpml_page_builder_string_translated'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Elementor_Data_Settings->save_post_body_as_plain_text, WPML_Elementor_DB->save_plain_text, Elementor\DB->save_plain_text, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Sticky_Links->save_default_urls, AbsoluteLinks->process_post, AbsoluteLinks->convert_text, AbsoluteLinks->_process_generic_text, url_to_postid, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'page' AND  p.post_name = '催化劑'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Page_Builders_Hooks->pro_translation_completed_action, WPML_TM_Page_Builders->pro_translation_completed_action, do_action('wpml_pb_finished_adding_string_translations'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_PB_Integration->save_translations_to_post, WPML_PB_Integration->with_strategies, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML_PB_Integration->{closure}, WPML_PB_String_Translation_By_Strategy->save_translations_to_post, WPML_PB_Update_Post->update, WPML_PB_Update_Post->update_post, WPML_PB_Update_API_Hooks_In_Content->update, do_action('wpml_page_builder_string_translated'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Elementor_Data_Settings->save_post_body_as_plain_text, WPML_Elementor_DB->save_plain_text, Elementor\DB->save_plain_text, wp_update_post, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Sticky_Links->save_default_urls, AbsoluteLinks->process_post, AbsoluteLinks->convert_text, AbsoluteLinks->_process_generic_text, url_to_postid, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB
[04-Aug-2024 02:08:03 UTC] WordPress database error Column 'ID' in field list is ambiguous for query 
				SELECT ID
				 FROM wp_posts p
	             JOIN wp_icl_translations wpml_translations
					ON p.ID = wpml_translations.element_id
						AND wpml_translations.element_type = CONCAT('post_', p.post_type )  WHERE p.post_type = 'any' AND  p.post_name = '8931-revision-v1'
				ORDER BY p.post_parent = 0 DESC
				 made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\TM\ATE\REST\Download->download, WPML\TM\ATE\Download\Process->run, WPML\Collect\Support\Collection->map, array_map, WPML\TM\ATE\Download\Process->WPML\TM\ATE\Download\{closure}, WPML\TM\ATE\Download\Consumer->process, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_TM_Page_Builders_Hooks->pro_translation_completed_action, WPML_TM_Page_Builders->pro_translation_completed_action, do_action('wpml_pb_finished_adding_string_translations'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_PB_Integration->save_translations_to_post, WPML_PB_Integration->with_strategies, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML\FP\Fns::__callStatic, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, array_map, WPML\FP\{closure}, call_user_func_array, WPML\FP\Fns::WPML\FP\{closure}, WPML_PB_Integration->{closure}, WPML_PB_String_Translation_By_Strategy->save_translations_to_post, WPML_PB_Update_Post->update, WPML_PB_Update_Post->update_post, WPML_PB_Update_API_Hooks_In_Content->update, do_action('wpml_page_builder_string_translated'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Elementor_Data_Settings->save_post_body_as_plain_text, WPML_Elementor_DB->save_plain_text, Elementor\DB->save_plain_text, wp_update_post, wp_insert_post, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, wp_add_trashed_suffix_to_post_name_for_trashed_posts, get_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array('parse_query'), WP_Hook->do_action, WP_Hook->apply_filters, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_Name_Query_Filter->filter_page_name, WPML_Name_Query_Filter->query_needs_adjustment, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs, WPML_Name_Query_Filter->get_single_slug_adjusted_IDs_from_DB

New threads created by Bigul and linked to this one are listed below:

https://wpml.org/forums/topic/wordpress-database-error-column-id-in-field-list-is-ambiguous-for-query/

August 5, 2024 at 7:11 am #16037637

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

Thank you for the feedback. I have added new tickets for it and get back to you soon on the latest tickets. Please wait.

--
Thanks!

Bigul