WordPress database error: [Unknown column 'wp_postmeta.meta_value' in 'field lis

[Keiko Slazas]

We have a few custom post types and are getting a DB error only on the events Month view:

WordPress database error: [Unknown column ‘wp_postmeta.meta_value’ in ‘field list’]
SELECT DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts 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’) AND wp_posts.post_type <> ‘applications’ AND wp_posts.post_type <> ‘parent-assessment’ AND wp_posts.post_type <> ‘student-self-assess’ AND wp_posts.post_type <> ‘educator-assessment’ ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1

[Andras]

Hey Marcus,

Thanks for going Pro and welcome to the forums! Let me try to help you out with this.

I tried to run this select on a local db and managed to get the same error. However, when I changed the MIN(wp_postmeta.meta_value) to MIN(tribe_event_end_date.meta_value) (which seems to be the same thing) then it ran without any issue.

I’m not sure how and when this query is generated. Can you shed some light on that?

Also I would recommend you to do a test for conflicting plugins on this? Here’s a nice guide for this:

Testing Conflicts With Themes and Other Plugins

Let me know the results.

Cheers,
Andras

[Andras]

Hi Marcus,

Do you still have these errors? Can you tell me the steps you do to get them appear? We want to look into this deeper with the team, but would need some more info to get started.

The more details you can give us the better.

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

[Victor]

Hi Marcus!

Just wanted to share with you that a new release of our plugins is out. As of this version, and possibly earlier versions too, we can no longer reproduce the issue described in this ticket.

You can find out more about this release → https://theeventscalendar.com/maintenance-release-for-the-week-of-27-may-2018/

Please update the plugins and see if it works for you. Don’t hesitate to open a new topic if anything comes up.

Best,
Victor

[Author]

Posts