Blocked comment in my blog but turned to mysql to fix it
I am not sure why it happened but my blog which is on MT3.2 and can't be moved because net firms refuses to do whatever it takes to let me get up to MT4 or greater stopped working suddenly. This wouldn't be a problem if I didn't need to log important things like the following:
I realized that Rusty in National Lampoon's Christmas is now in the Big Bang Theory playing Leonard. This was very hard to do and I dare any computer program in the next 40 years to repeat such a feat. He also happened to have been in Rosanne and the girl kid in Rosanne is also in the Big Bang Theory. I sense a conspiracy.
I also realized that Lawrence Fishburne played a weird cowboy in Pee Wee's playhouse. Possibly a part of the same conspiracy.
Zachary is saying things through utterances including - a-pl for apple, sh for shoe, t for tree, and is always saying uh-oh for dropped food. He uses signs to communicate that he wants to be picked-up by pointing up and clapping when he wants more of something. It was great to see him say a-pl this morning and point to the apple on the counter. He doesn't say mommy or daddy yet.
Madeline is able to create complex scenarios planning for things. For example when in the hot tub she will say something like "You will go inside and get a towel then pick me up and dry me off and then I will wait while you go back and close the hot tub then I will eat a banana. She also tried to help out when the van broke down on the side of the road with useful suggestions like "maybe the engine is broken? maybe the engine is sad? Someone should pick-us up and drive us home!".
So the solution to fixing my Movable type install was to go through mysql in the admin module and delete all the comments that had been created by the spambots but were sitting in the database. I just ran something like delete from mt_comments where visible=0 which took care of dropping every record that I hadn't approved for view by people.