Author Topic: Problems with mibew/index.php/operator/statistics  (Read 7685 times)

0 Members and 1 Guest are viewing this topic.

Erik

  • Jr. Member
  • **
  • Posts: 2
Problems with mibew/index.php/operator/statistics
« 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

faf

  • Mibew Staff Member
  • Native
  • *****
  • Posts: 951
    • Mibew Messenger
Re: Problems with mibew/index.php/operator/statistics
« Reply #1 on: October 02, 2017, 07:18:17 PM »

Erik

  • Jr. Member
  • **
  • Posts: 2
Re: Problems with mibew/index.php/operator/statistics
« Reply #2 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.

faf

  • Mibew Staff Member
  • Native
  • *****
  • Posts: 951
    • Mibew Messenger
Re: Problems with mibew/index.php/operator/statistics
« Reply #3 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. Once we understand that it works as intended, it will be scheduled for inclusion in the next release.

faf

  • Mibew Staff Member
  • Native
  • *****
  • Posts: 951
    • Mibew Messenger
Re: Problems with mibew/index.php/operator/statistics
« Reply #4 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...  :-\