Blog spam

How annoying! I’ve just spent about an hour trying to remove all the spam that I’ve discovered littering this blog. I didn’t realise that people were so low as to spam people’s blogs, but it seems to happen. At least, they did it to mine! There were at least two spam entries for online poker games on each and every post of mine. I spent the first 30 minutes deleting them each, one by one, before I realised that I could go into my database and run an SQL DELETE query on them. Once I’d worked out the right syntax DELETE FROM comments WHERE user_email='[email protected]'; they were all deleted in less than 0.5 second. I feel quite proud of that, to be honest.

I’ve altered the way that comments can be left on this blog, however. All comments must now be accepted by me before they appear. (Confession: I accidentally deleted a comment left on the Waxman article. Sorry!)

Published by

Gareth Saunders

I’m Gareth J M Saunders, 46 years old, 6′ 4″, father of 3 boys (including twins). Latterly, web architect and agile project manager at the University of St Andrews and warden at Agnes Blackadder Hall. Currently on sabbatical. I am a priest in the Scottish Episcopal Church, and I sing with the NYCGB alumni choir.

One thought on “Blog spam”

  1. Yes, Gareth, it’s getting daft isn’t it? Not quite on topic but… The other day I accidentally miss-typed the main PayPal URL. I missed out the first full-stop after the “www”. Surprisingly this connected with a “Casnio” site and brought up a worrying pop-up dialogue. Worrying because similar pop-ups appear when a virus is sneakily downloading in the background. Now I did a full scan afterwards and found no nasties, but it was still a worrying moment (and could be just because I run both a soft and hard firewall). And the point is – why? Being relatively knowledgable about PCs means I can recognise a threat, and the speed of broadband means a virus can download in the blink of an eye. So why should my rediculously small typing error cause such stress and tie up my PC for 45 minutes while it is virus-checked? Why do we allow web-site owners to have this ability to recognise that people occasionally miss-type, and trap them in to viewing some other content? Well because of potential “money” of course… But what an unpleasant habit.

    I’ve used a dual boot XP/Linux system before and I’m tempted to switch to Linux for web-browsing… A good move perhaps, but why should I?

    Phew! A cup of tea is needed now, I think!!

Comments are closed.