WordPress Database Error in Sitemap

Hello, i found the following error in the debug.log of my site or when i visit the sitemap URL:

WordPress-Datenbank-Fehler Unknown column 'EventStartDate' in 'order clause' für Abfrage SELECT SQL_CALC_FOUND_ROWS DISTINCT dr_posts.ID FROM dr_posts  LEFT JOIN
 dr_term_relationships ON (dr_posts.ID = dr_term_relationships.object_id) LEFT JOIN
 dr_postmeta as tribe_event_end_date ON ( dr_posts.ID = tribe_event_end_date.post_id AND
 tribe_event_end_date.meta_key = '_EventEndDate' )  WHERE 1=1  AND ( 
  dr_term_relationships.term_taxonomy_id IN (134,135,148)

) AND dr_posts.post_type = 'tribe_events' AND (dr_posts.post_status = 'publish' OR
 dr_posts.post_status = 'hidden' OR dr_posts.post_status = 'expired' OR
 dr_posts.post_status = 'archived' OR dr_posts.post_status = 'tribe-ea-success' OR
 dr_posts.post_status = 'tribe-ea-failed' OR dr_posts.post_status = 'tribe-ea-schedule' OR dr_posts.post_status = 'tribe-ea-pending' OR dr_posts.post_status = 'tribe-ea-draft'
 OR dr_posts.post_status = 'private') GROUP BY dr_posts.ID ORDER BY EventStartDate DESC, dr_posts.post_modified DESC LIMIT 0, 1 von require('wp-blog-header.php'), wp, WP->main,
 WP->query_posts, WP_Query->query, WP_Query->get_posts,
 do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters,
 WPSEO_Sitemaps->redirect, WPSEO_Sitemaps->build_sitemap, WPSEO_Sitemaps->build_root_map, WPSEO_Taxonomy_Sitemap_Provider->get_index_links, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

I am not sure if your Plugin creates this broken Query or the Events Calendar Plugin. The Problem ist the “order by EventStartDate”, because it does not exists.

I would be happy, if you can help me finding the source of this error 🙂

• This topic was modified 6 years, 3 months ago by DimaW.