can I delete spam comments

  • sbysky

    (@sbysky)


    17 years, 5 months 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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Samuel B

    (@samboll)

    17 years, 5 months ago

    Why not delete them from your WordPress admin panel?

    Thread Starter sbysky

    (@sbysky)

    17 years, 5 months 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

    Thread Starter sbysky

    (@sbysky)

    17 years, 5 months ago

    Does anybody can answer this question? Thank you very much

    Pizdin Dim

    (@pizdin_dim)

    17 years, 5 months ago

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

    delete from wp_comments where comment_approved = 'spam';

    gavinholt

    (@gavinholt)

    17 years, 5 months ago

    have you tried using the Akismet plugin yet?

    Thread Starter sbysky

    (@sbysky)

    17 years, 5 months 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.

    gavinholt

    (@gavinholt)

    17 years, 5 months ago

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘can I delete spam comments’ is closed to new replies.