Events Calendar Admin Error

[Mary Kay Jones]

I get the following error message in the Events admin panel:

WordPress database error: [Unknown column ‘wp_postmeta.meta_value’ in ‘order clause’]
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, eventStart.meta_value as EventStartDate, eventEnd.meta_value as EventEndDate FROM wp_posts LEFT JOIN wp_postmeta as eventStart ON ( wp_posts.ID = eventStart.post_id AND eventStart.meta_key = ‘_EventStartDate’ ) LEFT JOIN wp_postmeta as eventEnd ON ( wp_posts.ID = eventEnd.post_id AND eventEnd.meta_key = ‘_EventEndDate’ ) 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_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) ORDER BY DATE(wp_postmeta.meta_value) DESC, TIME(wp_postmeta.meta_value) DESC LIMIT 0, 20

None of the current events are displayed in the admin area. We can still edit events directly from each event page.

[Brian]

Hi,

Sorry for the issues you are having with the Events Admin Panel.

I found something that might help.

Can you add this snippet to your theme’s function.php:

https://gist.github.com/jazbek/6585714

There maybe a join limit set by your host that is causing this issue.

Let me know if that works.

Thanks

[Mary Kay Jones]

Thanks for this. Unfortunately, the problem persists.

Here’s a link to the functions.php file, if you’d like to have a look.

https://gist.github.com/anonymous/412b86a4ec1a6b674995

[Brian]

Ok if that did not work then please try our testing for conflicts guide and see if that can narrow down the conflict.

https://theeventscalendar.com/support/documentation/testing-for-conflicts/

Let me know what you find out after doing the tests and we can go from there.

Thanks

[Mary Kay Jones]

It doesn’t appear to be a plugin conflict, so I assume it’s a problem with the theme.

The author has released an updated theme, so I will try that and see if it works.

[Brian]

Ok let us know what you find out after updating.

thanks

[Brian]

Since I haven’t heard back from you here, I’m going to go ahead and close out this thread. Feel free to start a new thread if you have further issues. Thanks! 🙂

[Author]

Posts