Logfile error message

[roger coryell]

Seen an error like this? Any idea of what’s causing?

[Tue Oct 31 22:12:30.177406 2017] [:error] [pid 17879] [client 93.158.161.92:33167] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query \n\t\t\tSELECT\n\t\t\t\tSQL_CALC_FOUND_ROWS *\n\t\t\tFROM (\n\t\t\t\tSELECT DISTINCT mendo_posts.ID FROM mendo_posts INNER JOIN mendo_postmeta ON ( mendo_posts.ID = mendo_postmeta.post_id ) LEFT JOIN mendo_postmeta as tribe_event_end_date ON ( mendo_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND ( \n mendo_postmeta.meta_key = ‘_EventStartDate’\n) AND mendo_posts.post_type = ‘tribe_events’ AND ((mendo_posts.post_status = ‘publish’)) AND ((mendo_postmeta.meta_value >= ‘2017-10-30 09:59:00’ AND mendo_postmeta.meta_value <= ‘2019-10-31 15:12:30’) OR (tribe_event_end_date.meta_value >= ‘2017-10-30 09:59:00’ AND mendo_postmeta.meta_value <= ‘2019-10-31 15:12:30’ ) OR (mendo_postmeta.meta_value < ‘2017-10-30 09:59:00’ AND tribe_event_end_date.meta_value >= ‘2019-10-31 15:12:30’ )) ORDER BY mendo_posts.post_date ASC \n\t\t\t) a\n\t\t\tGROUP BY IF( post_parent = 0, ID, post_parent )\n\t\t\tORDER BY EventStartDate ASC\n\t\t\tLIMIT 9, 9\n\t\t /* From [www.visitmendocino.com/wp-json/tribe/events/v1/events/] in [/nas/content/live/mendoupdate/wp-content/plugins/the-events-calendar/src/Tribe/Query.php:1052] */ 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_next, tribe_get_events, Tribe__Events__Query::getEvents, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

[Andras]

Hi Roger,

Based on this part

From [www.visitmendocino.com/wp-json/tribe/events/v1/events/]

it is connected to the REST API functionality.

Can you narrow it down when this error message gets into the log? What is the action that triggers it?

Does it trigger when you visit this url?

www.visitmendocino.com/wp-json/tribe/events/v1/events

Andras

[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