WordPress.org

Ready to get started?Download WordPress

Forums

Subscribe2
Duplicate Email Addresses of Recent Subscribers (23 posts)

  1. marr5229
    Member
    Posted 2 years ago #

    I have noticed recently that some of my new subscribers are ending up on my list of Current Subscribers multiple times - their email address is on there 2-4 times and unnaturally inflating my subscriber count.

    I tried to remove one of the duplicates and it removed all instances of that email address.

    Are these users getting multiple post notifications? If so, how can I fix this?

    I am running version 7.0.1 and wanted to resolve this before I upgraded, as I'm about to run an important event for these subscribers and didn't want to risk losing their emails in the upgrade. (Or will updating solve this?)

    Thanks!

    http://wordpress.org/extend/plugins/subscribe2/

  2. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    I've only had this reported once before and I'm of the opinion that it's a plugin conflict or maybe an SQL database setting issue.

    Please can you provide a list of other plugins that you use so I can cress reference.

    You'll be fine upgrading the code at anytime but let me figure out how you can delete the duplicates without losing the subscriber details.

  3. marr5229
    Member
    Posted 2 years ago #

    Thanks Matty for looking into this.

    Current active plugins include:

    Akismet
    Add Font Family Dropdown to Visual Editor
    CommentLuv
    Contact Form 7
    DoFollow
    EZPZ One Click Backup
    Jetpack
    LinkWithin
    One Click Child Theme
    OZH Dropdown Menu
    Shareaholic
    Subscribe to Comments
    W3 Total Cache
    Wordpress SEO (Yoast)

  4. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    How feasible would it be for you to run without W3 Total Cache for a while? Or at least to turn the caching features down?

    That name has cropped up before and I'm wondering if SQL queries are being cached and rerun instead of updated.

  5. marr5229
    Member
    Posted 2 years ago #

    I could deactivate it.

    Would this be a test fix of preventing future duplicates?

    Also, you are still looking for a way to delete the extra emails without losing the original, right?

  6. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229

    Yes, If you can run without W3 Total Cache for a while and the duplicates stop appearing we've located the conflict. I use hyper cache without such issues.

    If this solves the does I can then start to figure out a way to quickly erase them from the database tables without losing data.

  7. marr5229
    Member
    Posted 2 years ago #

    ok - i have deactivated it. I'll update you after some more signups.

    I appreciate your help and will definitely donate to support the cause.

  8. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229

    thanks for giving this a try for me, I think I've got a few lines of code sorted now to removed the duplicates too, I just want to double check and even then I'll recommend a backup before running it.

  9. marr5229
    Member
    Posted 2 years ago #

    So I've had a few signups since disabling W3 and they have worked fine - no duplicates. Not sure if this is enough to confirm your suspicion, but it is positive.

  10. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    It's certainly a good start. Provided you are happy to, please can wee leave things as they are for another week or so and make sure the duplicate issue does not resume.

  11. marr5229
    Member
    Posted 2 years ago #

    That sounds good but it seems like a new issue has appeared.

    Subscribe2 is no longer sending email notification of new posts. I double checked to make sure I hadn't disabled the sending, and I didn't.

  12. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    I suspect that this may be due to some residual files and caching from W3 Total Cache still. Despite it being a plugin it seems that removing it is not quite as straightforward as simply deactivating and deleting.

    Have a read here if you want to completely remove it or maybe try re-activating it and see if sending resumes.

  13. marr5229
    Member
    Posted 2 years ago #

    Wow, I read that article and it is definitely above my skill and comfort level. I have updated S2 and I will reactivate W3 to see if the email duplicating and send failure continues. I'll keep you posted.

  14. marr5229
    Member
    Posted 2 years ago #

    Ok - I reactivated W3 and S2 is still not sending email notifications of new posts.

  15. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    Try going to Subscribe2->Settings on clicking Reset at the very bottom of the page. Check the number of recipients per email and the sender details too and maybe speak to your hosting provider and get them to check the logs for why the emails are rejected.

  16. marr5229
    Member
    Posted 2 years ago #

    Ok - I reset the settings to default. I don't think I had ever changed anything from default, but that did cause the email notifications to resume.

    Reactivating W3 did cause the multiple emails problem to resume.

    Do you think the not sending problem and the multiple emails is related?

    If I deactivate W3 again, do you think that will trigger the not sending problem again?

    thanks

  17. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    I suspect the non-sending was down to a corrupt or incorrect database entry for the plugin if a reset resumed sending. I think if you are going to deactivate W3TC you will need to clean it totally to ensure you are problem free, you may also need to perform another Subscribe2 reset.

  18. marr5229
    Member
    Posted 2 years ago #

    So I have determined that those persons who are on the email list multiple times are receiving multiple notification emails. Obviously this is an undesirable outcome.

    I think if there was a way I could remove the duplicates manually, I would be able to manage this. If there were duplicate signups in the future, I could just remove them by hand.

    Do you think there is a way I can delete the duplicates manually?

  19. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    Your best method would be to use something like PHPMyAdmin on your sever (usually accessed via cPanel), look in the subscribe2 table and remove the duplicates there.

    Running this SQL may help identify duplicates altho you may need to change the table prefix.

    SELECT * FROM wp_subscribe2 AS a INNER JOIN wp_subscribe2 AS b ON a.email=b.email WHERE a.id <> b.id

  20. marr5229
    Member
    Posted 2 years ago #

    Ok, I'm able to get into the table and delete the duplicate entry, but I'm not sure which entry to leave. Say there are three instances of an email, one of them will be labeled "0" in the "Active" column, and the other two would be labeled "1."

    Does it matter which two I delete?

  21. marr5229
    Member
    Posted 2 years ago #

    ...I forgot to add, the entry marked "O" is always the lowest sequential in order in the "ID" column.

  22. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    You need to delete the one labelled as "0" in the active column and leave just one of the rows where active is "1".

  23. mattyrob
    Member
    Plugin Contributor

    Posted 2 years ago #

    @marr5229,

    In W3TC can you try turning off database and object caching if they are enabled. Then see if this stops further duplicates.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags