734457 - [Firefox Flicks] Remove Videos

Status: RESOLVED FIXED

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

Description

[Christie Koehler [:ckoehler]]

The following two videos need to be removed due to infringing content:
https://firefoxflicks.mozilla.org/en-US/video/38
https://firefoxflicks.mozilla.org/en-US/video/37

Filing as an IT bug because this is a production server and we're still working on the admin interface. mkelly, can you advise IT on the best way to delete the video?

(Offending user should not get a swag pack: https://firefoxflicks.mozilla.org/en-US/users/details/139)

Comment 1

[Osmose [:osmose, :mkelly]]

Best way to delete the video would just be a delete statement:

DELETE FROM videos_video WHERE user_id=37;
DELETE FROM videos_video WHERE user_id=38;

Comment 2

[Jake Maul [:jakem]]

Presumably you meant id instead of user_id... that seems to be the ones that Christie linked to.

Do we not need to do anything about deleting actual content? Just DB metadata?

Comment 3

[Osmose [:osmose, :mkelly]]

(In reply to Jake Maul [:jakem] from comment #2)
> Presumably you meant id instead of user_id... that seems to be the ones that
> Christie linked to.
> 
> Do we not need to do anything about deleting actual content? Just DB
> metadata?

D'oh, good call.

We don't have to handle deleting the content right now, but we might want to keep around the video shortlinks, so something like this will work better:

UPDATE videos_video SET state='error' WHERE id IN (37, 38);

This will remove the video from the site but keep it in the database.

Comment 4

[Jake Maul [:jakem]]

This did the job.