Topic: Problems with mibew/index.php/operator/statistics

[Erik]

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

[faf]

One should search before posting: https://mibew.org/forums/index.php/topic,192141.msg199596.html

[Erik]

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.

[faf]

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. Once we understand that it works as intended, it will be scheduled for inclusion in the next release.

[faf]

Great... Yeah, why would anyone bother himself to check the fixed issues?

The lack of feedback is soooo motivating...