some group by queries not compatible with ONLY_FULL_GROUP_BY

[Norman Richards]

ERROR 1055 (42000): Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tripwire.groups.eveID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The default config sets a sql_mode that updates disables ONLY_FULL_GROUP_BY so that these broken queries will execute. We should really just fix the queries.

This is low priority, but I'll do this at some point if nobody else does.