Question for a WordPress Pro

Discussion in 'WordPress' started by jg123, Apr 26, 2007.

  1. #1
    Is there a way to delete pending comments from cpanel (directly from the files)? I have a couple of thousand and the page hangs everytime I try and load them.

    thanks
     
    jg123, Apr 26, 2007 IP
  2. mooiness

    mooiness Peon

    Messages:
    409
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can try deleting them directly from the database via something like phpmyadmin - usually available from your webhost's control panel.

    Also, I'm suspecting that the reason you have so many comments is that a majority of them are spam. Have you installed any of the following plugins to help combat spam?
    Akistmet
    Spam-Karma 2
    Bad Behaviour 2
     
    mooiness, Apr 26, 2007 IP
  3. jg123

    jg123 Notable Member

    Messages:
    6,006
    Likes Received:
    387
    Best Answers:
    0
    Trophy Points:
    295
    #3
    "database via something like phpmyadmin" - I was thinking of that but not sure how to find them.
     
    jg123, Apr 26, 2007 IP
  4. mooiness

    mooiness Peon

    Messages:
    409
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #4
    In this case, your Webhost support would be your best contact for this.
     
    mooiness, Apr 26, 2007 IP
  5. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #5
    If you've got access to phpmyadmin run the following SQL statement on your Wordpress database.

    DELETE FROM wp_comments WHERE comment_approved = '0'
     
    Richie_Ni, Apr 26, 2007 IP
  6. jg123

    jg123 Notable Member

    Messages:
    6,006
    Likes Received:
    387
    Best Answers:
    0
    Trophy Points:
    295
    #6
    It seems I don't have phpmyadmin :-(
     
    jg123, Apr 27, 2007 IP
  7. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #7
    You have cpanel,right?
    How came you have cpanel but no phpmyadmin?!
     
    Richie_Ni, Apr 27, 2007 IP
  8. jg123

    jg123 Notable Member

    Messages:
    6,006
    Likes Received:
    387
    Best Answers:
    0
    Trophy Points:
    295
    #8
    I am not really sure, I thought I had it but can't find it. Would it be on the home page of cpanel or somewhere inside?

    Anyways I found a work-around that works!! I went into manage --> comments and clicked bulk then I used the search feature. I started with some of the most popular ip number pairs 71, 72 etc... It brought up 200-600 at a time and you can check them all then delete. Then I did seperate numbers and I was able to work through 5,600 comments in about 5 minutes that way.

    Hope this helps someone else that had the same problem.
     
    jg123, Apr 30, 2007 IP
  9. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #9
    Click MySQL® Databases--->on the bottom you'll see "phpmyadmin". :)
     
    Richie_Ni, Apr 30, 2007 IP
    jg123 likes this.
  10. guyfox

    guyfox Peon

    Messages:
    280
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Nice handy tip - thanks.
     
    guyfox, Apr 30, 2007 IP
  11. jg123

    jg123 Notable Member

    Messages:
    6,006
    Likes Received:
    387
    Best Answers:
    0
    Trophy Points:
    295
    #11
    Dam, I knew it was in there somewhere....I am glad I finally figured out 'my way', it worked pretty good.
     
    jg123, Apr 30, 2007 IP