10 Sep
2008
10 Sep
'08
9:01 p.m.
Hi all,
A couple pages on my wiki have been spammed and I was wondering if
there is a way to delete all comments by XWikiGuest easily. I have
noticed a table in the db called xwikircs that gets updated evertime
there is a change to the wiki. Also noticed that when someone makes a
comment some info about the comment, including the comments goes there
too. But for some reason the xwikicomments table is empty? So i guess
there are really two questions, why is the xwikicomments table empty
and is there an easy way to delete spam comments (comments by
XWikiGuest). Thanks in advanced!
-m
13 Sep
13 Sep
3:32 p.m.
marlon hendred wrote:
A couple pages on my wiki have been spammed and I was
wondering if
there is a way to delete all comments by XWikiGuest easily. I have
noticed a table in the db called xwikircs that gets updated evertime
there is a change to the wiki. Also noticed that when someone makes a
comment some info about the comment, including the comments goes there
too.
xwikircs store full difference of document change in xml format,
including objects (comments are objects).
Once per "xwiki.store.rcs.nodesPerFull" (xwiki.cfg parameter, 5 by
default) versions xwikircs stores full xml of document for performance
reasons.
But for some reason the xwikicomments table is empty?
So i guess
there are really two questions, why is the xwikicomments table empty
Because XWiki.XWikiComments class is not using xwiki custom mappings
feature now. (It used some time later)
and is there an easy way to delete spam comments
(comments by
XWikiGuest). Thanks in advanced!
You can just revert document to a version before spam.
--
Artem Melentyev
3:47 p.m.
On Sep 13, 2008, at 3:32 PM, Artem Melentyev wrote:
marlon hendred wrote:
In the past we had a script to do that.
Basically what you can do is create a velocity script that looks for
XWiki.XWikiComments objects and remove all of the matching a given
value.
Then you run it several times passing the keyword (like viagra, some
url ,etc).
Would be good to put this script on code.xwiki.org in the snippets area.
Thanks
-Vincent
A couple pages on my wiki have been spammed and I
was wondering if
there is a way to delete all comments by XWikiGuest easily. I have
noticed a table in the db called xwikircs that gets updated evertime
there is a change to the wiki. Also noticed that when someone makes a
comment some info about the comment, including the comments goes
there
too.
xwikircs store full difference of document change in xml format,
including objects (comments are objects).
Once per "xwiki.store.rcs.nodesPerFull" (xwiki.cfg parameter, 5 by
default) versions xwikircs stores full xml of document for performance
reasons.
But for some reason the xwikicomments table is
empty? So i guess
there are really two questions, why is the xwikicomments table empty
Because XWiki.XWikiComments class is not using xwiki custom mappings
feature now. (It used some time later)
and is there an easy way to delete spam comments
(comments by
XWikiGuest). Thanks in advanced!
You can just revert document to a version before spam.
17 Sep
17 Sep
8:44 p.m.
Thanks for the info guys!
-mh
On Sat, Sep 13, 2008 at 6:47 AM, Vincent Massol <vincent(a)massol.net> wrote:
On Sep 13, 2008, at 3:32 PM, Artem Melentyev wrote:
marlon hendred wrote:
In the past we had a script to do that.
Basically what you can do is create a velocity script that looks for
XWiki.XWikiComments objects and remove all of the matching a given
value.
Then you run it several times passing the keyword (like viagra, some
url ,etc).
Would be good to put this script on code.xwiki.org in the snippets area.
Thanks
-Vincent
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
A couple pages on my wiki have been spammed and I
was wondering if
there is a way to delete all comments by XWikiGuest easily. I have
noticed a table in the db called xwikircs that gets updated evertime
there is a change to the wiki. Also noticed that when someone makes a
comment some info about the comment, including the comments goes
there
too.
xwikircs store full difference of document change in xml format,
including objects (comments are objects).
Once per "xwiki.store.rcs.nodesPerFull" (xwiki.cfg parameter, 5 by
default) versions xwikircs stores full xml of document for performance
reasons.
But for some reason the xwikicomments table is
empty? So i guess
there are really two questions, why is the xwikicomments table empty
Because XWiki.XWikiComments class is not using xwiki custom mappings
feature now. (It used some time later)
and is there an easy way to delete spam comments
(comments by
XWikiGuest). Thanks in advanced!
You can just revert document to a version before spam.
5846
days inactive
5853
days old
3 comments
4 participants
participants (4)
-
Artem Melentyev -
marlon hendred -
mh
-
Vincent Massol