Delete an obsolete WordPress user

  • Resolved wpguillaume

    (@wpguillaume)


    4 years, 5 months ago

    Hello,

    In our MailPoet WordPress users’ list, one entry contains an obsolete e-mail address.
    This address used to be associated to a WordPress user, but this user changed their e-mail address, and this change didn’t affect the MailPoet user.
    From the MailPoet interface, the user is greyed out and I can’t change or remove it.

    Is it safe to delete the user entry from the mailpoet_subscribers table in the associated database? If it is, should I delete other associated entries from the mailpoet_subscriber_custom_field, mailpoet_subscriber_ips, mailpoet_subscriber_segment or mailpoet_user_flags tables?

    Anything else I could/should do to clean this properly?

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Peter Smits

    (@psmits1567)

    4 years, 5 months ago

    It can be done easier if you have access to the subscriber table. Just remove the wordpress user value from this table. Then this user is not greyed out anymore. You should be able to remove it from mailpoet

    Thread Starter wpguillaume

    (@wpguillaume)

    4 years, 5 months ago

    Do you mean removing the wp_user_id from the mailpoet_subscribers table?

    I realize it might even be a way for me to empty the WordPress users’ list. Some people in there are considered inactive, when I believe they are not. We mistakenly used this WordPress users’ list to send an email once or twice, and these people may not have opened these emails, making them inactive.
    But then I assume they won’t receive the mails from the other lists they are subscribed to.
    (Not sure I make much sense or that I am right, here, though. :))

    Peter Smits

    (@psmits1567)

    4 years, 5 months ago

    Yes that is correct, if you look at the contents of this table, you will see that the subscribers that can be deleted do not have a value present.
    I had a simular problem after importing subscribers, which did put a value 0 into this field. Then you cannot remove the subscriber also.
    Making a subcriber inactive is done by setting a different field in this table.
    I do not know if wordpress is using the subscriber table to check the connection.
    If so then indeed this is the way to make it possible to delete inactive wordpress users also.

    Thread Starter wpguillaume

    (@wpguillaume)

    4 years, 5 months ago

    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Delete an obsolete WordPress user’ is closed to new replies.