Title: WordPress database error Unknown column Last modified: July 18, 2022 --- # WordPress database error Unknown column * Resolved [stevebrett](https://wordpress.org/support/users/stevebrett/) * (@stevebrett) * [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/) * Hi this is appearing in our error log- should it be fixed? How would i go about trouble shooting this? * Thanks for any pointers * [18-Jul-2022 14:34:50 UTC] WordPress database error Unknown column ‘wph2_postmeta. meta_value’ in ‘field list’ for query SELECT DISTINCT wph2_posts.*, MIN(wph2_postmeta. meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wph2_posts LEFT JOIN wph2_term_relationships ON (wph2_posts.ID = wph2_term_relationships. object_id) LEFT JOIN wph2_postmeta as tribe_event_end_date ON ( wph2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’) WHERE 1=1 AND ( wph2_term_relationships.term_taxonomy_id IN (785) ) AND ((wph2_posts. post_type = ‘tribe_events’ AND (wph2_posts.post_status = ‘publish’ OR wph2_posts. post_status = ‘tribe-ea-success’ OR wph2_posts.post_status = ‘tribe-ea-failed’ OR wph2_posts.post_status = ‘tribe-ea-schedule’ OR wph2_posts.post_status = ‘ tribe-ea-pending’ OR wph2_posts.post_status = ‘tribe-ea-draft’))) AND wph2_posts. post_type <> ‘chervinsky-app’ AND wph2_posts.post_type <> ‘juried-show-app’ AND wph2_posts.post_type <> ‘nepr’ GROUP BY wph2_posts.ID ORDER BY EventStartDate DESC, wph2_posts.post_date DESC LIMIT 0, 1 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Support [WilloftheD](https://wordpress.org/support/users/abzlevelup/) * (@abzlevelup) * [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/#post-15840778) * Hi [@stevebrett](https://wordpress.org/support/users/stevebrett/), thanks for reaching out to us. Sorry to hear about this one, let me help you. * First, I’d like to ask, what was the last action when the issue shows or the trigger of the error here? * I suspect that the WordPress was not installed properly, or the field was accidentally deleted, as the field that’s missing here is default to WordPress. I would suggest creating a new staging site and trying to reinstall WordPress and install the plugins. See if the issue still persists. * Looking forward to hearing from you. * Best, Abz * Thread Starter [stevebrett](https://wordpress.org/support/users/stevebrett/) * (@stevebrett) * [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/#post-15842683) * Thanks There are a number of people who wok on this site- But we cant pin point the onset of this issue to anything any of has done. * Also this is a large and somewhat busy site and unfortunately they don’t have room in their plan to create a staging site. * Is there a way i could look and see if the field exists and possibly recreate it in another way * Plugin Support [WilloftheD](https://wordpress.org/support/users/abzlevelup/) * (@abzlevelup) * [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/#post-15844746) * Hi [@stevebrett](https://wordpress.org/support/users/stevebrett/), thanks for getting back to me here. * What we recommend is doing the testing for conflicts, since you have devs/users working on your website there might be conflicts or plugins that were not removed properly or causing some issues. [https://theeventscalendar.com/knowledgebase/k/testing-for-conflicts/](https://theeventscalendar.com/knowledgebase/k/testing-for-conflicts/) * Moreover, we still recommend doing the testing on a staging site. One thing to note is that our support team cannot log into the dashboard of customer WordPress sites as per our Support Policy. [https://theeventscalendar.com/knowledgebase/k/what-support-is-provided-for-license-holders/](https://theeventscalendar.com/knowledgebase/k/what-support-is-provided-for-license-holders/) * > Is there a way I could look and see if the field exists and possibly recreate > it in another way * You could open your database and check the fields for this one. We can’t recommend another third-party plugin, checking the database → fields and table is the safest thing to do. You could probably ask your devs to check if you know someone who can. * Let us know how would you like to proceed. * Best, Abz * Plugin Support [WilloftheD](https://wordpress.org/support/users/abzlevelup/) * (@abzlevelup) * [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/#post-15890431) * Hey [@stevebrett](https://wordpress.org/support/users/stevebrett/), this thread has been inactive for a while, so we’re going to go ahead and mark it Resolved. Please feel free to open a new thread if any other questions come up, and we’d be happy to help. * Cheers, Abz * Thread Starter [stevebrett](https://wordpress.org/support/users/stevebrett/) * (@stevebrett) * [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/#post-15891364) * Sorry not to get back to you sooner but wanted to thanks you for your help and let you know we did set up staging and figured this out. * Appreciate your help Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘WordPress database error Unknown column’ is closed to new replies. * ![](https://ps.w.org/the-events-calendar/assets/icon-256x256.gif?rev=2516440) * [The Events Calendar](https://wordpress.org/plugins/the-events-calendar/) * [Frequently Asked Questions](https://wordpress.org/plugins/the-events-calendar/#faq) * [Support Threads](https://wordpress.org/support/plugin/the-events-calendar/) * [Active Topics](https://wordpress.org/support/plugin/the-events-calendar/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/the-events-calendar/unresolved/) * [Reviews](https://wordpress.org/support/plugin/the-events-calendar/reviews/) ## Tags * [Database Error](https://wordpress.org/support/topic-tag/database-error/) * 5 replies * 2 participants * Last reply from: [stevebrett](https://wordpress.org/support/users/stevebrett/) * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-error-unknown-column-5/#post-15891364) * Status: resolved