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?
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.