Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: How to avoid Detailed Hit Stats?  (Read 3066 times)

0 Members and 1 Guest are viewing this topic.

Hercules24

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 71
    • High Resolution Party Pictures
How to avoid Detailed Hit Stats?
« on: April 17, 2006, 09:40:09 pm »
Since I've upgraded to 144 I try to make a back up each week.
However I see that 1 of the 20 tables (hit stats) is growing very fast (over 6MB in 1 week)
I do want each file to say how many time it's been viewed, but I don't need the viewers IP, referrer adress etc.
What do I need to do?
« Last Edit: April 17, 2006, 10:48:10 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: How to avoid Detailed Hit Stats?
« Reply #1 on: April 17, 2006, 09:48:10 pm »
Disable the feature in config if you don't want it.
Logged

Hercules24

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 71
    • High Resolution Party Pictures
Re: How to avoid Detailed Hit Stats?
« Reply #2 on: April 17, 2006, 09:55:18 pm »
By switching the last 2 of these lines 2 No CPG won't be recording anymore detailed info in MySQL memory?
And is there a way to delete the current detailed stats in the MySQL dbase without losing the normal view counter?

Logging mode ***  Normal    All    Off    ( View logs )   
Log ecards  Yes    No   
Keep detailed vote statistics  Yes    No   
Keep detailed hit statistics  Yes    No 
Logged

Nibbler

  • Guest
Re: How to avoid Detailed Hit Stats?
« Reply #3 on: April 17, 2006, 10:07:13 pm »
You can empty the hit stats table using phpmyadmin.
Logged

Hercules24

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 71
    • High Resolution Party Pictures
Re: How to avoid Detailed Hit Stats?
« Reply #4 on: April 17, 2006, 10:23:46 pm »
I can see an "empty garbage can" in PHPMyAdmin in the table hit stats containing 45K records.
Deleting the content of this table won't affect the regular number of views showed with my pictures?
My normal counters are like children to me :)
Logged

Nibbler

  • Guest
Re: How to avoid Detailed Hit Stats?
« Reply #5 on: April 17, 2006, 10:36:13 pm »
It's fine, but make a backup first if you are not confident in using phpmyadmin.
Logged

Hercules24

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 71
    • High Resolution Party Pictures
Re: How to avoid Detailed Hit Stats?
« Reply #6 on: April 17, 2006, 10:44:09 pm »
Nibbler
Thank you very much for helping my out here.
MySQL is cleaned up again and I still got my regular stats up.
Problem Solved
 
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.024 seconds with 20 queries.