This is a weird one. I just added a news item to the site (ironically, about spam) and the item instantly had spam comments. From 2012.
Obviously, there in the system somehow, but I'm wondering how to get rid of them.
Oh, and when I delete them, I then get a negative number of comments. Weird.
http://www.fictioning.net/index.php
Well, using a different search term ("spam reviews" broke the search on this site), I found the same issue in...2012. So, I'm assuming it was a "thing" then and somehow it got into my site at the time.
I've just gone into phpMyAdmin and deleted a whole bunch of comments that were obviously spam. So hopefully, this will help for the moment.
Hi Sue,
If you've deleted the comments from PHPMyAdmin _comments table instead of using the delete button via the actual news article, you will need to re-calculate your site statistics to fix the count number.
Go to Admin > Archive Maintenance > Recalculate Site Statistics
As for the 2012 thing.. did you have old/previous news articles that might have been deleted? Maybe when you're adding a new article it's automatically assigning the comments to it because of the nid value?
EDIT: OK, so I've just scrolled through my own database to look for the issue, and I've got a butt-load of comments assigned to nid's that don't even exist yet - all around 2012/2013...
eFiction Archives:
No, it's really, really weird. I deleted the comments via the front end at the time and yesterday. Both have negative values. I tried the recalculate stats thing but it didn't work. I've tried it before...they've been negative values 2014 :confused: The comments I deleted were old ones in phpMyAdmin, from 2012. I suspect there was some kind of nastiness done in 2012 and that the comments were being "recycled".
That's a good thought about the nid value of the news articles though. That might be the reason. Thanks!
At some point, it was possible to inject comments with IDs of news and stories that didn't exist, to achieve exactly what you just saw, the date was done by the site, so yes, must have been 2012. Wife had the same issue earlier, but at some point it ended, either via patch or because ... reason.
Thanks Sheepie. That sounds right. I would've updated eFiction since then, so hopefully, whatever it was has gone.
Good to know, Sheepcontrol!
If Recalculating Site Statistics doesn't work for you Sue, you could always manually correct the number in the comments column of _news in your MySQL.
eFiction Archives:
If Recalculating Site Statistics doesn't work for you Sue, you could always manually correct the number in the comments column of _news in your MySQL.
Thanks for that - good to know!
