Events Made Easy Forums How do I … Cleanup actions

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #62736
    Anonymous
    Inactive

    Hi,

    i finaly made my first Event with EME 🙂 All is woking fine so far 🙂
    But 😉

    Now my Setup:
    Automatically anonimyze old bookings after 24h >> Check
    Automatically remove old events after 48h >> Check

    Now i Want to remove the personal Data by using >> Cleanup actions

    Now my Problem: When i use ”Set status of people who are no longer referenced in bookings, groups or memberships to trash” to apply, no Person is set to the Bin.

    What i do wrong?

    BR Peter

    #62738
    Franky
    Keymaster

    I’m not quite sure what you mean here. “Trash” and “bin” are synonyms …

    #62741
    Anonymous
    Inactive

    The Recycle Bin.

    #62743
    Franky
    Keymaster

    Ok, that means that the people are still referenced in a booking (for any event, even in the past), a group or a membership. You can always try the sql yourself:

    SELECT person_id FROM wp_eme_people WHERE person_id NOT IN (SELECT person_id FROM wp_eme_bookings) AND person_id NOT IN (SELECT person_id FROM wp_eme_members) AND person_id NOT IN (SELECT person_id FROM wp_eme_usergroups) AND status > 0;

    #62744
    Anonymous
    Inactive

    True. The person still exist in the list after manual cleanup option.

    The Recycle Bin is empty.

    Okay I try 🙂

    #62745
    Franky
    Keymaster

    If you have a person id that you expect should be trashed, you can check the other tables (replace ‘xxx’ with the id of the suspected person that should go to trash):

    SELECT person_id FROM wp_eme_bookings WHERE person_id=xxx
    SELECT person_id FROM wp_eme_members WHERE person_id=xxx
    SELECT person_id FROM wp_eme_usergroups WHERE person_id=xxx
Viewing 6 posts - 1 through 6 (of 6 total)
  • The forum ‘How do I …’ is closed to new topics and replies.
Scroll to Top