Database error

[Honey]

hello my client is using the events calendar pro, but our site sometimes goes down, and as i check the error logs i found this error, can you help? thanks

[31-Mar-2018 23:55:43 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 LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.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_term_relationships.term_taxonomy_id IN (33)
) AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type = ‘tribe_events’ AND ((wp_posts.post_status = ‘publish’)) AND ((wp_postmeta.meta_value >= ‘2018-03-30 00:00:00’ AND wp_postmeta.meta_value <= ‘2020-03-31 23:59:59’) OR (tribe_event_end_date.meta_value >= ‘2018-03-30 00:00:00’ AND wp_postmeta.meta_value <= ‘2020-03-31 23:59:59’ ) OR (wp_postmeta.meta_value < ‘2018-03-30 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2020-03-31 23:59:59’ )) ORDER BY wp_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )

LIMIT 0, 10
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, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, 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

[Courtney]

Hi there!

Thanks so much for getting in touch! I’m afraid that we’re not equipped to provide technical support for current plugin users here in our pre-sales forum. We’d be more than happy to assist you at one of the following locations:

• If you’re using one or more of our free plugins such as The Events Calendar and Event Tickets, you can request assistance on the WordPress.org support forum for the affected product.
• If you’re a current license holder for one of our premium offerings, please log in to your account and submit a post to the appropriate forum for the affected product. Please include your System Info https://theeventscalendar.com/knowledgebase/sharing-sys-info/ so we can better help you.

If you can, please take the time to confirm in your post that you’ve run through our Testing for Conflicts steps prior to contacting us–this will save us a step and help us to get your issue resolved that much quicker! 🙂

Thanks again, and we’ll see you in the forums!
Courtney 🙂

[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