Unknown column ‘date’ in ‘order clause’

Hello,

I’m on WP6.1 with TEC 6.0.3.1 and got this error thanks to Query Monitor.

Here is the complete query

SELECT SQL_CALC_FOUND_ROWS egl_8_posts.ID
FROM egl_8_posts
LEFT JOIN egl_8_term_relationships
ON (egl_8_posts.ID = egl_8_term_relationships.object_id)
INNER JOIN egl_8_tec_occurrences
ON egl_8_posts.ID = egl_8_tec_occurrences.post_id
WHERE 1=1
AND ( egl_8_term_relationships.term_taxonomy_id IN (90,159) )
AND ( egl_8_tec_occurrences.post_id IS NOT NULL
AND CAST(egl_8_tec_occurrences.end_date AS DATETIME) >= '2022-11-07 08:06:14' )
AND ((egl_8_posts.post_type = 'tribe_events'
AND (egl_8_posts.post_status = 'publish'
OR egl_8_posts.post_status = 'acf-disabled'
OR egl_8_posts.post_status = 'tribe-ea-success'
OR egl_8_posts.post_status = 'tribe-ea-failed'
OR egl_8_posts.post_status = 'tribe-ea-schedule'
OR egl_8_posts.post_status = 'tribe-ea-pending'
OR egl_8_posts.post_status = 'tribe-ea-draft'
OR egl_8_posts.post_status = 'private')))
GROUP BY egl_8_tec_occurrences.occurrence_id
ORDER BY date ASC, CAST(egl_8_tec_occurrences.start_date AS CHAR) ASC, post_date ASC
LIMIT 0, 10

here’s the stack trace:

WP_Query->get_posts()
wp-includes/class-wp-query.php:3247
TEC\E\C\V\W\Custom_Tables_Query->get_posts()
wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/WP_Query/Custom_Tables_Query.php:162
TEC\E\C\V\W\M\Events_Only_Modifier->filter_posts_pre_query()
wp-content/plugins/the-events-calendar/src/Events/Custom_Tables/V1/WP_Query/Modifiers/Events_Only_Modifier.php:75
apply_filters_ref_array('posts_pre_query')
wp-includes/plugin.php:256
WP_Query->get_posts()
wp-includes/class-wp-query.php:3097
WP_Query->query()
wp-includes/class-wp-query.php:3726
WP_Query->__construct()
wp-includes/class-wp-query.php:3858
FLBuilderLoop::custom_query()
wp-content/plugins/bb-plugin/classes/class-fl-builder-loop.php:403
FLBuilderLoop::query()
wp-content/plugins/bb-plugin/classes/class-fl-builder-loop.php:124
FLBuilder::render_module()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2771
FLBuilder::render_modules()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2728
FLBuilder::render_column()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2613
FLBuilder::render_column_group()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2536
FLBuilder::render_modules()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2730
FLBuilder::render_column()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2613
FLBuilder::render_column_group()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2536
FLBuilder::render_row()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2324
FLBuilder::render_rows()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2285
FLBuilder::render_nodes()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:2068
FLBuilder::render_content_by_id()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:1921
FLBuilder::render_content()
wp-content/plugins/bb-plugin/classes/class-fl-builder.php:1996
apply_filters('the_content')
wp-includes/plugin.php:205
the_content()
wp-includes/post-template.php:255
genesis_do_post_content()
wp-content/themes/genesis/lib/structure/post.php:486
do_action('genesis_entry_content')
wp-includes/plugin.php:517
genesis_standard_loop()
wp-content/themes/genesis/lib/structure/loops.php:119
genesis_do_loop()
wp-content/themes/genesis/lib/structure/loops.php:38
do_action('genesis_loop')
wp-includes/plugin.php:517
genesis()
wp-content/themes/genesis/lib/framework.php:66

Let me know if you need further help

• This topic was modified 3 years, 7 months ago by Sebastien SERRE.
• This topic was modified 3 years, 7 months ago by Sebastien SERRE.