Force expire old guest image uploads

[mkerala]

I am trying to get rid of guest image upload older than 2 years by forcing the image expire date.

update db1.images set image_expiration_date_gmt='2017-12-16 13:10:00' WHERE image_date <= '2014-07-05 00:00:00' and image_user_id is NULL;

This set expiration date on 5 images uploaded 3 years back. But even after one week of expiry the images are sill there.

Eg: https://gifyu.com/image/S

Anyone able to throw some light into how image expiration works. So I could further troubleshoot this.

 

[Rodolfo]

It should work, I don't think that your steps are wrong. Maybe there's something else? Like an old external storage without access?

 

[mkerala]

Only this year I moved to external storage. Before that all images are locally stored and I can also delete them manually using the delete button. I thought this problem was due to expire date being too close. So I tried a new date with 3 days time to reach. Still no luck.

I tested uploading a new image with 5 mins expire time and turns out the whole expire image thing is not working on my site.

 

[Rodolfo]

Just tested the demo and works fine. It deletes the database row and it removes the files (it needs CF recache).

Maybe your custom editing broke that thing or you need to refresh your file cache.

 

[mkerala]

This is now resolved after updating to 3.10.6. Both old images and new ones are getting deleted.