Akismet doesn't work. How do i delete all 5469 spam comments ?

Discussion in 'WordPress' started by ritwick123, Sep 7, 2014.

0
  1. #1
    Hello,
    I came back to my site blog for centpage after a few months to see that i have around 5500 spam comments although akismet is installed and activated via key as required. How do i delete all of those comments automatically that have author links ? Any good alternatives ? Please let me know. Thanks.

    [​IMG]
     
    ritwick123, Sep 7, 2014 IP
  2. ByteChef

    ByteChef Active Member Affiliate Manager

    Messages:
    64
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    75
    #2
    If you have PHPmyadmin or access to Hosting through Command Line then it is very easy.

    Or try this:

    https://wordpress.org/plugins/delete-pending-comments/
     
    ByteChef, Sep 7, 2014 IP
  3. ritwick123

    ritwick123 Well-Known Member

    Messages:
    218
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    130
    #3
    yes i have unlimited hosting account. and have access to phpmyadmin. what do i need to do ?
     
    ritwick123, Sep 7, 2014 IP
  4. ByteChef

    ByteChef Active Member Affiliate Manager

    Messages:
    64
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    75
    #4
    Well I think you can install the plugin in the following link and delete all:

    https://wordpress.org/plugins/delete-pending-comments/
     
    ByteChef, Sep 7, 2014 IP
  5. Mr.Ultra

    Mr.Ultra Member

    Messages:
    50
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    43
    Digital Goods:
    10
    #5
    If you have access to phpadmin, than run this SQL query:
    DELETE from wp_comments WHERE comment_approved = '0';
    Code (markup):
     
    Mr.Ultra, Sep 19, 2014 IP