[Trey]

Barry,

I think I’ve fixed the filter problem and wanted to post the code here in case you guys didn’t already have code in place.

On lines 68-73 of the /events-calendar-pro/src/Tribe/APM_Filters/Date_Filter.php I found the source of the unknown column:

if ( $key === 'ecp_start_date' ) {
    $field = 'eventStart.meta_value';
}
if ( $key === 'ecp_end_date' ) {
    $field = 'eventEnd.meta_value';
}

and changed it to:

if ( $key === 'ecp_start_date' ) {
    $field = 'tribe_event_start_date.meta_value';
}
if ( $key === 'ecp_end_date' ) {
    $field = 'tribe_event_end_date.meta_value';
}

Hopefully this is helpful to anyone who is really hamstrung by this until there is an official fix in place!

[Trey]

I am also having this problem. I’m using Events Calendar with the PRO add-on (as well as several others) version 3.11.1. I have the APM version 3.11. If I click the “Reset to Defaults” button and make sure there are no filters or preset filter groups chosen my events will show. I can filter by title and other attributes, but if I sort by start_date the list of events is blank.

I just opened the error log from HHVM (hiphop for the win!) and see this during trying to run one of the queries:

[Mon Jul 27 22:29:08 2015] [hphp] [2954:7f44d5bff700:16189:000001] [] WordPress database error Unknown column 'eventStart.meta_value' in 'where clause' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, tribe_event_start_date.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate  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' ) LEFT JOIN wp_postmeta AS tribe_event_start_date ON wp_posts.ID = tribe_event_start_date.post_id AND tribe_event_start_date.meta_key = '_EventStartDate'  WHERE 1=1  AND wp_posts.post_type = 'tribe_events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') AND eventStart.meta_value >= '2015-07-28 02:00:00'   ORDER BY tribe_event_start_date.meta_value DESC, tribe_event_end_date.meta_value DESC LIMIT 0, 20 made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

[Author]

Posts