[Ask] Applying 1 year expiration on all guest uploaded contents

[Andy]

I’ve just configured my Chevereto setup to expire guest-uploaded content after 1 year automatically, but I’m wondering how I can retroactively apply this 1-year expiration to all existing guest uploads. Any tips would be greatly appreciated!

 

[Andy]

@Rodolfo: Can we run a manual SQL query for this?

 

[Andy]

bump

 

[Rodolfo]

UPDATE chv_images
SET image_expiration_date_gmt = NOW() - INTERVAL 1 YEAR
WHERE image_user_id IS NULL;