523898 - Run query on AMO production database

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Michael Morgan [:morgamic]]

Need to delete the .NET stuff from the blocklist.  Queries are:
delete from blitems where guid='{20a82645-c095-46ed-80e3-08825760534b}';
delete from blplugins where name='Windows Presentation Foundation';

Comment 1

[Mike Shaver (:shaver -- probably not reading bugmail closely)]

(In reply to comment #0)
> delete from blitems where guid='{20a82645-c095-46ed-80e3-08825760534b}';

This query will likely affect 0 rows, since we already removed it.

> delete from blplugins where name='Windows Presentation Foundation';

This query will make me so happy I can hardy stand it.

Comment 2

[Michael Morgan [:morgamic]]

less than three

Comment 3

[Michael Morgan [:morgamic]]

And yeah, those were the results on the stage db, so that's expected.

Comment 4

[Michael Morgan [:morgamic]]

Just this is fine, in that case:
delete from blplugins where name='Windows Presentation Foundation';

Comment 5

[Shyam Mani [:fox2mike]]

Done.

mysql> delete from blplugins where name='Windows Presentation Foundation';
Query OK, 1 row affected (0.01 sec)

Party on lads!