WordPress.org

Ready to get started?Download WordPress

Forums

can I delete spam comments (8 posts)

  1. sbysky
    Member
    Posted 7 years ago #

    by using "PhpMyAdmin", I checked my database. In "wpblog_comments", I found there are many comments marked as "spam". I want delete these ones but have no experience. Could you tell me if it's safe that I delete these items in "PhpMyAdmin"? Thanks:-P

  2. Samuel B
    moderator
    Posted 7 years ago #

    Why not delete them from your WordPress admin panel?

  3. sbysky
    Member
    Posted 7 years ago #

    When moderate the comments in the WordPress admin panel, i have marked these comments as "spam". So I can't see them at all in the WordPress admin panel. That's why I want delete them from tool PhpMyAdmin. I just want to know whether it's safe to delete them directly from the database. thanks

  4. sbysky
    Member
    Posted 7 years ago #

    Does anybody can answer this question? Thank you very much

  5. pizdin_dim
    Member
    Posted 7 years ago #

    Yes, it is safe. Execute this query, assuming your "comments" tables is called wp_comments:

    delete from wp_comments where comment_approved = 'spam';

  6. gavinholt
    Member
    Posted 7 years ago #

    have you tried using the Akismet plugin yet?

  7. sbysky
    Member
    Posted 7 years ago #

    Thanks. Done.

    I'm not using Akismet plugin but using "Anti Spam Image" plugin, which inserts a security image for the WP comment page, requiring the poster to enter the right characters in the image. (By Krazy Nio) .After using this "Anti Spam Image", now spam decreased largely.

  8. gavinholt
    Member
    Posted 7 years ago #

    Thanks for the tip, but that plugin page is down. I'm using another one with smart captcha, which is nice.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.