{"id":507,"date":"2008-11-16T11:47:00","date_gmt":"2008-11-16T11:47:00","guid":{"rendered":"http:\/\/fiveforks.com\/jeb\/2008\/11\/resetting_joomla_hits_statisti\/"},"modified":"2008-11-16T11:47:00","modified_gmt":"2008-11-16T11:47:00","slug":"resetting_joomla_hits_statisti","status":"publish","type":"post","link":"https:\/\/www.fiveforks.com\/jeb\/2008\/11\/resetting_joomla_hits_statisti\/","title":{"rendered":"Resetting Joomla Hits Statistic"},"content":{"rendered":"<p>Joomla counts page hits in the <strong>jos_content<\/strong> table in a field called <strong>hits<\/strong>. These counts drive the &#8220;popular&#8221; 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.<\/p>\n<p>I tried using <a href=\"http:\/\/www.nab-design.de\/devcorner\/statscleaner.html\">Joomla StatsCleaner<\/a> but it generated an &#8220;Internal Server Error&#8221; and the following message: &#8220;The server encountered an internal error or misconfiguration and was unable to complete your request.&#8221; Who knows&#8230;<\/p>\n<p>So I  decided to use <a href=\"http:\/\/www.phpmyadmin.net\/home_page\/index.php\">phpMyAdmin<\/a> to issue an SQL statement. This did the trick, resetting all values to 0:<\/p>\n<blockquote><p>UPDATE jos_content SET hits=0<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Joomla counts page hits in the jos_content table in a field called hits. These counts drive the &#8220;popular&#8221; module, which I use on the SJN home page. I wanted to reset all of the counts, because over time, they have &hellip; <a href=\"https:\/\/www.fiveforks.com\/jeb\/2008\/11\/resetting_joomla_hits_statisti\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-507","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/comments?post=507"}],"version-history":[{"count":0,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/posts\/507\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/media?parent=507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/categories?post=507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fiveforks.com\/jeb\/wp-json\/wp\/v2\/tags?post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}