Joomla! - Reset all hits to 0 (zero)

05.05.2009

We finally got a working version of the new Zuno Studios web site launch — as you can see from reading this ;). During the development phase we obviously did lots of testing and viewing of the content as we worked.

If you're not familiar with Joomla! it's one of the most powerful open source content management system frameworks out today. Before Google Analytics was even around Joomla! has been doing simple page view tracking or "hits" as it's called in the admin area.

Joomla! Admin Hits Counter

Once we launched the site all of the articles of our Joomla! powered site had huge amounts of "hits".  As nice as it was for me to wake up this morning and think 1,587 people viewed our "about us page" it was not a true reality. I just needed to reset all the article page hits.

Resetting the hits on a per-page basis is extremely easy, as a matter-of-fact there is a "reset hits" button right next to the hit tracker on every article edit page. That's great, but I had a hundred or so articles I needed to reset. I thought for sure this would be a difficult task, but thanks to the Joomla! forums and the  power of the community it was VERY simple.

It can easily be done through phpMyAdmin or on the command line by doing the following SQL query

update v2_content set hits = 0

Yes, that's it. I know I just did a lot of writing for such a simple solution, but I'm new to this blogging thing. Hope it helped.