"Antonio Goncalves" <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users