Closed
Bug 734457
Opened 13 years ago
Closed 13 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•13 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•13 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•13 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•13 years ago
|
||
This did the job.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Updated•12 years ago
|
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Updated•6 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
•