gwdev123

Oh wow, I must’ve clicked the wrong link from the WordPress dashboard and didn’t double check. Sorry about that! And the
Constant Contact + WooCommerce plugin is working as expected. Thanks!

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