aboutsummaryrefslogtreecommitdiffstats
path: root/editkeywords.cgi
diff options
context:
space:
mode:
Diffstat (limited to 'editkeywords.cgi')
-rwxr-xr-xeditkeywords.cgi12
1 files changed, 2 insertions, 10 deletions
diff --git a/editkeywords.cgi b/editkeywords.cgi
index 51294206d..1b8d6ef30 100755
--- a/editkeywords.cgi
+++ b/editkeywords.cgi
@@ -141,22 +141,14 @@ if ($action eq "") {
my $max_table_size = 50;
SendSQL("SELECT keyworddefs.id, keyworddefs.name, keyworddefs.description,
- COUNT(keywords.bug_id), keywords.bug_id
+ COUNT(keywords.bug_id)
FROM keyworddefs LEFT JOIN keywords ON keyworddefs.id = keywords.keywordid
GROUP BY keyworddefs.id
ORDER BY keyworddefs.name");
while (MoreSQLData()) {
- my ($id, $name, $description, $bugs, $onebug) = FetchSQLData();
+ my ($id, $name, $description, $bugs) = FetchSQLData();
$description ||= "<FONT COLOR=\"red\">missing</FONT>";
$bugs ||= 'none';
- if (!$onebug) {
- # This is silly hackery for old versions of MySQL that seem to
- # return a count() of 1 even if there are no matching. So, we
- # ask for an actual bug number. If it can't find any bugs that
- # match the keyword, then we set the count to be zero, ignoring
- # what it had responded.
- $bugs = 'none';
- }
if ($line_count == $max_table_size) {
print "</table>\n$tableheader";
$line_count = 0;
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67