[Systems] Trac spam cleanup

[Tomeu Vizoso]

On Fri, Jan 15, 2010 at 14:51, Sascha Silbe
<sascha-ml-ui-sugar-systems at silbe.org> wrote:
> On Fri, Jan 08, 2010 at 06:59:22PM -0500, Bernie Innocenti wrote:
>
>> <silbe> bernie_: can you issue "delete from ticket_change where author
>> in ('nikecitycn', 'sunrise');" on the trac db (using sqlite3), please?
>> from looking at the database schema it should cause no side effects but
>> i don't know Trac well so would recommend to do a backup of the
>> database (file) first.
>>
>> Done. Thanks for reporting this.
>
> Thanks! Here's another one:
>
> delete name from wiki where name glob '[0-9][0-9][0-9]_buy_*';
>
> All other SPAM pages have already been deleted using the web interface. If
> you notice any remaining SPAM (e.g. ticket comments) please prod me.

Thanks for taking care of this!

Regards,

Tomeu

> CU Sascha
>
> --
> http://sascha.silbe.org/
> http://www.infra-silbe.de/
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iQEcBAEBAgAGBQJLUHLWAAoJELpz82VMF3DaZKkH/ithhLdTt6ZX15M3KCWRHps4
> EJAAWL5ijnUxj1LpMthP60q/ooCOixwA0hhwMSxOJELh60yuznCsAaT+HEZqjQAp
> oXDDlj8Zc4Y4wv3kg/gf2LkDoRj7idYFEHbXeGIf9/llfftWusgCwTV/PajBdfyI
> FaLyE3H0Yj9dHTiIbcelZli1xDQEAlS9k2QtTPeGYZyJw3TfGO8YOlwr1WuHRvWJ
> bs/zuaActTxMP790HvNKwqo8/LEo3GD9/LlAIXiBUHCQmt+cHkc4Jb2hKEV5Lxen
> YJLhVcELRcSFd6qhzhhVkQDLu1wdoaupaq3NHEEcbtttWO0oMPS/0zZv8ncyfzA=
> =ABgH
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Systems mailing list
> Systems at lists.sugarlabs.org
> http://lists.sugarlabs.org/listinfo/systems
>
>



-- 
«Sugar Labs is anyone who participates in improving and using Sugar.
What Sugar Labs does is determined by the participants.» - David
Farning