forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Invalid ID on February 21, 2007, 10:39:29 pm

Title: Reset view counters
Post by: Invalid ID on February 21, 2007, 10:39:29 pm
Just did the worst thing. I didn't know how but I didn't notice that the option "Reset view counters (1)" is ticked by default and I accidentally clicked on "Submit".

And then noticed all the 1,50000 views had gone and now the statics is showing zero as file views.

Is there a possibility I can bring my lost counts? 
Title: Re: Reset view counters
Post by: Nibbler on February 21, 2007, 10:42:42 pm
If you have a backup you can, otherwise no, sorry.
Title: Re: Reset view counters
Post by: Invalid ID on February 21, 2007, 10:55:19 pm
As I mentioned I didn't notice this option is ticked by default, so I had no reason to make a backup before doing it.

I wonder how come such option is on ... gone my data gathered in 3 years.
Title: Re: Reset view counters
Post by: Nibbler on February 21, 2007, 11:09:28 pm
It's been discussed already and changed for the next version. Always keep regular backups.
Title: Re: Reset view counters
Post by: Invalid ID on February 22, 2007, 04:36:48 am
Too late. I will always wonder why this option was there ticked and who would like to lose the image views anyway.

Thanks
Title: Re: Reset view counters
Post by: Invalid ID on February 22, 2007, 04:53:27 am
Is there anyway I can increase total image views using phpMyadmin?
Title: Re: Reset view counters
Post by: Nibbler on February 22, 2007, 12:18:10 pm
Yes, you can specify whatever hits you like if you edit the database.
Title: Re: Reset view counters
Post by: imatrljan on March 01, 2007, 12:45:55 am
What table is holding all the viewcounts ? I can't find the real one! ???
Title: Re: Reset view counters
Post by: Nibbler on March 01, 2007, 12:47:48 am
It's the `hits` field in the picture table.
Title: Re: Reset view counters
Post by: imatrljan on March 01, 2007, 01:00:03 am
is this ok?

  `hits` int(10) NOT NULL default '0',

 i change to

  `hits` int(10) NOT NULL default '10000',

or? Thanks
Title: Re: Reset view counters
Post by: Nibbler on March 01, 2007, 01:14:24 am
That would give all new files 10000 views. If that is what you want then do that.