Closed
Bug 734457
Opened 12 years ago
Closed 12 years ago
[Firefox Flicks] Remove Videos
Categories
(Infrastructure & Operations Graveyard :: WebOps: Other, task)
Infrastructure & Operations Graveyard
WebOps: Other
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)
Comment 1•12 years ago
|
||
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•12 years ago
|
||
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•12 years ago
|
||
(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•12 years ago
|
||
This did the job.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Updated•11 years ago
|
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Updated•5 years ago
|
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•