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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.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.tiki.org.
- Ticket ID
- 6453
- Created
- Tuesday 19 September, 2017 15:26:06 GMT-0000
by Bernard Sfez / Tiki Specialist - 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}
- OpenAI / GPT-3
- Wiki page, Table of content; Per page show / hide page of content is broken
- Should the CSS and JS source maps be part of Git? Part of the released version?
- Tracker properties, Status; Inconsistantcy between display preferences and status options
- Files; Values in Maximum width / height of images for a file gallery can to chain of errors and corrupt image files
;){kind=link}
;){kind=link}