Error on screen after Full Name Search

I am not sure where this is coming from but it looks like WP Query is not working with MariaDB. I do not see anything wrong with the query either.

Well I would love to buy your pro version but I’m not paying money for something that is already broken. I’m running on CentOS7. Does that have anything to do with it? Here is the error when searching for Chad Kersten.

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”’ AND (wp_postmeta.meta_value >= ‘2016-06-13 11:29:29′ OR (wp_postmeta.meta_val’ at line 3]
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) 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_postmeta.meta_key = ‘_EventStartDate’ ) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_author = 2 AND wp_posts.post_status = ‘private’) AND wp_posts.post_title ” AND (wp_postmeta.meta_value >= ‘2016-06-13 11:29:29’ OR (wp_postmeta.meta_value <= ‘2016-06-13 11:29:29’ AND tribe_event_end_date.meta_value >= ‘2016-06-13 11:29:29’ )) GROUP BY wp_posts.ID ORDER BY EventStartDate ASC, wp_posts.post_date ASC LIMIT 0, 10

It looks like the error is related to The events calendar plugin:

https://www.ads-software.com/plugins/the-events-calendar/

If you look at the query, you see tribe_event_end_date, tribe_event_end_date.post_id etc.

After investigating a little bit more, we were able to find the issue. It happens only in full name search if there is an events calendar widget on the same page. We will fix it in the next release.(V.3.0.1). Thanks for reporting.