Recurring WordPress database error message in PHP Error Log

Hello TEC Community,

Over the Christmas holiday several of our automated backups failed because our host’s disk storage space had been filled with the following recurring error:

[29-Dec-2022 12:52:32 UTC] WordPress database error Unknown column '**db_name**_tec_occurrences.occurrence_id' in 'group statement' for query
                                        SELECT SQL_CALC_FOUND_ROWS  **db_name**_posts.ID
                                        FROM **db_name**_posts  LEFT JOIN **db_name**_term_relationships ON (**db_name**_posts.ID = **db_name**_term_relationships.object_id)
                                        WHERE 1=1  AND (
  **db_name**_posts.ID NOT IN (
                                SELECT object_id
                                FROM **db_name**_term_relationships
                                WHERE term_taxonomy_id IN (7,9)
                        )
  AND
  **db_name**_term_relationships.term_taxonomy_id IN (1617)
) AND ((**db_name**_posts.post_type = 'tribe_events' AND (**db_name**_posts.post_status = 'publish' OR **db_name**_posts.post_status = 'acf-disabled' OR **db_name**_posts.post_status = 'tribe-ea-success' OR **db_name**_posts.post_status = 'tribe-ea-failed' OR **db_name**_posts.post_status = 'tribe-ea-schedule' OR **db_name**_posts.post_status = 'tribe-ea-pending' OR **db_name**_posts.post_status = 'tribe-ea-draft'))) AND **db_name**_posts.ID IN (0)
                                        GROUP BY **db_name**_tec_occurrences.occurrence_id
                                        ORDER BY **db_name**_posts.menu_order ASC, **db_name**_posts.post_title ASC
                                        LIMIT 0, 20
                                 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, FacetWP_Request->update_query_vars, FacetWP_Renderer->render, 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

I know Advanced Custom Fields and Facet WP get a mention, but 90% of the lines reference TEC or tribe.

We display our events in a Widget if that helps.

Thanks,

Hunter

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