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

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

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

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

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

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
	XUser login Username: * Password: * Create new account Request new password
floridave 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 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 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 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

bulk deleting spam comments

XUser login