Support

June 29, 2023 at 7:02 am

Hi Tony, It is a archive-espresso_events.php template file in the root of the theme with <?php if (have_posts()): ?> so I think it’s just the standard archive loop. There may be some functions altering the loop like this one: https://gist.github.com/joshfeck/103efd299ce615188e978293a1254eeb

Thanks

June 29, 2023 at 10:45 am

Thanks Tony. There are two events__listing containers, one is the main query, it starts:
<?php if (have_posts()): ?>

The second one sets out some $args, and then:

<?php $query = new EventEspresso\core\domain\services\wp_queries\EventListQuery( $args );
if ($query->have_posts()) : ?>

June 30, 2023 at 4:52 am

Thank Tony. I installed Query Monitor, and it’s showing a 1066 error (Not unique table/alias: ‘tl_esp_datetime’) due to FacetWP. If I disable FacetWP the order is correct, but I have to disable <?php echo facetwp_display( 'pager' ); ?> for the page to load.

Query Monitor shows me that this is the database query with the error, but I have no idea how to edit it:

SELECT tl_posts.ID, tl_esp_datetime.* , MIN( tl_esp_datetime.DTT_EVT_start ) as event_start_date , tl_esp_datetime.* , MIN( tl_esp_datetime.DTT_EVT_start ) as event_start_date , MIN( tl_esp_datetime.DTT_EVT_start ) as event_start_date
FROM tl_posts
INNER JOIN tl_postmeta
ON ( tl_posts.ID = tl_postmeta.post_id )
INNER JOIN tl_postmeta AS mt1
ON ( tl_posts.ID = mt1.post_id )
INNER JOIN tl_postmeta AS mt2
ON ( tl_posts.ID = mt2.post_id )
INNER JOIN tl_esp_datetime
ON ( tl_posts.ID = tl_esp_datetime.EVT_ID )
INNER JOIN tl_esp_datetime
ON ( tl_posts.ID = tl_esp_datetime.EVT_ID )
WHERE 1=1
AND ( tl_postmeta.meta_key = 'start_date'
AND ( ( mt1.meta_key = 'is_this_an_external_event'
AND mt1.meta_value != '1' )
AND ( mt2.meta_key = 'end_date'
AND CAST(mt2.meta_value AS DATE) >= '2023-06-30' ) ) )
AND ((tl_posts.post_type = 'espresso_events'
AND (tl_posts.post_status = 'publish'
OR tl_posts.post_status = 'acf-disabled'
OR tl_posts.post_status = 'cancelled'
OR tl_posts.post_status = 'postponed'
OR tl_posts.post_status = 'sold_out'
OR tl_posts.post_status = 'private')))
AND tl_esp_datetime.DTT_EVT_end > '2023-06-30 10:27:25'
AND tl_esp_datetime.DTT_EVT_end > '2023-06-30 10:27:25'
AND tl_esp_datetime.DTT_EVT_end > '2023-06-30 10:27:25'
GROUP BY tl_posts.ID
ORDER BY tl_posts.menu_order, event_start_date ASC

So I guess FacetWP is the culprit, and perhaps I should raise it with them. I need to prevent FacetWP interfering with this query, since FacetWP isn’t even used on this page!

Thanks for your help.

June 30, 2023 at 8:35 am

Yes, multiple times, but I have no idea how to change that.

However, I fixed it with help from FacetWP support and this snippet they sent for another event plugin https://gist.facetwp.com/gist/gist-ea65868cf1d314990872f85f6dfc90f1/

Sorry, when I said FacetWP wasn’t being used on the page, I meant there was no filtering of events on this page (which is what FacetWP does).

Thanks again for your help.

June 30, 2023 at 9:24 am

Yes, that’s right. It works well, no database error, and events are ordered correctly.

Thanks again for your help.