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: 1214
    | 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

This thread hasn’t seen any activity for quite some time and we are not accepting further replies.

If you need further help with this or any other issue, please create a new topic (you can of course include a link to this one if that helps to provide additional context) and one of the team will be only too happy to help.