“Use updated calendar designs” makes all events vanish

Hey @thewebatom

Thank you for reaching out and yikes!
As you can imagine this is not intended behavior.

Would you mind checking if there is any type of caching in place on your site? And if so, could you please empty the cache (including browser cache)?

Also, are there any customizations made to your calendar views?

Hang in there!
Geoff

Same issue for me, specifically showing up on the list view of the updated calendar designs. Upcoming events display as expected in the month view. Associated PHP error log below.

[01-Jun-2021 14:10:32 UTC] WordPress database error Not unique table/alias: 'wp_postmeta' for query SELECT  DISTINCT wp_posts.ID, CAST( orderby_event_date_utc_meta.meta_value AS DATETIME ) AS event_date_utc, CAST( orderby_event_duration_meta.meta_value AS DECIMAL ) AS event_duration FROM wp_posts  LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id 

				LEFT JOIN wp_postmeta AS orderby_event_date_utc_meta
					ON (
						orderby_event_date_utc_meta.post_id = wp_posts.ID
						AND orderby_event_date_utc_meta.meta_key = '_EventStartDateUTC'
					)
				
 
				LEFT JOIN wp_postmeta AS orderby_event_duration_meta
					ON (
						orderby_event_duration_meta.post_id = wp_posts.ID
						AND orderby_event_duration_meta.meta_key = '_EventDuration'
					)
				  WHERE 1=1  AND ( 
  wp_postmeta.post_id IS NULL 
  AND 
  ( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS DATETIME) > '2021-06-01 14:10:32' )
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY event_date_utc ASC, event_duration ASC, wp_posts.post_date ASC LIMIT 0, 13 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/vanputte/tribe/events/v2/default-template.php'), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\View->get_html, Tribe\Events\Views\V2\Views\List_View->setup_template_vars, Tribe\Events\Views\V2\View->setup_template_vars, Tribe__Repository->all, WP_Query->get_posts
[01-Jun-2021 14:10:32 UTC] WordPress database error Not unique table/alias: 'wp_postmeta' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID, CAST( orderby_event_date_utc_meta.meta_value AS DATETIME ) AS event_date_utc FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id 

				LEFT JOIN wp_postmeta AS orderby_event_date_utc_meta
					ON (
						orderby_event_date_utc_meta.post_id = wp_posts.ID
						AND orderby_event_date_utc_meta.meta_key = '_EventStartDateUTC'
					)
				  WHERE 1=1  AND ( 
  ( wp_postmeta.meta_key = '_EventStartDateUTC' AND CAST(wp_postmeta.meta_value AS DATETIME) > '2021-06-01 05:00:00' )
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY event_date_utc ASC, wp_posts.post_date ASC LIMIT 0, 10 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/vanputte/tribe/events/v2/default-template.php'), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\View->get_html, Tribe\Events\Views\V2\Views\List_View->setup_template_vars, Tribe\Events\Views\V2\View->setup_template_vars, Tribe\Events\Views\V2\View->setup_messages, Tribe\Events\Views\V2\View->upcoming_events_count, Tribe__Repository->found, WP_Query->get_posts
[01-Jun-2021 14:10:32 UTC] WordPress database error Not unique table/alias: 'wp_postmeta' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts  LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id  WHERE 1=1  AND ( 
  wp_postmeta.post_id IS NULL 
  AND 
  ( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS DATETIME) < '2021-06-01 14:10:32' )
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC LIMIT 0, 13 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/vanputte/tribe/events/v2/default-template.php'), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\View->get_html, Tribe\Events\Views\V2\Views\List_View->setup_template_vars, Tribe\Events\Views\V2\View->setup_template_vars, Tribe\Events\Views\V2\Views\List_View->prev_url, Tribe\Events\Views\V2\Views\List_View->get_past_url, Tribe__Repository->count, WP_Query->get_posts
[01-Jun-2021 14:10:32 UTC] WordPress database error Not unique table/alias: 'wp_postmeta' for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts  LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_EventHideFromUpcoming' )  LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id  WHERE 1=1  AND ( 
  wp_postmeta.post_id IS NULL 
  AND 
  ( mt1.meta_key = '_EventEndDateUTC' AND CAST(mt1.meta_value AS DATETIME) < '2021-06-01 14:10:32' )
) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC LIMIT 0, 13 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/vanputte/tribe/events/v2/default-template.php'), Tribe\Events\Views\V2\Template_Bootstrap->get_view_html, Tribe\Events\Views\V2\View->get_html, Tribe\Events\Views\V2\Views\List_View->setup_template_vars, Tribe\Events\Views\V2\View->setup_template_vars, Tribe\Events\Views\V2\Views\List_View->prev_url, Tribe\Events\Views\V2\Views\List_View->get_past_url, Tribe__Repository->count, WP_Query->get_posts

Hello.

The site is running WP Rocket caching plugin. I’ve tried clearing the cache after switching to the new visual styles, but am still not seeing any events.

Also using the list view like the user above.

There are no customizations—besides a bit of CSS—to the plugin.

Any update on this?

Updated to the newest version (5.8) and the issue with the new designs persists.

Hi there,

Thanks for reaching out!

Can you please follow the steps in this guide to test for theme or plugin conflicts that may be causing this issue: https://theeventscalendar.com/knowledgebase/k/testing-for-conflicts?

Best regards,

Marho

Found the conflict. It was this function that modifies the search results page to only show posts and products.

function aviculturehub_filter_search($query) {
	if (!$query->is_admin && $query->is_search) {
	    if ( is_search() ) {
		$query->set('post_type', array('post', 'product'));
	    }
	}
	return $query;
}
add_filter('pre_get_posts', 'aviculturehub_filter_search');

Removing it gets the calendar working again with the new styles.

Unfortunately the new styles are absolutely horrific, so I’ll be cancelling my license and swtiching to an alternative soluton if you’re going to continue forcing this update.

Why are the events pages suddenly using Helvetica? My site has its own body and paragraph font—why override it?

Why is the embedded map suddenly 25% of the container width? It used to be full width. What possible use is a 200px wide map?

What a mess.

• This reply was modified 3 years, 4 months ago by Shane Gowland.