Help Desk

database error: [Unknown column 'wp_postmeta.meta_value' in 'field list']

  • Topics: 3
    | Permalink

    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’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’ OR wp_posts.post_status = ‘private’) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1

    This error appeared after updating to the latest Events Calendar version. We’re also running Events Calendar Pro.
    The error appears on the full month calendar view and keeps future months from loading, but it does not affect individual events. It seems to be a conflict with Advance Access Manager version 5.0. and the recently-updated 5.0.1. We’ve deactivated that plugin for now, but we’ll want to be able to use it in the future, ideally …

    This seems to be a very similar issue (and almost identical error message) to the post linked below.

    ========================
    PLEASE LEAVE FOR SUPPORT
    Reporting the same issue as: https://theeventscalendar.com/support/forums/topic/wordpress-database-error-unknown-column-wp_postmeta-meta_value-in-field-lis-2/

    Posts: 2496
    | Permalink

    Hi Emilirose,

    Thanks for email support and I apologize you are having issues with this. We are currently in the process of fixing this issue. Unfortunately, I do not have an ETA. You will be notified as soon as it has been resolved.

    Thanks,
    Brendan

    Posts: 6228 Topics: 17
    | Permalink

    Hi Michele!

    Just wanted to share with you that a new release of our plugins is out, including a fix for this issue 🙂

    Find out more about this release → https://theeventscalendar.com/maintenance-release-for-the-week-of-6-may-2018/

    We appreciate your patience while we worked on this.

    Please update the plugins and let us know if the fix works for your site.

    Best,
    Victor

    Posts: 65
    | Permalink

    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

    | Permalink

The topic ‘database error: [Unknown column 'wp_postmeta.meta_value' in 'field list']’ is closed to new replies.