Closed Bug 734457 Opened 12 years ago Closed 12 years ago

[Firefox Flicks] Remove Videos

Categories

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

task
Not set
critical

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: ckoehler, Unassigned)

Details

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)
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;
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?
(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.
This did the job.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.