PHP error: [07-Dec-2012 23:56:24 UTC] WordPress database error Column 'ID' in where clause is ambiguous for query SELECT p.ID, p.post_author, p.post_date, p.post_content, p.post_title, p.post_status, p.post_name, p.post_type, p.post_author, u.user_nicename AS
author_nicename, u.display_name AS
author_name FROM wp_posts AS p INNER JOIN wp_users AS u ON p.post_author = u.ID WHERE p.post_type = 'post' AND p.post_status = 'publish' AND p.post_password = '' AND ID NOT IN (2542,1735) ORDER BY u.display_name, p.comment_count DESC made by do_action_ref_array, call_user_func_array, SiteTree->rebuild_sitemap, SiteTreeFactory->get_sitemap, SiteTreeHTML5Factory->posts
I am using (with some apprehension) WordPress-SEO (Yoast) to noindex and redirect some "dead wood" posts and anything like that I will usually tell SiteTree to exclude the originating post from the sitemaps.
I also have installed (but will soon be removing) Ultimate Noindex Nofollow Tool II - it no longer seems to work in WP3.42 :( I need a way to noindex a considerable number of "dead wood" posts as I may have requested as a SiteTree Feature.
Also I encountered a blank SiteTree xml sitemap today; I deactivated / reactivated SiteTree and cleared my cache (WP-SuperCache) and the xml sitemap came back. Please do note I had also recently cleared my transient options at that time.
Should the xml sitemap be excluded from caching, and if so what is the proper string to use?