Reset drupal statistics - The Read counter

Here is a quick and easy way to reset the drupal statistics stored in the database with a couple of SQL queries.

You can reset the Total counters with:

UPDATE `node_counter` set `totalcount` = 0;

And the day counters with:

UPDATE `node_counter` set `daycount` = 0;

Important: You should keep a backup of the database before performing any actions.

Another suggestion is to use the Statistics Advanced Settings module that comes with this setting.

Tags: 
Drupal 6, Drupal Quick Tips

Recent Comments

Forward by Dries Buytaert, Founder and Project Lead, Drupal; CTO Acquia.

Order now from:

Managing Expectations Podcast with DrupalEasy

Author Interview http://tinyurl.com/8a8nxno

We provide the most Shiny Drupal Bits & Pixels

Since Drupal 4.x