Delete Inactive Image

[siddharth]

Hi All,

We have the option to delete guest images after a few days or month or a year. It would be nice to add another option to delete inactive images for guest or users by days, month or year.

If the image didn't get hit on its image viewer URL, then it is inactive.

 

[mkerala]

You can try this

Purge guest images older than specific date with SQL query

If you are looking to reclaim some space on your server by deleting those guest images without any views, run the below query to force expire them in database which will get deleted cleanly. update chev_images set image_expiration_date_gmt='2018-11-10 00:00:00' WHERE image_date

chevereto.com

 

[siddharth]

Thanks for pointing it out, I can see the author has said he will add it in the script a few years back. It will be easier for everyone to automate it if it is available in the backend.

 

[Rodolfo]

Thanks for pointing it out, I can see the author has said he will add it in the script a few years back. It will be easier for everyone to automate it if it is available in the backend.

The point is that such addition becomes meaningless if you already have an alternative that will take you 1 minute to do it.

This doesn't mean that it won't be implemented (we have a section for those), it just means that is not the time yet.

 

[siddharth]

Right, but one minute on a daily basis and it may lead to human error when doing it manually.

And after a year or so, we need to prune images that are 365 days old with XX views. Now every new day passes we will have 1000s of images to be deleted daily if a website gets 1000s of images uploaded daily.

Example:

23/06/2022, It will delete 23/06/2021 images (1000+)
24/06/2022, It will delete 24/06/2021 images (1000+)

And it goes on

Let more people vote for it and so it gets added 🙂

 

[Rodolfo]

Right, but one minute on a daily basis and it may lead to human error when doing it manually.

Who said anything about do it manually? You can run that query from any console.