PHP query error

[Jeffrey]

Greetings,
I inherited an already built website, when I got highered. I do not know if we are using the free version of this, or a paid version. Anyways, I wanted to bring to your attention an error that I am getting in my logs.
WordPress database error Unknown column 'wp_postmeta.meta_value' in 'field list' for query 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 = 'order_received' OR wp_posts.post_status = 'order_paid' OR wp_posts.post_status = 'order_cancelled' OR wp_posts.post_status = 'order_fraud' 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') ORDER BY EventStartDate DESC, wp_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
It appears that line 535 of the “wp-content/plugins/the-events-calendar/src/Tribe/Query.php” file sets the table for the “EventStartDate” to the wp_postmeta table, but the query itself renames that table to “tribe_event_end_date” with the “LEFT JOIN wp_postmeta as tribe_event_end_date” part of it. I had updated the plugin this morning in hopes that it would be resolved, but it appears that it is still incorrect. I can’t tell exactly where this query is being run, but it shows up in my error log frequently enough. The plugin seems to run just fine otherwise.

[Sky]

Hi Jeffrey,

Thanks for reaching out to us. We generally don’t handle support issues here in the Pre Sales forum. If you have a license for one of our premium plugins, you can log in with the account associated with it to our premium support forums. Otherwise, you can report issues for the Events Calendar in the WordPress.org support forums for the plugin.

Thanks!
Sky

[Support Droid]

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

[Author]

Posts