Bulk delete Spam in umbraco

Thursday, April 30, 2009 by Philip

Someone found it funny to add 6000+ spam messages to some of my blog entrys. Umbraco chokes on that abount of replies, and besides it makes no sense having to manually delete each post individually.

I fixed this by running a SQL that moved the bad appels to the Recycle Bin, using the following SQL:

update umbracoNode
set parentid=-20
WHERE (parentID = 1201)
AND (createDate > CONVERT(DATETIME, '2009-01-01 00:00:00', 102))

After that: Just empty the trash.

Well that was what I thought. But for some reason Umbraco deletes each message individually, and uses a lot of connections doing so. In fact I had to change the default (100) to 300 (260 connections was used according to perfmon) in order for the empty trash to complete. And it still took it's bloddy time.

By the way: To cange "Max Pool Size" add this to umbracoDbDSN in Web.config: ;Max Pool Size = 300

Guru meditation

Friday, October 26, 2007 by Philip

While browsing around at piratebay.org I got the following error message:

Error 503 Service Unavailable
Guru Meditation: XID: 236506462

Guru meditation... Well that brings back a lot of happy memories of crashing my Amiga 500. :D

Growing up

Monday, August 13, 2007 by Philip

A few years ago, I was talking with my farther, just after my wife had given birth to our son. I was adjusting to life as a farther, and wanted some advice from him.

I was wondering: When do you feel like a "grown up". I had just been through this life changing event, and I wasn't feeling any different. In fact I was still feeling like a large child.

My farther smiled and said: So do I.

At the time he was almost 80 years old.

 

Network blues

Sunday, August 12, 2007 by Philip

The other day, my whife came home with an "Age of Empires Collector" DVD containing AoE I+II and expantion packs. Pure retro!

My wife and I usually just play cooperative games against computer opponents, so one of us created a game and the other tried to join. No luck!

Then I began the troubleshooting:

  • Disabling firewall
  • Testing DirectPlay using dxdiag (Checked out OK)
  • Analyzing log on internet router (DLink DGL-4300).
  • IP Packet analyze using Ethereal.
  • A lot of Google!

Nothing helped, and my temper was quickly reaching the red zone... 

Finally while being at a birthday party, it dawned on me. The problem might be physical! The internet router I use only has 4 Lan ports, so some network devices are connected using an old noname 8 port 10/100 switch. As it happens, I was connected directly to the router, and my wife through the switch. As soon as we were connected to the same physical device it worked.

Lesson learned!

Update! Seems like a computer that has been in stand-by or hibernation can be causing similar symptoms as described above.