WordPress.org

Forums

How To Find & Delete Comments File (12 posts)

  1. asoka1
    Member
    Posted 7 years ago #

    Hello,

    I have an old and archaic version of WordPress that I have not blogged to for over a year, and wish to revive. (It's 1.5, although I don't think that is relevant to the question at hand).

    Anyway, thanks to spam, I find that there are no less than 113,593 comments awaiting moderation. They almost all spam comments. Hence, rather than even try and click the link and open them for moderation, which in itself would take forever, I woudl prefer to find the WordPress Comments file under FTP and simply delete it, or else copy an empty one over. Please can you tell me where it is located? I have looked everywhere and cannot find it.

    Of course, I DO want to upgrade to the latest WordPress, but I figure that I might as well overcome this problem first.

    Thank you.

    AKS

  2. chuckevans
    Member
    Posted 7 years ago #

    This is something I would really like to know as well. I'm sure there are MANY others that need the answer too.

    thanks,

    chuck

  3. whooami
    Member
    Posted 7 years ago #

    hahahaha. Im sorry, but I have to laugh at anyone that suggests that "due to spam" they have 113,593 comments awaiting moderation. In truth, you are the reason you have all those comments in moderations. But, of course, you dont want to hear that.

    As to the answer, just like posts, and pages, comments arent stored in a file. They are stored inside your MySQL databse just like all that other content-ish stuff.

  4. chuckevans
    Member
    Posted 7 years ago #

    I'm glad the post made you laugh and thanks for the "No-Help!"

    Now if anyone is serious about helping that would be great. I don't know about the original poster of this thread but I WANT people to visit and comment. The only issue I have is how to delete the unwanted comments.

    I have about 400 or so sitting in moderation and would like to be able to mass edit them. But when I try that nothing happens, all of the posts still show up in the admin panel AND the site crashes!

    So any REAL help would be appreciated. The blog is at http://www.howtobuildyourgolfswing.com

    thanks,

    chuck

  5. whooami
    Member
    Posted 7 years ago #

    no help.

    The question in the original post asked specifically about a file.

    There isnt one. I said that

    That was help.

    Your first post added no questions. Nor did you indicate anything beyond, as you said, wanting to know "the same thing".

    Since youve now actually asked something ..

    As I stated, comments are stored in your database.

    If you are unable for some reason (that you havent explained, or elaborated on) to delete them via the wp-admin panel that manages comments than you will need to delete them by accessing them directly inside your database.

    This thread covers that:

    http://wordpress.org/support/topic/111419?replies=6

    Oh, and youre welcome.

  6. chuckevans
    Member
    Posted 7 years ago #

    If you are unable for some reason (that you haven't explained, or elaborated on) to delete them via the wp-admin panel that manages comments.

    Yes, I did mention this,

    I have about 400 or so sitting in moderation and would like to be able to mass edit them. But when I try that nothing happens, all of the posts still show up in the admin panel AND the site crashes!

    And thanks for the HELP!

    chuck

  7. whooami
    Member
    Posted 7 years ago #

    thats a symptom, not an elaboration of a problem.

    Elaborating would be saying what browsers you have tried, what versions, what you mean by posts, since comments are comments, AND NOT posts, and what exactly "crashes" means.

    mnetioning != not good enough.

  8. chuckevans
    Member
    Posted 7 years ago #

    Hummm...let'see. At precisely 10:52 am CST on Monday March 17th I logged into the admin section. Under the Comments section I clicked and saw that there are 412 comments awaiting moderation.

    I click on the "awaiting moderation" and nothing happens. The comments tab shows but does not switch over to the awaiting moderation tab.

    Under the comments tab there is an option for View Mode or Mass Edit Mode. These will not switch back and forth either, just like the comment tabs would not.

    When I click on a comment to delete it there is no "deletion" it still shows up in the admin panel under comments. In fact when clicked all my machine says is "done."

    SO... when I click on "next page" it doesn't show up either but rather stays on the first page.

    And finally, from the admin comments section, I can NOT leave that section once there. This is the crash I spoke of. It's like being frozen in time. The only way I can escape from the comment section is to close the browser.

    So there appear to be several issues.

    Cannot delete comments;
    Cannot mass edit comments;
    Cannot leave the comments section without closing the browser.

    I have tried in Firefox - v2.0.0.12
    and in IE7 - v7.05730.13

    I am using WordPress v2.2

    Hopefully I have elaborated all of the symptoms and steps for these problems.

    Thanks in advance,

    c

  9. mikeatvillage
    Member
    Posted 7 years ago #

    You'll have to find the database table which stores the comments ("wp-comments") then select and delete each/all, whatever you require. The field "comment_approved" will contain a 0 if the comment is awaiting moderation so you could run an SQL statement to delete all awaiting comments.

    DELETE FROM wp_comments WHERE comment_approved='0'

    I access my database using the control panel supplied by my host. Hopefully you have something similar.

    HTH... someone please correct me if I'm wrong !!!

    Mike

  10. chuckevans
    Member
    Posted 7 years ago #

    Thanks, that's exactly what I did! Went to the database table and hand deleted the comments. I wish there was a way to mass delete by comment "poster" but couldn't find one.

    Thanks again THAT was very helpful!

    c

  11. mikeatvillage
    Member
    Posted 7 years ago #

    MySQL for that should be..

    DELETE FROM wp_comments WHERE comment_author='<their name>'

    (but several posters may have the same name !)

    or, if you want to delete all based on their email address

    DELETE FROM wp_comments WHERE comment_author_email='<their email address>'

    ATB

    Mike

  12. chuckevans
    Member
    Posted 7 years ago #

    Thanks again Mike, YOU are very HELPFUL!

    c

Topic Closed

This topic has been closed to new replies.

About this Topic