Conflicts with Events Calendar

Hi,

I have a conflict with the Easy Events Calendar. The issues is effecting some other plugins on the site, but the error log only shows the following message:

The error log shows the following:

[02-Jul-2017 19:27:30 UTC] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) 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_postmeta.meta_key = ‘_EventStartDate’
AND
( mt1.meta_key = ‘_EventVenueID’ AND CAST(mt1.meta_value AS SIGNED) = ‘11497’ )
) AND wp_posts.post_type = ‘tribe_events’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 7
made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, call_user_func, Tribe__Events__REST__V1__Endpoints__Archive_Event->get, Tribe__Events__REST__V1__Endpoints__Archive_Event->has_previous, tribe_get_events, Tribe__Events__Query::getEvents, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[02-Jul-2017 22:50:10 UTC] WordPress database error Unknown column ‘tribe_event_end_date.meta_value’ in ‘field list’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT wp_posts.*, MIN(tribe_event_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate, IF (wp_posts.post_type = ‘tribe_events’, tribe_event_postmeta.meta_value, wp_posts.post_date) AS EventStartDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_postmeta on wp_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (624,625,628)
AND
tt1.term_taxonomy_id IN (624,625,628)
AND
tt2.term_taxonomy_id IN (624,625,628)
) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) AND (wp_posts.post_status = ‘publish’ 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’) AND (tribe_event_postmeta.meta_value >= ‘2017-07-03 00:50:09’ OR (tribe_event_postmeta.meta_value <= ‘2017-07-03 00:50:09’ AND tribe_event_end_date.meta_value >= ‘2017-07-03 00:50:09’ )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 30
made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__iCal->do_ical_template, Tribe__Events__iCal->generate_ical_feed, WP_Query->get_posts
[03-Jul-2017 09:18:26 UTC] WordPress database error Unknown column ‘tribe_event_end_date.meta_value’ in ‘field list’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT wp_posts.*, MIN(tribe_event_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate, IF (wp_posts.post_type = ‘tribe_events’, tribe_event_postmeta.meta_value, wp_posts.post_date) AS EventStartDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_postmeta on wp_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (624,625,628)
AND
tt1.term_taxonomy_id IN (624,625,628)
AND
tt2.term_taxonomy_id IN (624,625,628)
) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) AND (wp_posts.post_status = ‘publish’ 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’) AND (tribe_event_postmeta.meta_value >= ‘2017-07-03 11:18:25’ OR (tribe_event_postmeta.meta_value <= ‘2017-07-03 11:18:25’ AND tribe_event_end_date.meta_value >= ‘2017-07-03 11:18:25’ )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 30
made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__iCal->do_ical_template, Tribe__Events__iCal->generate_ical_feed, WP_Query->get_posts
[03-Jul-2017 09:18:29 UTC] WordPress database error Unknown column ‘tribe_event_end_date.meta_value’ in ‘field list’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT wp_posts.*, MIN(tribe_event_postmeta.meta_value) as EventStartDate, tribe_event_end_date.meta_value as EventEndDate, IF (wp_posts.post_type = ‘tribe_events’, tribe_event_postmeta.meta_value, wp_posts.post_date) AS EventStartDate FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_postmeta on wp_posts.ID = tribe_event_postmeta.post_id AND tribe_event_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (624,625,628)
AND
tt1.term_taxonomy_id IN (624,625,628)
AND
tt2.term_taxonomy_id IN (624,625,628)
) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘ks_giveaway’, ‘tribe_venue’, ‘tribe_events’, ‘tribe-ea-record’, ‘portfolio’, ‘avia_framework_post’, ‘event’, ‘bar’, ‘restaurants’, ‘saunas’, ‘post’, ‘page’) AND (wp_posts.post_status = ‘publish’ 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’) AND (tribe_event_postmeta.meta_value >= ‘2017-07-03 11:18:28’ OR (tribe_event_postmeta.meta_value <= ‘2017-07-03 11:18:28’ AND tribe_event_end_date.meta_value >= ‘2017-07-03 11:18:28’ )) ORDER BY EventStartDate ASC, wp_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 30
made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Tribe__Events__iCal->do_ical_template, Tribe__Events__iCal->generate_ical_feed, WP_Query->get_posts

• This topic was modified 7 years, 4 months ago by roamingk.