• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

Force expire old guest image uploads

M

mkerala

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

Code: 
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.
 
It should work, I don't think that your steps are wrong. Maybe there's something else? Like an old external storage without access?
 
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.
 
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.
 
You must log in or register to reply here.
Back
Top