Closed Bug 734457 Opened 13 years ago Closed 13 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: 13 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.