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
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.
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
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.
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.
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
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
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
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
Thanks again Mike, YOU are very HELPFUL!
c
(@asoka1)
16 years, 1 month 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