WordPress database error thrown on sitemap.xml

Good day,

When accessing our website’s sitemap.xml, I receive this error message:

[14-Nov-2022 21:26:24 UTC] WordPress database error Unknown column 'modified' in 'order clause' for query 
					SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id
					WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (25,27,178,189,191,218,219,220,222)
) AND ( 
  wp_tec_occurrences.post_id IS NOT NULL 
  AND 
  CAST(wp_tec_occurrences.end_date AS DATETIME) >= '2022-11-14 15:26:24'
) AND ((wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'tribe-ea-success' OR wp_posts.post_status = 'tribe-ea-failed' OR wp_posts.post_status = 'tribe-ea-schedule' OR wp_posts.post_status = 'tribe-ea-pending' OR wp_posts.post_status = 'tribe-ea-draft')))
					GROUP BY wp_tec_occurrences.occurrence_id
					ORDER BY modified DESC, CAST(wp_tec_occurrences.start_date AS CHAR) ASC, post_date ASC
					LIMIT 0, 1
				 made by 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, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, TEC\Events\Custom_Tables\V1\WP_Query\Modifiers\Events_Only_Modifier->filter_posts_pre_query, TEC\Events\Custom_Tables\V1\WP_Query\Custom_Tables_Query->get_posts, WP_Query->get_posts

We also have Yoast SEO enabled on the site. The error log seems to indicate the issue is originating from The Event Calender, but I’m not 100% sure which plugin is ultimately causing the issue. Please let me know what additional data I can provide to help troubleshoot.

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

The page I need help with: [log in to see the link]