summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorlpsolit%gmail.com <>2006-01-16 19:29:18 +0100
committerlpsolit%gmail.com <>2006-01-16 19:29:18 +0100
commita47eba439a545a7f4542be3410fd1752d9c19c30 (patch)
treed663c33ad48ebca6beee7d44b571cef5dc3763f0
parent6930e2afb8af2a784f2c9ff6af3a8be6ee9a8920 (diff)
downloadbugzilla-a47eba439a545a7f4542be3410fd1752d9c19c30.tar.gz
bugzilla-a47eba439a545a7f4542be3410fd1752d9c19c30.tar.xz
Bug 323575: [PostgreSQL] sanitycheck.cgi?createmissinggroupcontrolmapentries=1 produces a SQL error - Patch by Frédéric Buclin <LpSolit@gmail.com> r/a=justdave
-rwxr-xr-xsanitycheck.cgi3
1 files changed, 2 insertions, 1 deletions
diff --git a/sanitycheck.cgi b/sanitycheck.cgi
index eeb45902f..9a80efd24 100755
--- a/sanitycheck.cgi
+++ b/sanitycheck.cgi
@@ -162,7 +162,8 @@ if (defined $cgi->param('createmissinggroupcontrolmapentries')) {
ON bugs.product_id = gcm.product_id
AND bgm.group_id = gcm.group_id
WHERE COALESCE(gcm.membercontrol, $na) = $na
- } . $dbh->sql_group_by('bugs.product_id, bgm.group_id'));
+ } . $dbh->sql_group_by('bugs.product_id, bgm.group_id',
+ 'gcm.membercontrol, groups.name, products.name'));
foreach (@$invalid_combinations) {
my ($product_id, $group_id, $currentmembercontrol,