[rt-users] RE: simple search usage

[David Smithson]

Bizarro, but I was able to solve the "problem".

I tailed /var/log/httpd/error_log while running a smiple search by username:

Stack:
  [/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:240]
  [/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:485]
  [/opt/rt3/share/html/Elements/QueueSummary:61]
  [/opt/rt3/share/html/Elements/Quicksearch:52]
  [/opt/rt3/share/html/Widgets/TitleBox:49]
  [/opt/rt3/share/html/Elements/Quicksearch:55]
  [/opt/rt3/share/html/Elements/MyRT:87]
  [/opt/rt3/share/html/Elements/MyRT:61]
  [/opt/rt3/share/html/index.html:79]
  [/opt/rt3/share/html/autohandler:279] (/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:487)
[Fri Jul 28 17:25:43 2006] [error]: Query error in <<Queue = 'DeHart's Printing Services' AND Status = 'stalled'>>:
Error near ->s<- expecting a CLOSE_PAREN in Queue = 'DeHart's Printing Services' AND Status = 'stalled'

I fixed the dumb Queue name by removing the apostrophe ( these queue names were imported from another system ).

Ran tail again and simple search by username:

Stack:
  [/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:240]
  [/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:485]
  [/opt/rt3/share/html/Elements/QueueSummary:61]
  [/opt/rt3/share/html/Elements/Quicksearch:52]
  [/opt/rt3/share/html/Widgets/TitleBox:49]
  [/opt/rt3/share/html/Elements/Quicksearch:55]
  [/opt/rt3/share/html/Elements/MyRT:87]
  [/opt/rt3/share/html/Elements/MyRT:61]
  [/opt/rt3/share/html/index.html:79]
  [/opt/rt3/share/html/autohandler:279] (/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:487)

Problem is gone now.  Simple search seems to work now with whatever I throw at it.

David Smithson
________________________________

CLICK HERE FOR ONLINE SUPPORT

-----Original Message-----
From: Dario Luis Coneglian Oliveros [mailto:oliveros at cpqd.com.br] 
Sent: Friday, July 28, 2006 10:04 AM
To: David Smithson
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RE: simple search usage

Simple search works for me, except for queue names. Weird !?!
I tried ticket id, email address and had no problem at all.
Dário

David Smithson wrote:

>Correction, search by queue name works, but nothing else.  Anyone else
>have this problem?
>
>David Smithson
>________________________________
>
>CLICK HERE FOR ONLINE SUPPORT
>
>-----Original Message-----
>From: David Smithson 
>Sent: Friday, July 28, 2006 9:47 AM
>To: rt-users at lists.bestpractical.com
>Subject: simple search usage
>
>Hi all.  
>
>The text from the Simple Search says this:
>
>----
>Search for tickets. Enter id numbers, queues by name, Owners by username
>and Requestors by email address. RT will look for anything else you
>enter in ticket bodies and attachments.
>
>Searching the full text of every ticket can take a long time, but if you
>need to do it, you can search for any word in full ticket history for
>any word by typing fulltext:word.
>
>RT will look for anything else you enter in ticket subjects.
>----
>
>I'm running 3.6.0, MySQL, FC5, etc.
>
>The *only* thing that the simple search will do in my instance of RT is
>parse the subject.  If I prefix with fulltext:, it parses Attachments.
>None of the other fields that it claims to search are being searched (
>username, email address, queues ).  Has anybody else seen this?
>
>David Smithson
>________________________________________
>ActivSupport, Inc.
>Your Flexible IT Partner
>Microsoft Gold Partner -- Small Business Specialist
>http://www.activsupport.com
>Director of Technical Services
>Direct: (415) 869 2991 
>________________________________________
>Technical Support Hotline: (415) 979 9285 
>CLICK HERE FOR ONLINE SUPPORT 
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Community help: http://wiki.bestpractical.com
>Commercial support: sales at bestpractical.com
>
>
>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>Buy a copy at http://rtbook.bestpractical.com
>
>
>We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
>  
>