Skip Navigation

Home › Support › English Support › [Resolved] WordPress database error Column 'ID' in field list is ambiguous for query

[Resolved] WordPress database error Column 'ID' in field list is ambiguous for query

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

Problem:
The client is experiencing database errors indicating that the 'ID' column in the field list is ambiguous during queries involving WPML translations and Elementor page builder. This issue persists even after reinstallation of Elementor.
Solution:
We identified that the issue stems from a conflict in the database where the 'icl_translations' table incorrectly includes an unknown column named 'id'. To resolve this, we recommend:
1. Performing a full site backup to ensure data safety.
2. Removing the erroneous 'id' column from the 'wp_icl_translations' table.
3. Running the following SQL query to adjust the 'translation_id' column:

ALTER TABLE wp_icl_translations CHANGE translation_id translation_id BIGINT NOT NULL AUTO_INCREMENT;

If this solution does not resolve the issue or seems irrelevant due to being outdated or not applicable to your case, please check related known issues at https://wpml.org/known-issues/, verify the version of the permanent fix, and confirm that you have installed the latest versions of themes and plugins. We highly recommend opening a new support ticket for further assistance 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.

This topic is split from https://wpml.org/forums/topic/language-switcher-seemed-to-be-out-of-action/

Tagged: 

This topic contains 7 replies, has 2 voices.

Last updated by Bigul 9 months ago.

Assisted by: Bigul.

Author Posts
August 5, 2024 at 6:56 am #16037568

Thomas

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, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->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, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->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, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->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, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, array_map, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{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, ElementorDB->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, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->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, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, array_map, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{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, ElementorDB->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, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->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, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, array_map, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{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, ElementorDB->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, array_map, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{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, ElementorDB->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, array_map, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{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, ElementorDB->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, WPMLTMATERESTDownload->download, WPMLTMATEDownloadProcess->run, WPMLCollectSupportCollection->map, array_map, WPMLTMATEDownloadProcess->WPMLTMATEDownload{closure}, WPMLTMATEDownloadConsumer->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, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPFns::__callStatic, call_user_func_array, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, array_map, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{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, ElementorDB->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
August 5, 2024 at 7:38 am #16037744

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.

Does it happen when you edit the pages, for example, the Homepage in the default language using Elementor Editor? It would be great if we get the exact steps to reproduce the issue.

--
Thanks!

Bigul
August 5, 2024 at 7:58 am #16037825

Thomas

Hi Bigul,

When I use Elementor Editor to edit the homepage, there is no glitch. Then I add translation pages in different languages. Some of the previously translated text will appear in the translation page, and some of the translated blocks will disappear, and the translation will be replenished. After texting and saving the screen, the translated webpage did not display the content normally.

After I removed Elementor and reinstalled Elementor, nothing changed.

Thank you.

Thomas
August 5, 2024 at 9:36 am #16038585

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

Thank you for the updates. Hope you are updating the Page Translations using the WPML Advanced Translation Editor.

Please share a screencast (screen capture of the issue) for a better understanding. It will help us a lot in our internal communication. You can share it via Google Drive or Dropbox.

--
Thanks!

Bigul
August 6, 2024 at 2:14 am #16042342

Thomas

Hi Bigul,

I tried to record the operation process and put it on Google Drive as listed below for your convenience.

hidden link

Thank

Thomas
August 6, 2024 at 9:40 am #16043297

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

Thank you for the updates and the screencast. According to the screencast, you are following the correct steps. I will debug it further with the other issue and get back to you soon. Please wait.

--
Thanks!

Bigul
August 6, 2024 at 4:37 pm #16044895

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

I have reproduced the following DB error locally. The issue persists after the initial troubleshooting steps, so I am consulting with our team for an expert opinion. We will get back to you as soon as possible. Please wait.

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, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->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

--
Thanks!

Bigul
August 7, 2024 at 2:49 pm #16048702

Bigul
WPML Supporter since 01/2013

Languages: English (English )

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

Hi Thomas,

This error is happening because of a conflict in the database. Somehow the `icl_translations` table is showing an unknown column called `id`. It should not be there. Please check the attached image.

So, please delete this column `id` after a full site backup and also run the following query. Then make sure the issue exists or not."

ALTER TABLE `wp_icl_translations` CHANGE `translation_id` `translation_id` BIGINT NOT NULL AUTO_INCREMENT;

--
Thanks!

Bigul

wpmltriage-1875.png