Bug 347269: Deleting a user account displays incoherent comments - Patch by Frédéric Buclin <LpSolit@gmail.com> r=wurblzap a=justdave

1 files changed, 5 insertions, 5 deletions

diff --git a/editusers.cgi b/editusers.cgi
index e9e40eb4c..e53341c61 100755
--- a/editusers.cgi
+++ b/editusers.cgi
@@ -468,14 +468,14 @@ if ($action eq 'search') {
     $vars->{'longdescs'} = $dbh->selectrow_array(
         'SELECT COUNT(*) FROM longdescs WHERE who = ?',
         undef, $otherUserID);
-    $vars->{'namedqueries'} = $dbh->selectcol_arrayref(
+    my $namedquery_ids = $dbh->selectcol_arrayref(
         'SELECT id FROM namedqueries WHERE userid = ?',
-        undef,
-        $otherUserID);
-    if (@{$vars->{'namedqueries'}}) {
+        undef, $otherUserID);
+    $vars->{'namedqueries'} = scalar(@$namedquery_ids);
+    if (scalar(@$namedquery_ids)) {
         $vars->{'namedquery_group_map'} = $dbh->selectrow_array(
             'SELECT COUNT(*) FROM namedquery_group_map WHERE namedquery_id IN' .
-            ' (' . join(', ', @{$vars->{'namedqueries'}}) . ')');
+            ' (' . join(', ', @$namedquery_ids) . ')');
     }
     else {
         $vars->{'namedquery_group_map'} = 0;