Unknown column 'EventStartDate' in 'order clause'

[cardsmithsbreaks]

Hi guys,

My error log is riddled with this SQL error:

WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID
FROM wp_posts
LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ )
WHERE 1=1
AND wp_posts.ID NOT IN (102018,101941,101821,101820,101431,101430,101411,101149,100876,100527)
AND wp_posts.post_type = ‘tribe_events’
AND ((wp_posts.post_status = ‘publish’))
GROUP BY wp_posts.ID
ORDER BY EventStartDate ASC
LIMIT 0, 10

/* From [cardsmithsbreaks.com/] in [/nas/wp/www/cluster-40160/cardsmiths/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:879] */
made by require(‘wp-blog-header.php’),
require_once(‘wp-includes/template-loader.php’),
include(‘/themes/emporium/index.php’),
dynamic_sidebar,
call_user_func_array,
WP_Widget->display_callback,
Tribe__Events__Pro__Mini_Calendar_Widget->widget,
Tribe__Events__Pro__Mini_Calendar->do_calendar,
tribe_get_template_part,
include(‘/plugins/events-calendar-pro/src/views/pro/widgets/mini-calendar-widget.php’),
tribe_get_template_part,
do_action(‘tribe_before_get_template_part’),
call_user_func_array,
Tribe__Events__Pro__Mini_Calendar->setup_list,
Tribe__Events__Query::getEvents,
WP_Query->__construct,
WP_Query->query,
WP_Query->get_posts

It seems to be added by a can_inject_date_field() check in Tribe__Events__Query, hoping there’s a quick fix.

[George]

Hey @cardsmithsbreaks

Sorry to hear that you’ve run into this. I’m curious, have you done any testing with deactivating plugins on your site or anything? You have many plugins, and while the ones I saw all seem like pretty good-quality ones, a conflict is possible here – based, if anything, on the fact that I cannot reproduce this problem on my local install…

If you’re able to, I’d recommend running through as many of the steps outlined here → https://theeventscalendar.com/knowledgebase/testing-for-conflicts/

Let us know what you’re able to do there, and what you find by doing it. In the meantime I will continue to try to recreate this issue.

Thank you for including your system information right off the bat! 🙂

Cheers,
George

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts