Mibew Messenger Community

General => Support => Topic started by: lpinto on May 12, 2017, 09:30:54 PM

Title: Statistics page error
Post by: lpinto on May 12, 2017, 09:30:54 PM

Hello.

I have an issue with the Statistics link in the Webim admin. When clicked it returns a blank page with the following text:

"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"

Any idea what this is or where could I attempt to correct it?

Thank you for your time and patience.

Title: Re: Statistics page error
Post by: faf on May 17, 2017, 04:58:42 PM

1. You didn't provided any details about your installation and working environment. That's bad. And I have a serious suspicion that you're asking about Mibew Messenger 1.6.x which is obsolete and not supported anymore.

2. In case you were banned from Google, take a look at this discussion (http://stackoverflow.com/questions/23921117/disable-only-full-group-by).