Mibew Messenger Community

General => Support => Topic started by: Erik on October 02, 2017, 04:25:32 PM

Title: Problems with mibew/index.php/operator/statistics
Post 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
Title: Re: Problems with mibew/index.php/operator/statistics
Post by: faf on October 02, 2017, 07:18:17 PM
One should search before posting: https://mibew.org/forums/index.php/topic,192141.msg199596.html
Title: Re: Problems with mibew/index.php/operator/statistics
Post by: Erik on October 03, 2017, 08:52:49 AM
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.
Title: Re: Problems with mibew/index.php/operator/statistics
Post by: faf on October 05, 2017, 08:51:37 AM
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.
Title: Re: Problems with mibew/index.php/operator/statistics
Post by: faf on October 11, 2017, 02:11:08 PM
Great... Yeah, why would anyone bother himself to check the fixed issues? :(

The lack of feedback is soooo motivating...  :-\