By Vcize on

I had a spammer hit my drupal site and post a ton of spam comments on a bunch of my articles. They used the same username for all of them, so rather than delete each one of them one by one through drupal I just went into the database and ran a query to delete all comments by that username.

That worked, however, on the front page of my site where under the article it shows, for instance "7 comments", those comments are still being counted.

So basically, before I had an article with 1 real comment and 6 spam comments. I deleted the 6 spam comments straight from the database so now only 1 comment shows up under the article. However, on the main page that only has the excerpt for the article, it is still counting those comments I deleted out of the DB and showing "7 comments".

⋅ Categories: Drupal 6.x

Comments

ghmercado’s picture

ghmercado commented

youve probably tried it but just in case.. have you tried cron? maybe it will force the db to do a recount.

Vcize’s picture

Vcize commented

Yep, I gave Cron a try and no change.

Vcize’s picture

Vcize commented

I'm still struggling with this, anyone have any ideas?

Vcize’s picture

Vcize commented

Still can't get this fixed :(

Any other ideas out there?

eigentor’s picture

eigentor commented

I had the same problem today - lots of spam, little patience.
So into the database, deleted comments from database.
Comment cound does not update, this must be stored somewhere else.

Solution: If you have some comments to delete (if not, create some) delete them the regular way.
I did it using Views bulk operations. Might also work through the comment overview unter content.

For me the comment cound updated to the correct number after this.