How to delete Download statistics?

[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

[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

[KSteinwachs]

Sorry:

Joomla: 4.28
Phoca Download: 4.0.5
PHP: 8.0.27

Thanks!

[Jan]

Hi, to rese the count, you need to select which items should be reseted:



Jan

[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

[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

[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)









Kind regards,
Benno

[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?!

[Benno]

You're welcome!

Kind regards,
Benno

[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:



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