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.

About Our Sponsor: Advertise Me

Advertise Me is a privately owned Australian company specialising in all aspects of digital signage solutions.

Our team of highly skilled professionals is able to introduce innovative ways for businesses to communicate with their intended audiences for a variety of purposes including informing, educating, entertaining and selling.

You can expect us to:

offer the most affordable and cost effective solutions tailored to your specific business needs.
provide you with concise and accurate information and will ensure that you understand and are comfortable with our proposals.
strive to make our clients happy and successful.

We have partnered with a number of key reputable organisations and will continue to build further partnerships to deliver the most effective solutions for our customers.

Visit our website at www.advertiseme.com.au for more information.

Tweet This Post