Mass Delete Comments Awaiting Moderation

  • I have looked for plugins, looked at different ways to do this by manually working with phpmyadmin, and in the past just took the time to delete every post at a time. But having left that aside for some time.. now:

    Awaiting Moderation (282125)

    I can barely read that number.. much less get on deleting them 25 at a time. I am sure that at least 99.8% if not all of them are actually spam and would like a feature in which with the click of one button, I can get rid of all of it…

Viewing 6 replies - 1 through 6 (of 6 total)

  • With phpmyadmin it is actually pretty simple:

    FIRST: make a backup of your database.

    The go into phpmyadmin, select your wordpress database, and click the sql tab, and enter the following query:

    SELECT *FROM wp_comments WHERE comment_approved =”0″

    that should select all 282125 records. If you get that number, then do the following query:

    delete from wp_comments WHERE comment_approved =”0″

    That should delete all pending comments.

    You may want to run a repair on your db files after that big delete, just in case.

    Thread Starter Juan Eduardo

    (@reynard)

    that worked perfectly. thank you very much : )

    still an idea for a future version of wordpress to have a button to do so from the dashboard. Anyhow, ty : )

    I have long since figured out that wordpress upgrades are all about flashy boxes and neat-o fonts, and not as much about offering tools that are sometimes needed (like deleting large numbers of comment spam that gets past the filters). If you are running wordpress and don’t have phpMyAdmin installed somewhere (or have direct access to log into mysql) then you can get really stuck.

    What if you use wordpress and not PHPmyadmin??

    rawalex, that worked great – thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Mass Delete Comments Awaiting Moderation’ is closed to new replies.