Delete Unseen Images

[sk243]

How to delete images that was not viewed anytime.

 

[teejam]

How to delete images that was not viewed anytime.

This is a twist on this post, but couldn't you just do:

update images set image_expiration_date_gmt='2000-01-01 00:00:00' WHERE image_views=0;

 

[sk243]

Where to set it? Please say in details?

 

[teejam]

Where to set it? Please say in details?

It's just an SQL query, so you'd run it on your database. You should know what it does though and how Chevereto handles expired images before you run it.

 

[sk243]

Can you help me on that?

 

[teejam]

Can you help me on that?

I think if you don't know how to run queries on the database then you probably shouldn't run queries on the database. It's possible to do a lot of damage. If you're interested in learning about basic MySQL that's great, it's just too much to get into here, and it's been covered elsewhere many times over.

 

[JakeSully]

When you upload a image, make sure you select the expire time in same window. Otherwise you gota use a delet URL to delet the image afterwards.