In the "MySQL or MariaDB Database Properties" section, tiki-check.php appears to be agnostic about the setting of "Strict Mode" reporting the item in the "info" category.
Our experience has shown that how this value is set is very significant to TW and tiki-check should test this item and report as "good" or "ugly".
If Strict Mode reports "STRICT_TRANS_TABLES" then the tiki-check explanation is "MySQL is using strict mode."
However, in this situation tiki-stats.php fails reporting
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'trp.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-No value assignedd') 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-No value assignedd') ORDER BY views DESC LIMIT 1
If mysqld.cnf is updated to include sql-mode="NO_ENGINE_SUBSTITUTION", then tiki-check shows "MySQL is not using strict mode." and tiki-stats runs without issue.
We have tested this on LTS15.5 but I note tickets 6303 reported by DNeukomm on TW16.x and 6453 reported by Bernard Sfez on TW17.x with what I suspect are related issues.
To 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.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.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 show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |