Event Navigation

• WordPress databasfel: [Incorrect DATETIME value: '']
  SELECT SQL_CALC_FOUND_ROWS wp_zoner_posts.*, CAST( orderby_event_date_utc_meta.meta_value AS DATETIME ) AS event_date_utc FROM wp_zoner_posts LEFT JOIN wp_zoner_postmeta ON ( wp_zoner_posts.ID = wp_zoner_postmeta.post_id ) LEFT JOIN wp_zoner_postmeta AS mt1 ON ( wp_zoner_posts.ID = mt1.post_id AND mt1.meta_key = '_EventHideFromUpcoming' ) JOIN wp_zoner_icl_translations wpml_translations ON wp_zoner_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_zoner_posts.post_type) LEFT JOIN wp_zoner_postmeta AS orderby_event_date_utc_meta ON ( orderby_event_date_utc_meta.post_id = wp_zoner_posts.ID AND orderby_event_date_utc_meta.meta_key = '_EventStartDateUTC' ) WHERE 1=1 AND wp_zoner_posts.ID NOT IN (29333) AND ( ( ( wp_zoner_postmeta.meta_key = '_EventStartDate' AND CAST(wp_zoner_postmeta.meta_value AS DATETIME) < '' ) OR ( ( wp_zoner_postmeta.meta_key = '_EventStartDate' AND CAST(wp_zoner_postmeta.meta_value AS DATETIME) = '' ) AND wp_zoner_postmeta.post_id < 29333 ) ) AND mt1.post_id IS NULL ) AND wp_zoner_posts.post_type = 'tribe_events' AND ((wp_zoner_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'sv' OR ( wpml_translations.language_code = 'sv' AND wp_zoner_posts.post_type IN ( 'kampanjer' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_zoner_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'sv' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_zoner_icl_translations t2 JOIN wp_zoner_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'sv' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_zoner_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','alb_elements','kampanjer','tribe_venue','tribe_organizer','tribe_events','portfolio' ) ) OR wp_zoner_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','alb_elements','kampanjer','tribe_venue','tribe_organizer','tribe_events','portfolio' ) ) GROUP BY wp_zoner_posts.ID ORDER BY event_date_utc DESC, wp_zoner_posts.post_date DESC LIMIT 0, 1

• WordPress databasfel: [Incorrect DATETIME value: '']
  SELECT SQL_CALC_FOUND_ROWS wp_zoner_posts.*, CAST( orderby_event_date_utc_meta.meta_value AS DATETIME ) AS event_date_utc FROM wp_zoner_posts LEFT JOIN wp_zoner_postmeta ON ( wp_zoner_posts.ID = wp_zoner_postmeta.post_id ) LEFT JOIN wp_zoner_postmeta AS mt1 ON ( wp_zoner_posts.ID = mt1.post_id AND mt1.meta_key = '_EventHideFromUpcoming' ) JOIN wp_zoner_icl_translations wpml_translations ON wp_zoner_posts.ID = wpml_translations.element_id AND wpml_translations.element_type = CONCAT('post_', wp_zoner_posts.post_type) LEFT JOIN wp_zoner_postmeta AS orderby_event_date_utc_meta ON ( orderby_event_date_utc_meta.post_id = wp_zoner_posts.ID AND orderby_event_date_utc_meta.meta_key = '_EventStartDateUTC' ) WHERE 1=1 AND wp_zoner_posts.ID NOT IN (29333) AND ( ( ( wp_zoner_postmeta.meta_key = '_EventStartDate' AND CAST(wp_zoner_postmeta.meta_value AS DATETIME) > '' ) OR ( ( wp_zoner_postmeta.meta_key = '_EventStartDate' AND CAST(wp_zoner_postmeta.meta_value AS DATETIME) = '' ) AND wp_zoner_postmeta.post_id > 29333 ) ) AND mt1.post_id IS NULL ) AND wp_zoner_posts.post_type = 'tribe_events' AND ((wp_zoner_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'sv' OR ( wpml_translations.language_code = 'sv' AND wp_zoner_posts.post_type IN ( 'kampanjer' ) AND ( ( ( SELECT COUNT(element_id) FROM wp_zoner_icl_translations WHERE trid = wpml_translations.trid AND language_code = 'sv' ) = 0 ) OR ( ( SELECT COUNT(element_id) FROM wp_zoner_icl_translations t2 JOIN wp_zoner_posts p ON p.id = t2.element_id WHERE t2.trid = wpml_translations.trid AND t2.language_code = 'sv' AND ( p.post_status = 'publish' OR p.post_type='attachment' AND p.post_status = 'inherit' ) ) = 0 ) ) ) ) AND wp_zoner_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','alb_elements','kampanjer','tribe_venue','tribe_organizer','tribe_events','portfolio' ) ) OR wp_zoner_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','alb_elements','kampanjer','tribe_venue','tribe_organizer','tribe_events','portfolio' ) ) GROUP BY wp_zoner_posts.ID ORDER BY event_date_utc ASC, wp_zoner_posts.post_date ASC LIMIT 0, 1