[xwiki-users] Comments spam

[Antonio Goncalves]

Raffaello I've done the updates but comments still show up. Do I have to
clear a cache or something like that ?


2007/9/3, Raffaello Pelagalli <raffaello at xwiki.com>:
>
> "Antonio Goncalves" <antonio.mailing at gmail.com> writes:
>
> > Hi,
> >
> > My XWiki website has been spammed with more than 200 (porn) comments on
> the
> > main page. I didn't want to put any access restriction on comments
> thinking
> > that the world was a better place and that anybody could comment
> :o)  Well, I
> > was wrong and I'm gonna change the user rights.
> >
> > How can I safely delete all these comments (by hand it will take me
> ages) ?
> >
> > Thanks,
>
> Hi,
>
> An easy way to do that, without loosing anything is to change the object
> type of
> each spam comments.
>
> For exemple, you can execute something like that on your database server :
>
> update xwikiobjects, xwikilargestrings set
>       XWO_CLASSNAME='XWiki.XWikiComments_spam' where
>       XWO_CLASSNAME='XWiki.XWikiComments' and XWL_ID=XWO_ID and
>       XWL_VALUE like '%viagra%';
>
> Best regards,
> --
> Raffaello Pelagalli
> XPertNet - XWiki.com
> _______________________________________________
> users mailing list
> users at xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.xwiki.org/pipermail/users/attachments/20070903/ebb885cb/attachment.htm 
-------------- next part --------------
_______________________________________________
users mailing list
users at xwiki.org
http://lists.xwiki.org/mailman/listinfo/users