Page 1 of 1

How to delete Download statistics?

Posted: 02 Mar 2023, 08:55
by KSteinwachs
Hello, I would like to reset the download statistics in PhocaDownload. I have a button "Reset", but it is not active?
Probably I have set some setting wrong, I appreciate help.
KS

Re: How to delete Download statistics?

Posted: 02 Mar 2023, 09:07
by Benno
Hi,
which Joomla! version do you use?
which Phoca Download component version do you use?
which PHP version do you use?

Kind regards,
Benno

Re: How to delete Download statistics?

Posted: 02 Mar 2023, 09:43
by KSteinwachs
Sorry:

Joomla: 4.28
Phoca Download: 4.0.5
PHP: 8.0.27

Thanks!

Re: How to delete Download statistics?

Posted: 02 Mar 2023, 12:54
by Jan
Hi, to rese the count, you need to select which items should be reseted:

Image

Jan

Re: How to delete Download statistics?

Posted: 02 Mar 2023, 14:52
by KSteinwachs
Hi,
this are not the "Downloads" i would like to reset (this works fine) but the "Statistics".
In this section, there is no button called "Clear" as in the "Download" Section
KS

Re: How to delete Download statistics?

Posted: 02 Mar 2023, 19:38
by KSteinwachs
I'v made a screenshot for you can see that there is no Button to "clear" the statistics:

https://i.imgur.com/TVplMC5.jpg

Re: How to delete Download statistics?

Posted: 02 Mar 2023, 21:02
by Benno
HI,
see images: go to your database, table phocadownload, seek the file you want to reset, and set the column 'hits' to 0 (Zero)

Image

Image

Image

Image

Kind regards,
Benno

Re: How to delete Download statistics?

Posted: 03 Mar 2023, 07:53
by KSteinwachs
Thank you very much, it worked fine.
BTW: Bug or Feature? It's a bit of a hassle to reset the hits all individually this way?!

Re: How to delete Download statistics?

Posted: 03 Mar 2023, 10:23
by Benno
You're welcome!

Kind regards,
Benno

Re: How to delete Download statistics?

Posted: 04 Mar 2023, 16:26
by Jan
Hi,
BTW: Bug or Feature? It's a bit of a hassle to reset the hits all individually this way?!
you can delete the hits/downloads per file manually:

Image

or as Benno wrote, per SQL query (if you don't add the WHERE clause there, you can do it for all files at same time)

Jan