CDB cat dog-egories:

April 14, 2005

Note: CogDogBlog has a new WordPress powered home at All entries from this version have been moved there, so as a guide dog service try finding this article in its new home by title search.

The Dog Barfed Up Some Comments

Although I noted yesterday that my own technical gaffs had erase all of our blog comments going back to September 2004, I did comb through the last database dump from early March 2005 and sifted out the legit comments for Sept 2004 - March 3, 2005, so the loss was the last month and a half.

It was fairly trivial with BBEdit to semi-manually sift out all the spam roach poop. There were a total of 1947 rows in the comment table of the database (for about 6 blogs, mostly inactive) and out of those, I deleted 1662 spammies, easily identified by their repeated patterns, url encrusted comments, and general stench. There were sequences of more than 150 in quick succession to a dormant blog (which is now fenced off).

And the captcha security code on the comment form is working like a dream, perfection, baby.

blogged April 14, 2005 03:26 PM :: category [ using mt ]
Comments About "The Dog Barfed Up Some Comments"
RSS Feed for comments on this entry
RSS Feed for all CDB comments
Spammers Have Force Our Hands...
Note: Those nasty blog-spamming roaches have forced us to take action to prevent their spread- all entries made to this blog will remain open for comments for 30 days after the original posting date. After that, it is old news anyhow, correct?

If you really need to make contact with the chief dog around here, please submit a request via our feedback center