Resetting Joomla Hits Statistic

| | Comments (2) |

Joomla counts page hits in the jos_content table in a field called hits. These counts drive the "popular" module, which I use on the SJN home page. I wanted to reset all of the counts, because over time, they have become skewed. The control panel lets you reset to 0 page by page, but with hundreds of pages, that can be time consuming.

I tried using Joomla StatsCleaner but it generated an "Internal Server Error" and the following message: "The server encountered an internal error or misconfiguration and was unable to complete your request." Who knows...

So I decided to use phpMyAdmin to issue an SQL statement. This did the trick, resetting all values to 0:

UPDATE jos_content SET hits=0

2 Comments

Nice work guys!
this is just Amazing!
Thanks

Leave a comment

About this Entry

This page contains a single entry by Jeb published on November 16, 2008 11:47 AM.

Happy Birthday Ted! was the previous entry in this blog.

Credit Card Tune-Up is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Powered by Movable Type 4.31-en

Good Reads

Flickr Badge

www.flickr.com
This is a Flickr badge showing items in a set called Wallet. Make your own badge here.