{"id":1399549,"date":"2017-12-06T08:40:56","date_gmt":"2017-12-06T16:40:56","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/"},"modified":"2017-12-06T08:40:56","modified_gmt":"2017-12-06T16:40:56","slug":"database-error-unknown-column-wp_postmeta-meta_value-in-field-list","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/","title":{"rendered":"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list']"},"content":{"rendered":"

WordPress database error: [Unknown column ‘wp_postmeta.meta_value’ in ‘field list’]
\nSELECT 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<\/p><\/blockquote>\n

This error appeared after updating to the latest Events Calendar version. We’re also running Events Calendar Pro.
\nThe 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<\/a> 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 …<\/p>\n

This seems to be a very similar issue (and almost identical error message) to the post linked below.<\/p>\n

========================
\nPLEASE LEAVE FOR SUPPORT
\nReporting the same issue as:\u00a0https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-unknown-column-wp_postmeta-meta_value-in-field-lis-2\/<\/p>\n","protected":false},"template":"","class_list":["post-1399549","topic","type-topic","status-closed","hentry"],"yoast_head":"\ndatabase error: [Unknown column 'wp_postmeta.meta_value' in 'field list'] -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list'] -\" \/>\n<meta property=\"og:description\" content=\"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 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/\",\"name\":\"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list'] -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-12-06T16:40:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list']\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list'] -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/","og_locale":"en_US","og_type":"article","og_title":"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list'] -","og_description":"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 […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/","name":"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list'] -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-12-06T16:40:56+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/database-error-unknown-column-wp_postmeta-meta_value-in-field-list\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"database error: [Unknown column 'wp_postmeta.meta_value' in 'field list']"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1399549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1399549\/revisions"}],"predecessor-version":[{"id":1526772,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1399549\/revisions\/1526772"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1399549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}