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: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
It is working on my local, may be something to do with the infra ?- Importance
- 5
- Easy to solve?
- 5
- Priority
- 25
- Demonstrate Bug
-
This bug has been demonstrated on show2.tikiwiki.org
Please demonstrate your bug on show2.tikiwiki.org
Version: Create show2.tikiwiki.org instanceAbout show2.tikiwiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tikiwiki.org instance. To start, simply select a version and click on "Create show2.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tikiwiki.org.
- Ticket ID
- 6453
- Created
- Tuesday 19 September, 2017 15:26:06 GMT-0000
- LastModif
- Tuesday 25 September, 2018 15:15:00 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Umbrella bug report for new missing tra() bugs
- Add Autoprefixer script to SCSS to CSS workflow in trunk/pre-Tiki19
- Bugs that cannot be explained?
- /templates/modules/mod-login_box.tpl broken translation
- Tracker TextArea field multilingual parameter filter is not applied in plugin List (all language are displayed)
;){kind=link}
;){kind=link}