« Two Headed Japanese Nailset - Nitoku Kugshime | Go to top page | How to Check and Adjust a Framing Square »

Movable Type Delete Spam Internal Error

Every so often I get so many junk comments that the movabletype software chokes on it and will give an "Internal Error" when I try to view or delete the spam comments. The answer is to work with the database directly and issue a SQL statement to delete them.

The hardest part is just finding out how to log into the database. Once you do that (my hosting provider provides the phpmyadmin interface, but you can query the database directly if you know the user id and login. Then just run the following command and all the bad old comments are gone.

Delete FROM `mt_comment` WHERE `comment_junk_status` = -1

I just killed off a couple thousand.

  • Preview Extractor

  • Comments (1)

    Thanks for this. I was getting the same internal error getting rid of my blog spam comments and found that this was a great way to get rid of 14,387 junk comments

    Post a comment

    (Comments are moderated to fight SPAM. Your comment will appear after I approve it. Thanks for waiting.)


    This is a single article from STUFF dated November 6, 2006.

    Recent articles are at the top page
    and a list of everything can be found in the archives.

    The previous post was Two Headed Japanese Nailset - Nitoku Kugshime.

    The next post is How to Check and Adjust a Framing Square.

    Creative Commons License
    This weblog is licensed under a Creative Commons License.
    Powered by
    Movable Type 3.34