We cannot get the scheduled job to pull in events. Here are two errors; one from the debug log and the other
\nERROR 1:
\nDebug log shows:
\n[06-Nov-2017 16:35:31 UTC] 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 wphd_4_posts.ID FROM wphd_4_posts INNER JOIN wphd_4_postmeta ON ( wphd_4_posts.ID = wphd_4_postmeta.post_id ) LEFT JOIN wphd_4_postmeta as tribe_event_end_date ON ( wphd_4_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND (
\n wphd_4_postmeta.meta_key = ‘_EventStartDate’
\n) AND wphd_4_posts.post_type = ‘tribe_events’ AND ((wphd_4_posts.post_status = ‘publish’)) AND ((wphd_4_postmeta.meta_value >= ‘2017-11-06 00:00:00’ AND wphd_4_postmeta.meta_value <= ‘2018-02-04 23:59:59’) OR (tribe_event_end_date.meta_value >= ‘2017-11-06 00:00:00’ AND wphd_4_postmeta.meta_value <= ‘2018-02-04 23:59:59’ ) OR (wphd_4_postmeta.meta_value < ‘2017-11-06 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2018-02-04 23:59:59’ )) ORDER BY wphd_4_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 20, 20
\n\t\t 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
\n[06-Nov-2017 16:35:31 UTC] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query <\/p>\n
ERROR 2:
\nAttempt to schedule a new job.
\nerror message:
\n“There was an error fetching the results from your import: Events could not be imported. The URL provided could be reached and has The Events Calendar REST API enabled, but returned an empty archive page. Learn more.
\nTry to adjust your import settings and try again.”<\/p>\n
Learn More link https:\/\/theeventscalendar.com\/knowledgebase\/other-url-import-errors-in-event-aggregator goes to a 404 page<\/p>\n","protected":false},"template":"","class_list":["post-1376346","topic","type-topic","status-closed","hentry"],"yoast_head":"\n