Errors: SQL and on Scheduler

[Stephen Hoffer]

We cannot get the scheduled job to pull in events. Here are two errors; one from the debug log and the other
ERROR 1:
Debug log shows:
[06-Nov-2017 16:35:31 UTC] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT 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 (
wphd_4_postmeta.meta_key = ‘_EventStartDate’
) 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
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 20, 20
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
[06-Nov-2017 16:35:31 UTC] WordPress database error Unknown column ‘post_parent’ in ‘group statement’ for query

ERROR 2:
Attempt to schedule a new job.
error message:
“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.
Try to adjust your import settings and try again.”

Learn More link https://theeventscalendar.com/knowledgebase/other-url-import-errors-in-event-aggregator goes to a 404 page

[Andras]

Hello again Stephen,

Thanks for reaching out!

For your second, import related issue, could you please share with me the URL you are trying to import from? I would like to run some tests. Thanks!

As for the first issue, do you know at what time / for what action that error messages gets generated?

Thanks,
Andras

[Stephen Hoffer]

THE # 2 Error:
Any new Import using other URL to import on schedule. for example, using
http://www.rinkfinder.net/burnsvilleicecenter/events
and hitting preview will result in this error.
This happens for any of our other URLs.

The # 1 Error:
The error appears to be generated when I go to Imports-> Scheduled Imports–>Edit[ under the scheduled:https://rinkfinder.net/burnsvilleicecenter/events%5D –> Preview

[Andras]

Hi,

You can find more info on error messages on this page. Your case is #8.

https://theeventscalendar.com/knowledgebase/url-import-errors-event-aggregator/

(I just realized the url in the error message is broken.)

The error message in the log is generated when trying to fetch this source.

You should see all events data when visiting this url:

https://rinkfinder.net/wp-json/tribe/events/v1/events

It looks like something gets in the way. Can you possibly deactivate all plugins and switch to a default theme on the source site and check that url if you get the data? (Should look something like this.) This will help us eliminate the possibility of any of the other plugins / theme interfering with the TEC REST API.

Thanks,
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