Loading...
 
Skip to main content

Features / Usability


Clearing Stats

posts: 10 United States

Hello,

I am currently setting my tiki up as a testing ground for multiple things, being as such the page counts and hits are going to be mostly development centered until it goes live to my support group.

Is there a way I can reset all usage statistics when the tiki gets shared out with the rest of my support group?

posts: 215

There is an option you can set to have Admin pageviews counted, or not:
Admin home -> General, General Settings tab, "Count admin pageviews".

As for clearing stats options, I think the only "Clear Stats" option available is for "Referer stats".
Admin -> Referer Stats.

The other hit counters can all be cleared using phpmyadmin. I've never cleared all of them, but sometimes when I make a major change to a wiki page, I will browse the tiki_pages table and reset the hit column for that page.

There are lots of tables with hit counters, here are some of the main ones:

Articles (shows as Reads)
UPDATE `tiki_articles` SET `nbreads` = 0;

Blogs (shows as "Visits" in blog list)
UPDATE `tiki_blogs` SET `hits` = 0;

Blog Posts, Tiki keeps track of hits on individual blog posts, but I do not know of any place the number of hits is displayed.
UPDATE `tiki_blog_posts` SET `hits` = 0;

Featured Links. Featured Links are a little tricky to find. Admin home -> General, Navigation tab, Menus section. If "Featured Links" is turned on, then click on the Actions icon and then "View" and it will show the list of Featured Links with their hits.
UPDATE `tiki_featured_links` SET `hits` = 0;

File Galleries
UPDATE `tiki_file_galleries` SET `hits` = 0;

File Galleries, individual file hits
UPDATE `tiki_files` SET `hits` = 0;

Forums (shows as Visits in Forums list)
UPDATE `tiki_forums` SET `hits` = 0;

Forum Posts (shows as Reads in Topics list)
UPDATE `tiki_comments` SET `hits` = 0;

Wiki Pages (shows as Hits on List Pages)
UPDATE `tiki_pages` SET `hits` = 0;

Tom

posts: 10 United States

Looking at what you said it looks like it will work for me, though its a shame that there isn't anything builtin for this task.

On another note, it may be worth also delimiting the search criterion by date so you can say... I want only this year and forwards stats for older pageviews and other things like that.