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