1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Wordpress Pending Comments - Mass Delete?

Discussion in 'WordPress' started by dcristo, May 27, 2007.

Thread Status:
Not open for further replies.
0
  1. #1
    I have a blog which I have neglected and am wanting to mass delete all the pending comments. It's got to the point whereby when I open the moderation page in the admin panel, it always crashes because there's too many comments.

    Is there a SQL query I can insert in PHPMyAdmin to mass delete all the pending comments in Wordpress?
     
    dcristo, May 27, 2007 IP
  2. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Go to PHPmyadmin. Find the db for your blog. Find the "comments" table, tick it and click "empty".

    Job done.

    Col :)
     
    Cheap SEO Services, May 27, 2007 IP
  3. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,199
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #3
    Thanks Col. Will this delete all comments, or only pending comments?
     
    dcristo, May 27, 2007 IP
  4. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I think it will do both but not 100% sure.

    Give it a go anyway.

    Col :)
     
    Cheap SEO Services, May 27, 2007 IP
  5. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #5
    I guess it'll delete all the comments.
     
    Richie_Ni, May 27, 2007 IP
  6. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,199
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #6
    Use me as the guinea pig you cheeky bugger! :D Thanks for the help.
     
    dcristo, May 27, 2007 IP
  7. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #7
    no problems. :D Let me know how it goes.

    Col :)
     
    Cheap SEO Services, May 27, 2007 IP
  8. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #8
    Run the following SQL statement on your Wordpress database.

    DELETE FROM wp_comments WHERE comment_approved = '0'
     
    Richie_Ni, May 27, 2007 IP
    Cheap SEO Services and dcristo like this.
  9. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #9


    ahhh...finally someone who knows what to do...the ever reliable Richie. Onya mate!!

    Col :)
     
    Cheap SEO Services, May 27, 2007 IP
  10. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,199
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #10
    Richie you are a pool of knowledge, that's what I was looking for.

    I will test it out and report back, making sure to backup the db just in case.
     
    dcristo, May 27, 2007 IP
  11. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,199
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #11
    I hope you didn't find bugger offensive, LOL ;)
     
    dcristo, May 27, 2007 IP
  12. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #12

    Hey Richie? Is there an SQL command to this for a network of blogs on the same host?

    Col :)
     
    Cheap SEO Services, May 27, 2007 IP
  13. MeetHere

    MeetHere Prominent Member

    Messages:
    15,399
    Likes Received:
    994
    Best Answers:
    0
    Trophy Points:
    330
    #13
    Why you need that ? Do you still own your 200 blog network? :D
     
    MeetHere, May 27, 2007 IP
  14. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,199
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #14
    Worked great. Thanks Richie :)
     
    dcristo, May 27, 2007 IP
    Richie_Ni likes this.
  15. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #15
    Hey Col.I'm afraid You"ll have to run the query in all the db's .:)

    Your welcome buddy! :)
     
    Richie_Ni, May 27, 2007 IP
  16. Cheap SEO Services

    Cheap SEO Services <------DoFollow Backlinks

    Messages:
    16,664
    Likes Received:
    1,318
    Best Answers:
    0
    Trophy Points:
    0
    #16
    no probs....you know much about phpld??? I am having a problem with mine...

    going to bed now....it's late...

    let me know via MSN if you can help.

    Thanks,

    Col :)
     
    Cheap SEO Services, May 27, 2007 IP
  17. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #17
    Only know a little....;)
    PM me about the problem and I'll let you know if I could give you a hand. :)
     
    Richie_Ni, May 27, 2007 IP
Thread Status:
Not open for further replies.