Posted 2 years ago #
Hi,
I use Akismet to protect my WordPress-blog from spam-comments.
There are 2,053 comments in my spam queue.
I want to delete these comments, but when I go to the page Comments > Spam, I get the message 'No results found'. The navigation buttons do show up (it says 'Displaying 1–20 of 2,051').
A printscreen:
http://i27.tinypic.com/2i6jcoz.jpg
I have the newest version of Akismet (2.2.6).
Can anyone tell me how to delete these comments?
Thanks you very much.
MCBO
Not sure why you are getting that error, but maybe the following video will help you get rid of the comments.
Posted 2 years ago #
Figaro,
Thank you a lot. The tutorial shows how to delete unapproved comments with use of the query 'DELETE FROM wp_comments WHERE comment_approved = 0'.
I want to delete spam-comments. Should I use the query 'DELETE FROM wp_comments WHERE comment_approved = spam' instead, since spam-comments are marked als 'spam' in the 'comment_approved'-table?
Thank you.
Yes, just put the word spam in single quotes = 'spam'
Posted 2 years ago #
Hi Figaro,
Thank you for your reply. Are you sure that spam should be in single quotes?
In the tutorial 0 isn't put in single quotes: http://i28.tinypic.com/anijif.png.
I'm not an expert in this.
Thank you.
I'm no expert either, but since it's a string I believe it needs to be in single quotes. I tried it on my site and deleted the spam comments using that method.
Posted 2 years ago #
Hello,
Thank you. I'm gonna try it in the morning. I will first back-up my database, it's almost 170 mb. I will let you know if it worked out!
It will probably be significantly smaller once you remove all the SPAM.
Posted 2 years ago #
Hi Figaro,
I just tried to delete the spam-comments, but I think I'm in trouble.
When I run the SQL-query DELETE FROM wp_comments WHERE comment_approved = 'spam', I get the following:
Deleted rows: 0 (Query took 0.0003 sec)
When I run the SQL-query DELETE FROM wp_comments WHERE comment_approved = spam, I get the following:
Error
SQL query:
DELETE FROM wp_comments WHERE comment_approved = spam
MySQL said: Documentation
#1054 - Unknown column 'spam' in 'where clause'
However, there are still 1,931 spam-messages.
What should I do now? I'm really worried.
Thank you.
If you want to send me a login to your phpMyAdmin I'll take a look at it for you. educhalk[at]gmail[dot]com
Posted 2 years ago #
Hi Figaro,
Thank you for your reply. It's early morning here, so I just contacted my hosting provider.
The problem was that my table crashed. He repaired the table and ran the query. It worked out. I can see my Spam-comments again in WordPress.
Thank you for your help.
Posted 2 years ago #
Hi,
It seems this spam issue is a big one! My name is Robin and I'm not a techie. I am running a blog at http://www.12steps4romance.com/blog. I have tried to deny and delete 5 spam comments and cannot by mass or individual. I'm being told I am not allowed. PLEASE HELP! I almost feel like it's useless using WP if this is going to be an ongoing issue unless most blog programs go through the same.
(Sorry to cut into your communication here.)
Thanks!
Robin
Posted 2 years ago #
Spam is an issue for any website, regardless of what code base is used, be that custom written code or a site developed using blogging software or a CMS (or any other number of ways). I could be really picky and start quoting SPAM statistics here, but i'm not a statistic man, so i won't... (plus it does nothing to help what we're discussing)
If you have a specific issue, start a new thread detailing the problem and invite people to help you.
One problem, on one setup is not indicative of the functionality and reliability of an application as a whole.
This topic has been closed to new replies.
