Fix SQL error in summary page on PostgreSQL

dregad · dregad · commit 4143f30e942e · 2012-11-12T11:51:12.000+01:00
This is a regression introduced by the fix for issue #11928 (see commit 0c9dc2a) which was not detected before as it was tested on MySQL which has more permissive SQL syntax. Fixes #15201
diff --git a/core/summary_api.php b/core/summary_api.php
@@ -640,7 +640,7 @@ function summary_print_by_category() {
 				FROM $t_mantis_bug_table b
 				JOIN $t_mantis_category_table c ON b.category_id=c.id
 				WHERE b.$specific_where
-				GROUP BY $t_project_query c.name, b.status
+				GROUP BY $t_project_query c.name, b.category_id, b.status
 				ORDER BY $t_project_query c.name";
 
 	$result = db_query( $query );
