Results 1 to 1 of 1

Thread: Delete ALL Comments from Drupal

  1. #1
    Will.Spencer's Avatar
    Will.Spencer is offline Retired
    Join Date
    Dec 2008
    Posts
    5,033
    Blog Entries
    1
    Thanks
    1,010
    Thanked 2,329 Times in 1,259 Posts

    Delete ALL Comments from Drupal

    One of our Drupal sites was misconfigured and as a result it received thousands of spammy comments linking to very undesirable neighborhoods.

    Using the Drupal GUI to delete these was taking forever.

    Going straight to MySQL was a lot quicker.
    SQL Command to Delete all Unpublished Comments In Drupal:
    Code:
    delete from comments where status = '1';
    SQL Command to Delete all Published Comments In Drupal:
    Code:
    delete from comments where status = '0';
    As per usual, back up your database before monkeying with SQL directly.
    Submit Your Webmaster Related Sites to the NB Directory
    I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.

  2. Thanked by:

    sturat (16 April, 2009), vanderkitty jones (3 May, 2009)

Similar Threads

  1. why always delete my site on proxyliste.com
    By catding in forum Proxy List Support Forum
    Replies: 13
    Last Post: 3 March, 2011, 02:32 AM
  2. how to delete wp post in mysql ?
    By SonnyCooL in forum Databases
    Replies: 2
    Last Post: 29 June, 2010, 20:34 PM
  3. plugin delete old thread ?
    By SonnyCooL in forum Blogging
    Replies: 5
    Last Post: 24 April, 2010, 16:13 PM
  4. Delete ALL Comments from Wordpress
    By Will.Spencer in forum Wordpress
    Replies: 4
    Last Post: 17 April, 2009, 22:28 PM
  5. Replies: 8
    Last Post: 11 April, 2009, 20:43 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •