From e1a952fd4b5828bf7fac787ecd217ce7c81b06c4 Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@hardison.net>
Date: Sun, 13 May 2018 23:57:12 -0400
Subject: fix bug in flagtype comments when there are no flag types

---
 extensions/FlagTypeComment/Extension.pm | 19 ++++++++++++-------
 1 file changed, 12 insertions(+), 7 deletions(-)

diff --git a/extensions/FlagTypeComment/Extension.pm b/extensions/FlagTypeComment/Extension.pm
index 3ec506176..e7b34113d 100644
--- a/extensions/FlagTypeComment/Extension.pm
+++ b/extensions/FlagTypeComment/Extension.pm
@@ -127,13 +127,18 @@ sub _set_ftc_states {
             'active_or_has_flags' => $bug->id,
         });
 
-        my $types = join(',', map { $_->id } @$flag_types);
-        my $states = "'" . join("','", FLAGTYPE_COMMENT_STATES) . "'";
-        $db_result = $dbh->selectall_arrayref(
-            "SELECT type_id AS flagtype, on_status AS state, comment AS text
-               FROM flagtype_comments
-              WHERE type_id IN ($types) AND on_status IN ($states)",
-            { Slice => {} });
+        if (@$flag_types) {
+            my $types = join(',', map { $_->id } @$flag_types);
+            my $states = "'" . join("','", FLAGTYPE_COMMENT_STATES) . "'";
+            $db_result = $dbh->selectall_arrayref(
+                "SELECT type_id AS flagtype, on_status AS state, comment AS text
+                FROM flagtype_comments
+                WHERE type_id IN ($types) AND on_status IN ($states)",
+                { Slice => {} });
+        }
+        else {
+            $db_result = [];
+        }
     }
 
     foreach my $row (@$db_result) {
-- 
cgit v1.2.3-24-g4f1b