Removing Old Subscribers From Subscribe To Comments Plugin

The Subscribe to Comments plugin is a plugin that enables commenters to sign up for e-mail notification of subsequent comments. It’s a great way to engage your users and get them to come back to your site. I’ve been a loyal user since 2006, and the only problem I’ve faced is that I’ve now got a TON of people subscribed to posts that are VERY old. Over time, people’s e-mail addresses change, and all of a sudden I’m getting bounced e-mails from the plugin.

Subscribe to Comments has an admin screen under the Tools section of the Dashboard, but it requires you to manually select each subscriber, wait for the page to load, tick the checkbox next to any/all posts to which they have subscribed, and click “Remove Selected Subscription(s)”. Then return to the list and wash, rinse, repeat.

Imagine if you’ve got a spammer subscribing to hundreds of posts, using random fake e-mail addresses.. Total nightmare!

I Googled around looking for a way to manipulate the database to make this process easier. And I stumbled across this great post on Perishable Press that gave me a great solution.

Using phpMyAdmin or equivalent, execute the following customized query:

SELECT `comment_post_ID` , `comment_ID` , `comment_author_email` , `comment_subscribe`
FROM `wp_comments` WHERE `comment_subscribe` = 'Y'
LIMIT 0 , 100

This will return a nice table listing the comment ID, post ID, and email address for every comment subscriber. Simply scan the list for spam entries, tick the associated checkbox, and click the “Delete” button.

(The Delete button is the red X to the right of the “Check All / Uncheck All” verbage at the bottom of the list.. Don’t feel bad, I couldn’t find it at first either.)

Problem solved! Hope this helps..

Enjoyed this post?
Subscribe to Zander Chance via RSS Feed or E-mail and receive daily news updates!

Submit to Digg  Stumble This Story  Share on Twitter  Post on Facebook  Post on MySpace  Add to  Submit to Reddit  Fave on Technorati

Leave a Reply