Delete AMO account 10780644 due to repeated copyright infringement

RESOLVED FIXED

Status

RESOLVED FIXED
3 years ago
3 years ago

People

(Reporter: jorgev, Unassigned)

Tracking

Details

(URL)

(Reporter)

Description

3 years ago
We need to delete this account due to repeated copyright infringement violations: https://addons.mozilla.org/user/10780644/

I can't delete it through AMO because of the amount of themes and reviews linked to the account. I tried to at least anonymize it, but I don't know if it worked.
It appears they were anonymized.  Is that good enough for this bug to be closed?
(Reporter)

Comment 2

3 years ago
At least the themes and reviews for that account need to be deleted as well.
Brandon helped with this before in bug 878087 comment 1.  Can we re-run those commands with id 10780644?
Assignee: nobody → server-ops-database
Component: Administration → Database Operations
Product: addons.mozilla.org → Data & BI Services Team
QA Contact: scabral
Target Milestone: 2015-04 → ---
Version: unspecified → other
For the record, we would run:


delete cs.* from collection_subscriptions cs join collections c on cs.collection_id = c.id where c.author_id = 10780644;
delete cv.* from collections_votes cv join collections c on cv.collection_id = c.id where c.author_id = 10780644;
delete sacc.* from stats_addons_collections_counts sacc join collections c on sacc.collection_id = c.id where c.author_id = 10780644;
delete scc.* from stats_collections_counts scc join collections c on scc.collection_id = c.id where c.author_id = 10780644;
delete sc.* from stats_collections sc join collections c on sc.collection_id = c.id where c.author_id = 10780644;
delete from collections where author_id = 10780644;
delete un.* from users_notifications un join users u on un.user_id = u.id where u.id = 10780644;
delete au.* from abuse_reports au join users u on au.user_id = u.id where u.id = 10780644;
delete from users where id = 10780644;

I also needed to run:
delete from abuse_reports where reporter_id=10780644;
delete from addons_users where user_id=10780644;
delete from hubrsskeys where user_id=10780644;
delete from log_activity where user_id=10780644;
delete from log_activity_user where user_id=10780644;
delete from reviews where user_id=10780644;


What did not work:
'addons_mozilla_org.log_activity_user_mkt' doesn't exist:
delete laum.* from log_activity_user_mkt laum join users u on laum.user_id = u.id where u.id = 10780644;
delete laum.* from log_activity_user_mkt laum join log_activity_mkt lam on lam.id = laum.activity_log_id where lam.user_id = 10780644;

'addons_mozilla_org.log_activity_mkt' doesn't exist:
delete from log_activity_mkt where user_id = 10780644;
delete from auth_user where id = 10780644;


Does that look right to you?
The deletes were run....to verify I went to https://addons.mozilla.org/en-US/firefox/user/10780644/ and it now says "not found".
Yes, that looks right.  The _mkt tables were from before we split AMO and the Marketplace (it seems so long ago!).  Thanks
Status: NEW → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.