Cancel or Delete Attendance for Events +

I cannot delete the admin (me) from the event RSVP. When I click "Cancel Attendance" or "Delete Attendance Entirely" nothing happens. When I do it to other users, who have not yet paid for the event, it updates properly and removes them from the rsvp.

I have ran a theme conflict and plugin conflict test. The problem is still present. We have done a lot of customization to this site....

Support access is active.

I was having a similar problem last year and you guys gave me a function code that still works but it removed everyone from the event.
`
//Clear events RSVP's
global $wpdb;
$event_id = 7107; // Enter event ID here from where you want to delete all RSVPs
$wpdb->delete( Eab_EventsHub::tablename(Eab_EventsHub::BOOKING_TABLE), array( 'event_id' => $event_id ) );

Any help on how I can remove a specific person including the admin...

Thanks,
William

  • Adam Czajczyk
    • Support Gorilla

    Hello William,

    I hope you're well today and thank you for your question!

    I have accessed your site and checked this but I couldn't replicate this there.

    First, I went to "Events -> Events" page and edited the "Test Event" event where I
    - clicked on "Cancel attendance" link (the user got "moved" to "No" - meaning no attendance)
    - clicked on "Delete attendance entirely" link (the user got removed).

    Since using support access feature I'm logged in as an admin (the same account that you are trying to remove according to the screenshot attached to your post), I was able to "remove myself" from RSVP list. That worked as expected.

    Second, I created a new event "Test Event 2" and added myself (your admin account) as attending there. Then, I used only the "Delete attendance entirely" link and got removed again.

    It seems to be working fine for me then. I noticed however that you are using a Membership 2 Pro plugin on the site. Have you been making changes to it recently? I'm asking this because if you were using the "Test membership" module it may have cause unexpected issues when trying to change settings/remove RSVP's while in "Test membership" mode.

    Could you please clear your browser's cache and give it another try?

    Best regards,
    Adam

  • Dimitris
    • Support Star

    Hey there William,

    hope you're having a beautiful day and don't mind skipping in! :slight_smile:

    Could you please re-grant us with support access through your WPMU DEV Dashboard? Every session auto expires for security reasons, so now I can retest this.
    More details can be found in our manual section here https://premium.wpmudev.org/manuals/wpmu-dev-dashboard-enabling-staff-login/

    After doing so, please notify us here as we don't have any automated notification system whenever a member grants access for us. :slight_smile:

    Warm regards,
    Dimitris

  • William
    • Syntax Hero

    Hello Dimitris,

    We are putting this issue on hold right now as its not majorly effecting our day to day workflow. Its just a weird bug that we have been having issues with for over a year and I thought it would be an easy/quick fix.

    Thanks,
    William

    • Predrag Dubajic
      • Support

      Hi William,

      Looks like Milan jumped in while I was looking with a possible solution for this with one of our devs, so here's an update and possible solution. :slight_smile:

      Can you try adding this code to your child theme functions.php:

      function wpmudev_rm_user_rsvp( $user_id, $event_id = '' ){
      
      	if( !$user_id || !is_numeric( $user_id ) ) return false;
      	global $wpdb;
      
      	$bookings_tbl = Eab_EventsHub::tablename(Eab_EventsHub::BOOKING_TABLE);
      
      	$where = array( 'user_id' => $user_id );
      	$format = array( '%d' );
      
      	if( $event_id != '' && is_numeric( $event_id ) ){
      
      		$where['event_id'] = $event_id;
      		$format[] = '%d';
      
      	}
      
      	$wpdb->delete( $bookings_tbl, $where, $format );
      
      }

      After that you should be able to use this code to remove USER_ID from EVENT_ID:
      wpmudev_rm_user_rsvp( $user_id, $event_id );

      Or this to remove specific USER_ID from all events:
      wpmudev_rm_user_rsvp( $user_id );

      Hope this helps :slight_smile:

      Best regards,
      Predrag

  • Milan
    • WordPress Wizard

    Hello William

    Sorry to hear about that. But if you noticed its not happening on our end so we need some further debugging to find why its taking place on your site. And for that we requires staff access to your site. :slight_smile:

    Other option is that you create staging site of your live site and grant us staff access there. :slight_smile:

    Best Regards,
    Milan

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.