Elxis CMS Forum

Support => Administration => Topic started by: forgetms on November 02, 2009, 19:06:13

Title: How to reset statistics
Post by: forgetms on November 02, 2009, 19:06:13

Hi!

v2008.1.

I believe people will first reset all statistics shown under "Sites | Statistics" before bringing their sites to production run.  Maybe it's too easy to do that, but I have been unable to figure how. Would some kind soul show me how?

TIA

CN

Title: Re: How to reset statistics
Post by: datahell on November 02, 2009, 19:29:27

Go to phpmyadmin, select your database and execute the following SQL queries (one per time):

DELETE FROM elx_stats_agents

DELETE FROM elx_core_log_items

DELETE FROM elx_core_log_searches

UPDATE elx_content SET hits='0'

UPDATE elx_eblog SET hits='0'

Replace "elx_" with your own database prefix, if you use an other one.