BTW, why can't I just delete the comments instead of changing the object type ? I don't mind loosing these comments, can I damage any database key constraint ?
2007/9/3, Raffaello Pelagalli <[EMAIL PROTECTED]>: > > "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 > firstname.lastname@example.org > http://lists.xwiki.org/mailman/listinfo/users >
_______________________________________________ users mailing list email@example.com http://lists.xwiki.org/mailman/listinfo/users