Fix SQL error in summary page on PostgreSQL

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
mantisbt · Nov 12, 2012 · 4143f30 · 4143f30
1 parent df10eff
commit 4143f30
Showing 1 changed file with 1 addition and 1 deletion.
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 );