How can i reset stats?

[Kayz]

🎯Description of the issue

I would like to reset the stats on my site for the amount of images and albums hosted. However i would like to keep the users?

 

[JakeSully]

🎯Description of the issue

I would like to reset the stats on my site for the amount of images and albums hosted. However i would like to keep the users?

stats will be reseted if you delete the images that are uploaded. Since total images counter counts after how many images are uploaded to your site. If you delete it, then images stats will be 0.

 

[Kayz]

stats will be reseted if you delete the images that are uploaded. Since total images counter counts after how many images are uploaded to your site. If you delete it, then images stats will be 0.

Once upon a time i deleted the images via FTP, i also did this again the other day and the counter hasn't changed.

 

[JakeSully]

Once upon a time i deleted the images via FTP, i also did this again the other day and the counter hasn't changed.

since you are deleting images wrongly, you gota do it through site itself. that's why counter is still remaining as it is, if you don't delete images from within site itself then it won't un-register the images properly.

Every time you upload a image, it get's registered in database and gets a key url or w.e it's called. So when you delete them through ftp all you do is make thumbnails not loading and images won't load either, but keys for images remains since you did not delete it through site.

 

[Kayz]

since you are deleting images wrongly, you gota do it through site itself. that's why counter is still remaining as it is, if you don't delete images from within site itself then it won't un-register the images properly.

Every time you upload a image, it get's registered in database and gets a key url or w.e it's called. So when you delete them through ftp all you do is make thumbnails not loading and images won't load either, but keys for images remains since you did not delete it through site.

Makes sense thank you.

What happens to the URL's? Do they disappear? Not Found? Bad SEO?

Any way i can keep the urls and reset the stat?

 

[JakeSully]

Makes sense thank you.

What happens to the URL's? Do they disappear? Not Found? Bad SEO?

Any way i can keep the urls and reset the stat?

Once you deleted it through website, you will get page not found or image not found error page. something like that error will be.

 

[Rodolfo]

If helps, this is the query used to generate the global stats.

UPDATE `chv_stats` SET
stat_images = (SELECT IFNULL(COUNT(*),0) FROM `chv_images`),
stat_albums = (SELECT IFNULL(COUNT(*),0) FROM `chv_albums`),
stat_users = (SELECT IFNULL(COUNT(*),0) FROM `chv_users`),
stat_image_views = (SELECT IFNULL(SUM(image_views),0) FROM `chv_images`),
stat_disk_used = (SELECT IFNULL(SUM(image_size) + SUM(image_thumb_size) + SUM(image_medium_size),0) FROM `chv_images`)
WHERE stat_type = "total";

 

[Kayz]

If helps, this is the query used to generate the global stats.

UPDATE `chv_stats` SET
stat_images = (SELECT IFNULL(COUNT(*),0) FROM `chv_images`),
stat_albums = (SELECT IFNULL(COUNT(*),0) FROM `chv_albums`),
stat_users = (SELECT IFNULL(COUNT(*),0) FROM `chv_users`),
stat_image_views = (SELECT IFNULL(SUM(image_views),0) FROM `chv_images`),
stat_disk_used = (SELECT IFNULL(SUM(image_size) + SUM(image_thumb_size) + SUM(image_medium_size),0) FROM `chv_images`)
WHERE stat_type = "total";

So by the looks of things this will reset the stats to 0 on the dashboard?

Will the url's to the blank pages be deleted also or will they remain?

 

[Rodolfo]

No, that one recounts all the stats. If you want to start over simply inject "0" in the totals row of the stats table.

 

[Kayz]

No, that one recounts all the stats. If you want to start over simply inject "0" in the totals row of the stats table.

If i did this will it delete all the existing urls?

 

[Rodolfo]

No. If you want to delete the URLs and keep the files then truncate the table.