Mysql error when searching for events in administration

[Geir Hagen]

When searching for events in administration, it always returns no results. After analyzing the situation, i found out this query fails with this error: Unknown column ‘wpmast_postmeta.meta_value’ in ‘where clause’ , Any ideas?

Query that fails:
SELECT SQL_CALC_FOUND_ROWS DISTINCT wpmast_posts.*, tribe_event_start_date.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate
FROM wpmast_posts
LEFT JOIN wpmast_postmeta as tribe_event_end_date
ON ( wpmast_posts.ID = tribe_event_end_date.post_id
AND tribe_event_end_date.meta_key = ‘_EventEndDateUTC’ )
LEFT JOIN wpmast_postmeta AS tribe_event_start_date
ON wpmast_posts.ID = tribe_event_start_date.post_id
AND tribe_event_start_date.meta_key = ‘_EventStartDate’
WHERE 1=1
AND (((wpmast_posts.post_title LIKE ‘%vinterserie%’
OR ( wpmast_postmeta.meta_value LIKE ‘%vinterserie%’ ))
OR (wpmast_posts.post_excerpt LIKE ‘%vinterserie%’)
OR (wpmast_posts.post_content LIKE ‘%vinterserie%’)))
AND wpmast_posts.post_type = ‘tribe_events’
AND (wpmast_posts.post_status = ‘publish’
OR wpmast_posts.post_status = ‘tribe-ea-success’
OR wpmast_posts.post_status = ‘tribe-ea-failed’
OR wpmast_posts.post_status = ‘tribe-ea-schedule’
OR wpmast_posts.post_status = ‘tribe-ea-pending’
OR wpmast_posts.post_status = ‘tribe-ea-draft’
OR wpmast_posts.post_status = ‘future’
OR wpmast_posts.post_status = ‘draft’
OR wpmast_posts.post_status = ‘pending’
OR wpmast_posts.post_status = ‘private’)
ORDER BY tribe_event_start_date.meta_value DESC, tribe_event_end_date.meta_value DESC, wpmast_posts.post_date DESC
LIMIT 0, 200

Versions:

WP: 4.6
The events calendar : 4.3.4.1 and 4.3.3
The events calendar pro: 4.3.3
The events calendar – Filter Bar: 4.3.3

[Hunter]

Hello,

Welcome back to the premium plugin support forums and sorry to hear you’re experiencing a conflict. I am unable to reproduce the behavior you’ve shared with me and I’m not seeing any logged bugs reflecting your issue. Before we proceed, can you confirm you’ve reviewed our Testing for conflicts guide? If not, please do so and reply back with what you find.

We are unable to provide support for theme and plugin conflicts, so without the ability to reproduce the behavior and no with users reporting similar behaviors is a sign there is a potential conflict somewhere in your website environment.

Thanks and have a great day. Cheers!

[Geir Hagen]

Yes, it was the magic-fields plugin that did modify the search query. Thanks.

[Hunter]

Glad to hear things are worked out! I’ll close this thread out but feel free to create a new one if you have any more questions. Cheers!

[Author]

Posts