Weekend Fun: Cleaning up our spam comments

Sunday, January 24th, 2010 at 7:30 pm by DigitalSignageBlog, 0 Comments »

Besides the hot and then rainy weather in Sydney Australia, we thought we’d do something crazy and clean up our spammed comments since it was taking up a considerable amount of space in our database. We had 23,123 comments marked as spam since the beginning of last year and most of them were not relating to digital signage. The process of cleaning up this spammed comments in Wordpress isn’t as straight forward as I thought it would be. Under the Edit Comments section there is a button called “Empty Spam”. Obviously I want to empty these comments so when I click on the button the process seems to time out… probably due to the number of spam comments. I basically end up getting a white page after about 40 seconds. When I logged back in to see how many spam comments were removed, the system somehow managed to remove about 1000 comments before it timed out – that’s what I’m guessing happened. If you do the maths, I had to do this about 20 times and I also just calculated that the ratio of the number of post to the number of spam comments is approximately 1:107 – this is a large number?

So, to avoid this in future we will aim to remove spam comments on a monthly basis and please… don’t spam our digital signage blog. We have noticed several businesses adding their website links in their comments, although we don’t prevent you from doing so or added a plugin feature to automatically remove these, it does look a “bit” obvious on what you’re trying to do.

Tweet This Post