Report Query Failed - mysql error 1111 Invalid Group Function

[bunk3m]

A gui created report is failing with the mysql error 1111 invalid group function

Issue

The report query is failing is to identify the number of meetings completed in the past week for each user. A similar task report has the same error.

Both queries were created in the gui and have a mysql error 1111 for invalid group function.

Expected Behavior

Reports created and run from the GUI should run without error.

Actual Behavior

Report gives an error in the log. Error is as follows: Query Failed: SELECT COUNT(meetings.name) AS 'Number_of_meetings' FROM meetings WHERE ( COUNT(meetings.name) IS NOT NULL AND (meetings.date_start BETWEEN "2018-04-02 00:00:00" AND "2018-04-09 00:00:00" ANDmeetings.status = 'Held' ) AND meetings.deleted = 0 ): MySQL error 1111: Invalid use of group function

Possible Fix

unknown

Steps to Reproduce

Report "Meetings since last week"

1. Create new report
2. Select report module:Meetings
3. Enter info as per attached 2 screenshots
4. Put the report into a Dashboard tab.
5. When you click the tab with the report the report will run.
6. Check the suitecrm log and find an error as above.

Context

Error appears each time you select the dashboard tab and the report is run.

Your Environment

• SuiteCRM Version used: 7.10.4 (error happened in 7.10.3) Report was originally created in 7.9.9 and didn't give an error until recent versions.
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Current Firefox 59.0.2 & Chrome Version 65.0.3325.181 (Official Build) (64-bit)
• Environment name and version (e.g. MySQL, PHP 7): mysql Ver 15.1 Distrib 10.1.26-MariaDB PHP 7.0.27
• Operating System and version (e.g Ubuntu 16.04): Debian 9 (current)

[connorshea]

I think the problem is that the field set in the "Main group" dropdown doesn't have the 'Group' checkbox checked? It probably shouldn't be possible to create a query like that, I ran into the same thing when creating a report earlier.