XF 2.2 Just got a DMCA notice, how do I remove a single proxied image?

[Mave]

I need to delete this proxied image. Already deleted the post + imgur link, but the proxied version is still online.

So how would I go about deleting this image? As far as I can tell there is no option at the moment. Time is of course of essence here.

I've tried searching the hash in image_cache, but unfortunately it doesn't work like that.

 

[Mave]

For now I solved the problem by changing our proxy secret key. Far from ideal, still hoping someone will reply with a solution.

 

[Kirby]

Unfortunately, there is no built-in way to delete a single entry.

But you can do this manually:
When viewing the entry in the log, the URL of the image should be admin.php?logs/image-proxy/<id>/image

1. Note down id
2. Execute query DELETE FROM xf_image_proxy WHERE image_id = <id>
3. Divide id by 1000, note down result excluding the fraction part
4. Go to directory internal_data/image_cache/<result> and delete <id>-<hash>.data