Batch reset hits

[phidias81]

Is there a way to reset hits of the images all togheter, other than going inside each picture and putting manually the input to 0? Thank you!

[Jan]

Hi, I think, the easiest way is to run some sql query in phpmyadmin to do this.

[phidias81]

Ok, thank you!
If somebody else have to do it and doesn't know how, the string to write in phpmyadmin>SQL is

Code: Select all

UPDATE csoph_phocagallery
SET hits='0'

change the prefix if you have different!

[Jan]

Ok, thank you for the guide.

Jan

[phidias81]

Actually only now I recognized that the hits are not recorded anymore. After I set everything to 0, now is just staying to 0, is not updating. What's wrong?

[phidias81]

Actually I eventually found out that the problem was that unfortunately Highslide only image is not storing the hits

[Jan]

Hi, see:
https://www.phoca.cz/documents/50-phoca/ ... al-advices (8)

Jan