bulk deleting spam comments

GFH

Joined: 2013-11-30
Posts: 2
Posted: Sat, 2013-11-30 13:56

Need help! Is there a way of bulk deleting several hundreds spam comments?
Thanks in advance
ghf

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sat, 2013-11-30 17:41

I guess you could do it directly through the DB.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
mejiaufv

Joined: 2013-11-30
Posts: 1
Posted: Sun, 2013-12-08 18:21

I'm having problems with spam as well. No matter how many times I go and delete the comments, more just keep popping up. Does anybody know of a way to prevent spam comments from showing up in the first place?

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2013-12-01 05:16

Don't allow the everybody/guest user add comments. Force them to register and/or use the http://codex.galleryproject.org/Gallery3:Modules:akismet module.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
GFH

Joined: 2013-11-30
Posts: 2
Posted: Sun, 2013-12-01 10:55

Thank you, Dave! Done. Finally. Still quite fastidious when you have to delete some hundreds of those damned spam comments. Pity that there is no integrated "bulk delete" in Gallery3.
Thanks again for your quick help.
Gerd

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2013-12-01 16:27

How would the bulk delete work? You would still have to some how sort or filter out the good from the bad.

I guess one could develop a module that would get all the comments in a table then use some JS to sort and filter it like: http://tablefilter.free.fr/ex.php
then have some checkboxes to select them to be deleted.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
drAstronomus

Joined: 2011-04-02
Posts: 9
Posted: Sat, 2013-12-21 16:27

Akismet plugin is the best tool for spam filtration.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sat, 2014-05-17 22:32
Quote:
I guess one could develop a module that would get all the comments in a table then use some JS to sort and filter it like: http://tablefilter.free.fr/ex.php
then have some checkboxes to select them to be deleted.

Ok, that is done:
http://codex.galleryproject.org/Gallery3:Modules:comment_spam_finder

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team