Error in log

[Sean]

I’ve been getting some DB errors in my error log. Is anyone else seeing anything like this? Here is an example of one of them:

[06-Jun-2017 02:13:08 UTC] WordPress database error Unknown column ‘EventStartDate’ in ‘order clause’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT psn_posts.ID FROM psn_posts INNER JOIN psn_postmeta ON ( psn_posts.ID = psn_postmeta.post_id ) INNER JOIN psn_postmeta AS mt1 ON ( psn_posts.ID = mt1.post_id ) LEFT JOIN psn_postmeta as tribe_event_end_date ON ( psn_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND (
psn_postmeta.meta_key = ‘_EventStartDate’
AND
( mt1.meta_key = ‘_EventVenueID’ AND CAST(mt1.meta_value AS SIGNED) = ‘85604’ )
) AND psn_posts.post_type = ‘tribe_events’ AND ((psn_posts.post_status = ‘publish’)) ORDER BY psn_posts.post_date ASC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
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

[Sean]

Looks like this user might be having a related issue: https://theeventscalendar.com/support/forums/topic/database-error-unknown-column-eventstartdate-in-order-clause-for-query/

[Patti]

Sean, I started the other thread you linked to.

Are you getting the Meta.php errors too?

[Mathew]

I am seeing the same error and have opened a ticket as well. I found a few others who have the same issue by searching the forums for post_parent. Here’s one that’s insightful. Hopefully it can gain some attention, albeit difficult to troubleshoot when it’s not reproducible on demand.

[Cliff]

Hi, Sean.

I’ve handled all the threads that have been linked to here.

I haven’t been able to replicate the issue. If we can find out what situation causes this (e.g. specific URL or performing a specific action), then I’ll be able to try it. If it’s reproducible, then I can get the bug fixed. Until then, it’s hard to say…

Please let me know once you can detail how/when this is happening.

Thank you.

[Cliff]

Sean, please reference https://theeventscalendar.com/support/forums/topic/database-error-unknown-column-eventstartdate-in-order-clause-for-query/#post-1295700 and also investigate a possible plugin conflict with the Business Directory Plugin – Enhanced Categories Module and/or the Business Directory Plugin.

Thank you.

[Sean]

I’ll disable the Business Directory Plugin – Enhanced Categories Module and wait see if I get any errors in the log. I’ll repeat with Business Directory Plugin after Business Directory Plugin – Enhanced Categories Module. Has anyone heard of a sure fire way to get this error to trigger from other users?

[Cliff]

Sean (and others), I’ll leave this thread open so feel free to reply and help each other here. Please know, though, that I have to reply within 1 day anytime there’s new activity here.

Please note that threads get Closed automatically after a couple weeks of inactivity. If it does get Closed, please open a new thread, adding your current problem description and also linking back to this thread.

Thank you!

[Patti]

Sean – did you get any errors AFTER you disabled the plugins?

Were you using any custom templates for the BD plugin?

[Cliff]

Sean, are you out there?

[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