please remove ~ubuntu-games-merged from ~locoteams

Asked by Daniel Holbach on 2009-08-13

please remove ~ubuntu-games-merged from ~locoteams - I can't remove it manually.

Question information

Language:
English Edit question
Status:
Answered
For:
Launchpad itself Edit question
Assignee:
[LEGACY] Canonical WebOps Edit question
Last query:
2009-08-13
Last reply:
2009-09-16
Whiteboard:
2009-08-13: Julian: ~ubuntu-games-merged appears on the second batch in ~locoteams but visiting https://launchpad.net/~ubuntu-games-merged gives a 404. Assigning to LOSAs.
Steve McInerney (spm) said : #1

Hey Daniel,

No joy here either - need some SQL-fu from the Devs.

Cheers!
- Steve

Steve McInerney (spm) said : #2

still open - pending SQL fux and/or bug fixed.

Guilherme Salgado (salgado) said : #3

I can't reproduce this, but here's the SQL to remove the merged team from all the teams it is a member of (locoteams and ubuntugames).

delete from teammembership where person = (select id from person where name = 'ubuntu-games-merged');
delete from teamparticipation where person = (select id from person where name = 'ubuntu-games-merged') and person != team;

Steve McInerney (spm) said : #4

Hey Daniel,

all removed.

Cheers!
- Steve

Can you help with this problem?

Provide an answer of your own, or ask Daniel Holbach for more information if necessary.

To post a message you must log in.