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: Reset view counters  (Read 3898 times)

0 Members and 1 Guest are viewing this topic.

Invalid ID

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • Apni Mehfil
Reset view counters
« 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? 
Logged

Nibbler

  • Guest
Re: Reset view counters
« Reply #1 on: February 21, 2007, 10:42:42 pm »

If you have a backup you can, otherwise no, sorry.
Logged

Invalid ID

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • Apni Mehfil
Re: Reset view counters
« Reply #2 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.
Logged

Nibbler

  • Guest
Re: Reset view counters
« Reply #3 on: February 21, 2007, 11:09:28 pm »

It's been discussed already and changed for the next version. Always keep regular backups.
Logged

Invalid ID

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • Apni Mehfil
Re: Reset view counters
« Reply #4 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
Logged

Invalid ID

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 22
    • Apni Mehfil
Re: Reset view counters
« Reply #5 on: February 22, 2007, 04:53:27 am »

Is there anyway I can increase total image views using phpMyadmin?
Logged

Nibbler

  • Guest
Re: Reset view counters
« Reply #6 on: February 22, 2007, 12:18:10 pm »

Yes, you can specify whatever hits you like if you edit the database.
Logged

imatrljan

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Reset view counters
« Reply #7 on: March 01, 2007, 12:45:55 am »

What table is holding all the viewcounts ? I can't find the real one! ???
Logged

Nibbler

  • Guest
Re: Reset view counters
« Reply #8 on: March 01, 2007, 12:47:48 am »

It's the `hits` field in the picture table.
Logged

imatrljan

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Reset view counters
« Reply #9 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
Logged

Nibbler

  • Guest
Re: Reset view counters
« Reply #10 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.