Same event is repeating mutliple times for logged in users
-
This is on the live and staging sites, but we didn’t see the issue until it was already live.
When a logged in user views the events page.. they’re getting a TON of duplicates of the same entry.. but non-logged in users aren’t
The query looks like this
SELECT SQL_CALC_FOUND_ROWS 9zaIm3WX_posts.ID FROM 9zaIm3WX_posts LEFT JOIN 9zaIm3WX_postmeta ON ( 9zaIm3WX_posts.ID = 9zaIm3WX_postmeta.post_id AND 9zaIm3WX_postmeta.meta_key = 'allowed_roles' ) LEFT JOIN 9zaIm3WX_postmeta AS mt1 ON ( 9zaIm3WX_posts.ID = mt1.post_id ) LEFT JOIN 9zaIm3WX_tec_occurrences ON 9zaIm3WX_posts.ID = 9zaIm3WX_tec_occurrences.post_id WHERE 1=1 AND ( ( 9zaIm3WX_postmeta.post_id IS NULL OR ( mt1.meta_key = 'allowed_roles' AND mt1.meta_value IN ('administrator') ) ) ) AND ((9zaIm3WX_posts.post_type = 'tribe_events' AND (9zaIm3WX_posts.post_status = 'publish' OR 9zaIm3WX_posts.post_status = 'acf-disabled' OR 9zaIm3WX_posts.post_status = 'tribe-ea-success' OR 9zaIm3WX_posts.post_status = 'tribe-ea-failed' OR 9zaIm3WX_posts.post_status = 'tribe-ea-schedule' OR 9zaIm3WX_posts.post_status = 'tribe-ea-pending' OR 9zaIm3WX_posts.post_status = 'tribe-ea-draft' OR 9zaIm3WX_posts.post_status = 'private'))) ORDER BY 9zaIm3WX_posts.post_date DESC LIMIT 0, 10
I’m getting the same post ID for the first 66 results (the number of postmeta entries). It looks like the query needs a group by.
Viewing 9 replies - 1 through 9 (of 9 total)
Viewing 9 replies - 1 through 9 (of 9 total)
- The topic ‘Same event is repeating mutliple times for logged in users’ is closed to new replies.