Can’t remove spam-comments

Not sure why you are getting that error, but maybe the following video will help you get rid of the comments.

https://educhalk.org/blog/?p=133

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’

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: https://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.

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.

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

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.

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 https://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

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.