How to delete Download statistics?

Phoca Download - download manager
User avatar
KSteinwachs
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 02 Mar 2023, 08:51

How to delete Download statistics?

Post 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

Tags:
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9094
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: How to delete Download statistics?

Post 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
User avatar
KSteinwachs
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 02 Mar 2023, 08:51

Re: How to delete Download statistics?

Post by KSteinwachs »

Sorry:

Joomla: 4.28
Phoca Download: 4.0.5
PHP: 8.0.27

Thanks!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: How to delete Download statistics?

Post by Jan »

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

Image

Jan
If you find Phoca extensions useful, please support the project
User avatar
KSteinwachs
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 02 Mar 2023, 08:51

Re: How to delete Download statistics?

Post 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
User avatar
KSteinwachs
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 02 Mar 2023, 08:51

Re: How to delete Download statistics?

Post 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
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9094
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: How to delete Download statistics?

Post 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
User avatar
KSteinwachs
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 02 Mar 2023, 08:51

Re: How to delete Download statistics?

Post 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?!
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9094
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: How to delete Download statistics?

Post by Benno »

You're welcome!

Kind regards,
Benno
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: How to delete Download statistics?

Post 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
If you find Phoca extensions useful, please support the project
Post Reply