PHP Error: WordPress database error Incorrect DATETIME value: ” for query

I am seeing the same errors on https://www.investinmpl.org. WordPress 6.3.1, TEC 6.2.2, Events Calendar Pro 6.2.1, calendar page https://www.investinmpl.org/events/. I’ll paste a full sample error below. Thank you.

Sep 27, 09:09:29

WordPress database error Incorrect DATETIME value: '' for query
SELECT SQL_CALC_FOUND_ROWS (wp_eg65rv_tec_occurrences.occurrence_id + 10000000) as occurrence_id
FROM wp_eg65rv_posts LEFT JOIN wp_eg65rv_postmeta ON ( wp_eg65rv_posts.ID = wp_eg65rv_postmeta.post_id AND wp_eg65rv_postmeta.meta_key = '_EventHideFromUpcoming' )
JOIN wp_eg65rv_tec_occurrences ON wp_eg65rv_posts.ID = wp_eg65rv_tec_occurrences.post_id
WHERE 1=1 AND (
CAST(wp_eg65rv_tec_occurrences.start_date AS DATETIME) > ''
AND
wp_eg65rv_postmeta.post_id IS NULL
) AND wp_eg65rv_posts.post_type = 'tribe_events' AND ((wp_eg65rv_posts.post_status = 'publish')) AND (wp_eg65rv_posts.ID NOT IN (182))
GROUP BY wp_eg65rv_tec_occurrences.occurrence_id
ORDER BY wp_eg65rv_tec_occurrences.start_date ASC, wp_eg65rv_posts.post_date ASC
LIMIT 0, 1
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/the-events-calendar/src/views/v2/default-template.php'), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\Template_Bootstrap->get_v1_single_event_html, tribe_get_view, include('/plugins/the-events-calendar/src/views/single-event.php'), tribe_the_next_event_link, tribe_get_next_event_link, Tribe__Events__Adjacent_Events->get_next_event_link, Tribe__Events__Adjacent_Events->get_event_link, Tribe__Events__Adjacent_Events->get_closest_event, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, TEC\Events\Custom_Tables\V1\WP_Query\Modifiers\Events_Only_Modifier->filter_posts_pre_query, TEC\Events\Custom_Tables\V1\WP_Query\Custom_Tables_Query->get_posts, WP_Query->get_posts, QM_DB->query

I’m seeing a lot of  WordPress database error Incorrect DATETIME value: '' in the logs

the full query looks like

SELECT SQL_CALC_FOUND_ROWS (wp_tec_occurrences.occurrence_id + 10000000) as occurrence_id
FROM wp_posts
 LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' )
  JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id 
WHERE 1=1  
  AND (
     CAST(wp_tec_occurrences.start_date AS DATETIME) < ''
     AND wp_postmeta.post_id IS NULL
  ) 
  AND wp_posts.post_type = 'tribe_events'
  AND ((wp_posts.post_status = 'publish')) 
  AND (wp_posts.ID NOT IN (67146))
GROUP BY wp_tec_occurrences.occurrence_id
ORDER BY wp_tec_occurrences.start_date_utc DESC, wp_posts.post_date DESC
LIMIT 0, 1 

This is happening on requests for venue pages.

The venue page is being treated as a single event, but this is causing get_closest_event() to construct a query that references _EventStartDate which is empty on venues.

I think I can prevent the error by editing src/Tribe/Views/V2/Template_Bootstrap.php and removing the line tribe_context()->get( 'tec_post_type' ), from is_single_event()

this is the-events-calendar=6.6.0.2

• This reply was modified 9 months, 2 weeks ago by leedxw.