[rt-users] Colons in queue name seems to break Quicksearch display in rt-3.4.3

Marc A Tisseur marct at alcor.concordia.ca
Fri Aug 12 19:24:03 EDT 2005


After installaing 3.4.3 I noticed the number of new or open tickets
in the Quicksearch list allways shows up as 0 for any queue containing a ":" in
its name. Selecting the queue will list the tickets however. rt-3.4.2's
quicksearch doesn't suffer the same problem. The principal diff between the two
is as follows;

--- rt-3.4.3/html/Elements/Quicksearch  2005-06-23 17:37:31.000000000 -0400
+++ rt-3.4.2/html/Elements/Quicksearch  2005-02-01 09:20:40.000000000 -0500
@@ -57,11 +57,9 @@
 while (my $queue = $Queues->Next) {
   next unless ($queue->CurrentUserHasRight('ShowTicket'));

-  my $name = $m->interp->apply_escapes($queue->Name, "u");
-
-  my $new_q = "Queue = '$name' AND Status = 'new'";
-  my $open_q = "Queue = '$name' AND Status = 'open'";
-  my $all_q = "Queue = '$name' AND (Status = 'open' OR Status = 'new')";
+        my $new_q = "Queue = '".$queue->Name."' AND Status = 'new'";
+        my $open_q = "Queue = '".$queue->Name."' AND Status = 'open'";
+        my $all_q = "Queue = '".$queue->Name."' AND (Status = 'open' OR Status
= 'new')";

   $Tickets->FromSQL($open_q);
   my $open = $Tickets->Count();
@@ -69,8 +67,10 @@
   $Tickets->FromSQL($new_q);
   my $new = $Tickets->Count();


Can anyone point out to me if there other "prohibited" characters that I should
be aware of?


Server specs;
Linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i686 unknown
Slackware 8.1
Apache/1.3.33 (Unix) mod_perl/1.29 mod_ssl/2.8.22 OpenSSL/0.9.6d configured 
Perl 5.8.6
DBIx::SearchBuilder 1.31
PostgreSQL 8.0.3

Much appreciated,
-- 
Marc Tisseur
Manager, Desktop Support Group and Helpline - IITS
Concordia University
Montreal, Canada




More information about the rt-users mailing list