Can’t mass delete spam

  • camilamaria

    (@camilamaria)


    17 years, 8 months ago

    Out of the blue my blog got a lot, but A LOT of spam!
    I have 3.672 comments awaiting moderation!!! All I am able to do is mark them as spam 20 at once! i can’t find a place to mass delete it or to mass mark as spam! How do I do it? I can’t delete more than 3000 spams 20 by 20!!!

Viewing 1 replies (of 1 total)
  • Len

    (@lenk)

    17 years, 8 months ago

    Just curious, are you using Akismet? If not you should. It comes included with WordPress. If for some reason you don’t have it you can get it here. Also, download and install Bad Behaviour which will prevent many malicious/spam bots from even accessing your site.

    To get rid of the comments awaiting moderation you could run a query. First, access your database via phpMyAdmin. Second, make a backup of your database just in case. Third, select your database then click the SQL tab and enter this query …

    SELECT *FROM wp_comments WHERE comment_approved ="0"

    This will bring up all comments awaiting moderation. When it does run this query …

    delete from wp_comments WHERE comment_approved ="0"

    That should delete all comments awaiting moderation. You may want to run a repair on the database after that.

Viewing 1 replies (of 1 total)

The topic ‘Can’t mass delete spam’ is closed to new replies.