Mibew Messenger Community
General => Support => Topic started by: Erik on October 02, 2017, 04:25:32 PM
-
fantastic work with this script.
but when i running a statistics, I get this error...
Query failed: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mibew.s.threads' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
-
One should search before posting: https://mibew.org/forums/index.php/topic,192141.msg199596.html
-
Yes! when I search about this issue I get this..
My SQL is version 5.7.18
Finally, note that ONLY_FULL_GROUP_BY is trying to protect you from queries that use the MySQL group by extensions in a way that isn't consistent with that feature's purpose. Starting in 5.7.x, a query that is rejected by ONLY_FULL_GROUP_BY may in fact be producing non-deterministic results or may be taking advantage of side effects or results that are correct by accident or coincidence -- rather than by design -- and such behavior could disappear in a future release (for example, due to changes in the query optimizer) and thus shouldn't be relied on.
The best solution is to make the queries theoretically correct.
-
Ok, got it...
Would you mind to test the fixed version (currently in branch stats at Github)?
One could download the updated libs/statistics.php via this link (https://raw.githubusercontent.com/Mibew/mibew/b561f7eec86f0e5bdd07909b18aa27c7af128b83/src/mibew/libs/statistics.php). Once we understand that it works as intended, it will be scheduled for inclusion in the next release.
-
Great... Yeah, why would anyone bother himself to check the fixed issues? :(
The lack of feedback is soooo motivating... :-\