Database error

[UNC Web Services]

Hello, I’m trying to track down some database errors I’m seeing my logs. I’m using advanced calendar pro v4.4.31 and WP v4.9.7

[07-Sep-2018 18:49:27 UTC] WordPress database error Unknown column ‘wpsites_236_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wpsites_236_posts.*, MIN(wpsites_236_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wpsites_236_posts LEFT JOIN wpsites_236_postmeta as tribe_event_end_date ON ( wpsites_236_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wpsites_236_posts.post_type = ‘tribe_events’ AND (wpsites_236_posts.post_status = ‘publish’ OR wpsites_236_posts.post_status = ‘tribe-ea-success’ OR wpsites_236_posts.post_status = ‘tribe-ea-failed’ OR wpsites_236_posts.post_status = ‘tribe-ea-schedule’ OR wpsites_236_posts.post_status = ‘tribe-ea-pending’ OR wpsites_236_posts.post_status = ‘tribe-ea-draft’) ORDER BY EventStartDate DESC, wpsites_236_posts.post_date DESC LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, QM_DB->query

WordPress database error Unknown column ‘wpsites_38_postmeta.meta_value’ in ‘field list’ for query SELECT DISTINCT wpsites_38_posts.*, MIN(wpsites_38_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wpsites_38_posts LEFT JOIN wpsites_38_postmeta as tribe_event_end_date ON ( wpsites_38_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND ( ( wpsites_38_posts.post_type = ‘tribe_events’ AND ( ( 1=1 AND ( ( wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’) ) ) ) ) ) ) AND wpsites_38_posts.post_type = ‘tribe_events’ AND (wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’,’private’) OR wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’,’private’) OR wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’,’private’) OR wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’,’private’) OR wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’,’private’) OR wpsites_38_posts.post_status IN (‘publish’,’tribe-ea-success’,’tribe-ea-failed’,’tribe-ea-schedule’,’tribe-ea-pending’,’tribe-ea-draft’,’private’)) ORDER BY EventStartDate DESC, wpsites_38_posts.post_date DESC LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, QM_DB->query

• This topic was modified 7 years, 7 months ago by UNC Web Services.

[Jeremy]

Hi,

Thanks for reaching out to us! I’d be happy to help you 🙂

First of all, could you please share your System Information? (you may paste it as a “Private reply” to this message). That way, I would have a better overview of your setup.

Thanks in advance,
Jeremy

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts