|
kpyles
|
April 23, 2024 at 8:26 am
Hello,
The last two updates were not compatible with the Events Grid View Template. Is this being addressed by the developers?
Thanks
Kevin
|
|
Sam
|
April 23, 2024 at 11:31 am
Hi Kevin,
Can you please let us know the issue you are facing with the Grid view Template?
Also, please share a direct link to the so that we can check that for you.
Looking forward to helping you.
|
|
kpyles
|
April 24, 2024 at 12:53 pm
When upgrading to 5.0.18 or 5.0.19 the grid does not display.
If i turn debugging on i get:
WordPress database error: [Not unique table/alias: ‘wp0s_esp_datetime’]
SELECT SQL_CALC_FOUND_ROWS wp0s_posts.*, wp0s_esp_datetime.* , MIN( wp0s_esp_datetime.DTT_EVT_start ) as event_start_date FROM wp0s_posts INNER JOIN wp0s_esp_datetime ON ( wp0s_posts.ID = wp0s_esp_datetime.EVT_ID ) INNER JOIN wp0s_esp_datetime ON ( wp0s_posts.ID = wp0s_esp_datetime.EVT_ID ) INNER JOIN wp0s_esp_datetime_ticket AS Datetime_Ticket ON ( Datetime_Ticket.DTT_ID=wp0s_esp_datetime.DTT_ID ) INNER JOIN wp0s_esp_ticket AS Ticket ON ( Datetime_Ticket.TKT_ID=Ticket.TKT_ID ) LEFT JOIN wp0s_term_relationships ON (wp0s_posts.ID = wp0s_term_relationships.object_id) LEFT JOIN wp0s_term_taxonomy ON (wp0s_term_relationships.term_taxonomy_id = wp0s_term_taxonomy.term_taxonomy_id) LEFT JOIN wp0s_terms ON (wp0s_terms.term_id = wp0s_term_taxonomy.term_id) WHERE 1=1 AND ((wp0s_posts.post_type = ‘espresso_events’ AND (wp0s_posts.post_status = ‘publish’ OR wp0s_posts.post_status = ‘cancelled’ OR wp0s_posts.post_status = ‘postponed’ OR wp0s_posts.post_status = ‘sold_out’ OR wp0s_posts.post_status = ‘private’))) AND wp0s_esp_datetime.DTT_EVT_end > ‘2024-04-24 18:50:05’ AND wp0s_terms.slug IN (‘show-in-grid’) AND wp0s_esp_datetime.DTT_deleted = 0 AND Ticket.TKT_end_date > “2024-04-24 18:50:05” AND Ticket.TKT_deleted=0 GROUP BY wp0s_posts.ID ORDER BY event_start_date ASC LIMIT 0, 15
|
|
Tony
|
April 24, 2024 at 2:15 pm
Hi there,
That is not actually an issue with the Grid Template, it is an issue with this snippet:
https://github.com/eventespresso/ee-code-snippet-library/blob/master/templates/de_ee_filter_events_out_with_expired_tickets.php
That snippet jumps in and adds additional joins into the query without checking if the join already exists, which then causes the above issue.
That code is in use on your site somewhere, you’ll need to replace it with this version:
https://gist.github.com/Pebblo/f6999040cf2df3965c1b75ac99f9c20b
That should fix the above error.
|
|
kpyles
|
April 24, 2024 at 2:51 pm
Ok I made that change and the Event Grid now works with 5.0.19.
Thanks
|
|
Rio
|
April 24, 2024 at 6:42 pm
Awesome, if you need anything, feel free to let us know.
thanks
|
