Category: Stats

I had this plugin working in Tiki9:

{CODE()}
{TRACKERSTAT(trackerId="2", fields="42", show_percent="n", show_bar="y", status="op", show_link="n")}{TRACKERSTAT}
{CODE}

Field 42 is a Category, with a few children.

It was working nicely in Tiki9.

Once upgraded to Tiki12.x svn, it stopped showing results.

If I change the field to a text field, results are shown as expected for that text field, os it seems a regression with categories.

Reproduced here:
http://xavi-9794-5261.show.tikiwiki.org/tiki-index.php?page=HomePage

u: admin
p: 12345

Tracker 1 has some items. Field 1 is title, field 3 category. No results shown for field 3.

~tc~ Reproduced also here: http://intercanvis.net/proves ~/tc~
---
Still buggy, as of April 18th, 2015 {sign user="xavi" datetime="2015-04-19T10:25:36+00:00"}

On a brand new tiki 17.x revision: 63870 on aws running ubuntu, php7 and webmin/virtuaImin.
I activate the statistics feature. After a few minutes I visit tiki-stats.php and it show an error:

{CODE()}Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydomain_tiki17.tiki_pageviews.day' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The query was:

SELECT SUM(`pageviews`) AS views, `day` AS unixtime FROM `tiki_pageviews` GROUP BY FROM_UNIXTIME(`day`, '%Y-%m-%d') ORDER BY views DESC LIMIT 1
The built query was likely:

SELECT SUM(`pageviews`) AS views, `day` AS unixtime FROM `tiki_pageviews` GROUP BY FROM_UNIXTIME(`day`, '%Y-%m-%d') ORDER BY views DESC LIMIT 1
{CODE}

It is working on my local, may be something to do with the infra ?

The diagrams of site statistics cannot handle if in the translation diacritic characters like German umlauts are used, instead some random looking special characters are rendered. In German "FAQ" are "Häufige Fragen"...

When you try to access a wiki page which doesn't exist, Tiki offers you a list of similarly named pages, to search for that word, to create the page, etc.

__Good.__

When you try to access other contents in Tiki (articles, blog posts, etc.) that don't exist (either have been deleted, moved, not yet published, protected, etc.), you get a Tiki error message.

__Good as well.__


But what if you try an URL which is just not possible?

Ex.: If you migrated from another system to Tiki and you are still getting hits with the previous URLs?

Of course, you could check your access logs and add nice redirects. But how can we make this easier for site admins?


The bundled _htaccess file (which you need to rename .htaccess to make active) has an example line:
{img src=images/code.png}%%% {CODE()}
ErrorDocument 404 /tiki-index.php?page=Page+not+found
{CODE}

__This is good.__

Now, how could we use this to provide the Tiki admin with a top-x error pages? And thus, it would help to detect broken links, etc.

Could .htaccess include some configuration info from Tiki? So a Tiki admin could add configuration information without using FTP, all in Tiki, possibly with a secret "system" wiki page.

Great inspiration:
https://github.com/h5bp/html5-boilerplate/blob/master/dist/.htaccess

{syntax type="tiki" editor="plain"}
1- Turn on multilingual
2- restrict to 3 languages
3- go to compile one of the three

Notice crazy stats :-)

{syntax type="tiki" editor="plain"}
With ajax on, the page-top links to sections don't work, on tiki-stats.php, in my Tiki 3.1 installations.

Please see ((WikiBlame)) and ((WikiTrust))

On Tiki as long as the feature "Stats" (tiki-admin.php?page=stats&highlight=feature_stats) is not enabled (it is disabled by default) hits on pages are not counted.

However, even the feature is disabled there is a "hit" column displayed at http://bsfez-11581-8115.show2.tikiwiki.org/tiki-listpages.php (and certainly other places). It will be populated with a lot of 0 for Tikis that will never use or needs stats.

{img fileId="1772" thumb="box"}

{img fileId="1773" thumb="box"}