Mass Delete Comments Awaiting Moderation (7 posts)

  1. Juan Eduardo
    Posted 7 years ago #

    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...

  2. rawalex
    Posted 7 years ago #

    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.

  3. rawalex
    Posted 7 years ago #

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

  4. Juan Eduardo
    Posted 7 years ago #

    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 : )

  5. rawalex
    Posted 7 years ago #

    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.

  6. jackcrute
    Posted 7 years ago #

    What if you use wordpress and not PHPmyadmin??

  7. diecastfast
    Posted 6 years ago #

    rawalex, that worked great - thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.