• Resolved dsawyers

    (@dsawyers)


    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)
  • Plugin Support Jaime

    (@jaimemarchwinski)

    Hi @dsawyers

    Thanks for reaching out! I’m sorry to hear that you are experiencing this issue. Are you using Event Aggregator? Are you seeing duplicate posts in the backend?

    Do you see duplicate posts if you use a default WordPress theme and have all other plugins deactivated?

    I hope that helps!

    Thanks,
    Jaime

    Thread Starter dsawyers

    (@dsawyers)

    We’re are not seeing duplicates in the backend.

    We are not using Event Aggregator. The issue still happens with a default theme (twenty nineteen).

    We are displaying in list view and it’s showing an entry for every meta value (the more meta values, the more listings) When in calendar view, it seems OK (no repeats), it’s just list view (which is our default) that’s causing the issue.

    Plugin Support Abz

    (@abzlevelup)

    Hi @dsawyers, sorry to hear about this. Let’s see what we can do here.

    Have you tried clearing caching both third-party plugins and server-side (if you have any)? It would be also helpful if you could share a direct URL to your website.

    Moreover, it would be good if you could clear transients as well and check if that makes a difference.

    Looking forward to hearing from you.

    Best,
    Abz

    Thread Starter dsawyers

    (@dsawyers)

    We don’t have any caching plugins installed.

    Deleting the transients didn’t change anything. from the query monitor, it just looks like the list view while logged in is missing a group by condition.

    I did just go through and disable all the plugins on the site and reactivate them one by one and found that the conflict seems to come from the combination of The Events Calendar and Theme My Login Restrictions (to restrict page access by role). I have no idea why this plugin would cause this specific conflict. I can provide a copy of the plugin if you’d like to take a look. I would just need a method to send the zip file to you.

    Plugin Support Abz

    (@abzlevelup)

    Hi @dsawyers, thanks for getting back to me here and for doing the initial debugging. It seems like you have a conflict here.

    I’d suggest using these membership plugins on this article which we fully support → https://theeventscalendar.com/knowledgebase/guide/the-events-calendar-membership-plugins/.

    Let me know if that helps.

    Best,
    Abz

    Thread Starter dsawyers

    (@dsawyers)

    that’s not an option at this point, we have a custom membership system and the Theme My Login and restriction is just for basic role restriction (including for the shopping cart).

    The issue only occurred with the new Event Calendar update. is there an action/hook I can use to add a group by to the event query to resolve the issue? I tried a filter but it didn’t affect the event query.

    Thread Starter dsawyers

    (@dsawyers)

    We just heard back from Theme My Login support and they were able to update their plugin to fix the conflict.

    • This reply was modified 2 years, 4 months ago by dsawyers.
    Plugin Support Abz

    (@abzlevelup)

    Hi @dsawyers, thanks for the updates, and good to know that you were able to resolve it by reaching out to the Theme Developers.

    Please do not hesitate to bump a new topic on our way, which would help us track topics/issues more efficiently. We’d be glad to help you out.

    Best,
    Abz

    Plugin Support Abz

    (@abzlevelup)

    Hey @dsawyers, this thread has been inactive for a while, so we’re going to go ahead and mark it Resolved. Please feel free to open a new thread if any other questions come up, and we’d be happy to help.

    Cheers,
    Abz

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.