Dear WordPress.org<\/p>\n
I am using the Avada Theme together with Modern tribe events plugin, And I got a message above my events.<\/p>\n
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 JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type = CONCAT(‘post_’, wp_posts.post_type) 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.ID NOT IN (2236,2170,2158,2146,2136,1066,1410,2636,2656,2677,2679,3021) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ 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’) AND ( ( t.language_code = ‘en’ AND wp_posts.post_type IN (‘post’,’page’,’tribe_venue’,’tribe_organizer’,’tribe_events’,’avada_portfolio’,’avada_faq’,’slide’ ) ) OR wp_posts.post_type NOT IN (‘post’,’page’,’tribe_venue’,’tribe_organizer’,’tribe_events’,’avada_portfolio’,’avada_faq’,’slide’ ) ) ORDER BY EventStartDate DESC, wp_posts.post_date DESC LIMIT 0, 1<\/p>\n
I run WP 4.8.2
\nAvada Theme 5.5.2
\nEvent tribe 4.6.1<\/p>\n
I did try to remove the event plugin and reinstalled the plugin afterwards.<\/p>\n
I recently migrated the website to another server from PHP 5.5 too PHP 5.6<\/p>\n
What could be the problem?<\/p>\n","protected":false},"template":"","class_list":["post-9581763","topic","type-topic","status-publish","hentry","topic-tag-wordpress-database-error"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9581763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/9581763\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=9581763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}