Sunday, February 01

Life

Avoiding Work

http://dragcave.net/image/eohI.gif

Making omelettes.

Posted by: Pixy Misa at 01:03 PM | Comments (12) | Add Comment | Trackbacks (Suck)
Post contains 4 words, total size 1 kb.

1 Sorry to interrupt your cooking, but when I try to despam using the blacklist it says:
jayallen::Blacklist=HASH(0x93d0f10) DBD::mysql::st execute failed: Table 'mt_comment' is marked as crashed and should be repaired at lib/MT/ObjectDriver/DBI.pm line 43.
jayallen::Blacklist=HASH(0x93d0f10) DBD::mysql::st bind_columns failed: Statement has no result columns to bind (perhaps you need to successfully call execute first) at lib/MT/ObjectDriver/DBI.pm line 44.
jayallen::Blacklist=HASH(0x93d0f10) DBD::mysql::st fetch failed: fetch() without execute() at lib/MT/ObjectDriver/DBI.pm line 46.

Posted by: Susie at Monday, February 02 2009 06:16 AM (DJD/F)

2 Okay, that's really weird.  The mt_comment table isn't marked as crashed - we'd have noticed that instantly, because everything would have fallen over.

I'll see if I can work out what's going on.

Posted by: Pixy Misa at Monday, February 02 2009 09:04 AM (PiXy!)

3 I'm more and more glad that I decided to require registration for comments. I haven't had a single spam comment.

Posted by: Steven Den Beste at Monday, February 02 2009 09:33 AM (+rSRq)

4 I think it's the content of the comments--they are weird characters/symbols. The blacklist will work for the most recent spam comments, but I get that error message for the older ones (when I search higher numbers of comments). Munuviana had about 3000, and I've been deleting them post by post. There's about a thousand on PP that I haven't gotten to, because it's darned tedious!

Posted by: Susie at Monday, February 02 2009 12:16 PM (DJD/F)

5 Off topic.

What is the damn link to the damn white paper for the .nu domain?

Posted by: wickedpinto at Monday, February 02 2009 06:06 PM (ul7te)

Posted by: Pixy Misa at Monday, February 02 2009 10:10 PM (PiXy!)

7 No luck fixing the Blacklist so that it will zap that spam?

Posted by: Susie at Tuesday, February 03 2009 12:05 AM (DJD/F)

8 I did manage to reproduce it, so I'm running a table repair now.  Should be fixed in a few minutes...

Posted by: Pixy Misa at Tuesday, February 03 2009 07:54 AM (PiXy!)

9 There you go, all fixy-uppied. smile

Posted by: Pixy Misa at Tuesday, February 03 2009 07:59 AM (PiXy!)

10 Yay! Thank you so much! I had to go back sixty thousand comments to get it all, though. We really must have gotten hit these last few days....

Posted by: Susie at Tuesday, February 03 2009 09:54 PM (DJD/F)

11 I deleted 17,000 spams myself, and there's plenty more to go. sad

Posted by: Pixy Misa at Tuesday, February 03 2009 10:26 PM (PiXy!)

12 Thats it, thanks pixy.

Posted by: Wicked Pinto at Sunday, February 08 2009 05:33 PM (ul7te)

Hide Comments | Add Comment

Comments are disabled. Post is locked.
48kb generated in CPU 0.0149, elapsed 0.1142 seconds.
56 queries taking 0.1047 seconds, 349 records returned.
Powered by Minx 1.1.6c-pink.