Statistics not working
- Status
- Closed
- Subject
- Statistics not working
- Version
- 17.x
- Category
- Error
- Feature
- Stats
- Resolution status
- New
- Submitted by
- Bernard Sfez / Tiki Specialist
- Lastmod by
- Bernard Sfez / Tiki Specialist
- Rating
- Description
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:Copy to clipboardExpression #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
It is working on my local, may be something to do with the infra ?- Importance
- 5
- Easy to solve?
- 5
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 6453
- Created
- Tuesday 19 September, 2017 15:26:06 UTC
by Bernard Sfez / Tiki Specialist - LastModif
- Tuesday 25 September, 2018 15:15:00 UTC