Search not working

RT Users
1

I am continually frustrated by the search function in the RT program. I
want to search through the content of a ticket, but everytime I attemp to I
get a returned result of zero. Even if I go to an advanced search and enter
"content LIKE ‘word’" I still get a result of nothing. However, I am able
to perform a search by looking for a word that is contained in the subject,
but never a word that is in the content. I started originally with RT Ver
3.4.5 running with ActivePerl ver. 5.8.8, Apache server 2.2.3, and MySQL
Server 5.0 on a WindowXP machine. I then attempted to search through the
wiki and other online articles to reveal any information on the problem that
I am having. When I could not find anything, I then attempted to move to a
Linux box and try from there. I used RT Ver. 3.6.3 with ActivePerl ver.
5.8.8, Apache server 2.2.3, and MySQL Server 5.0. Then I still had the same
problem with the search not searching through the content of the tickets
that I created. I then went back to my WindowsXP machine and went from
MySQL Server 5.0 to MySQL Server 4.1 to see if that was part of the problem.
Alas, I have still run into the same problem. I would really like to use
this program for my Help Desk solution, but I am not sure why I am having
this difficulty. Any help would be appreciated.

Thanks

2

Best as I can tell, simple search just searches subjects.

After you search using simple search if you click on "Edit Search"
you’ll see something like ( Subject LIKE ‘search term’ ).

So you can see that the search you are executing is not looking at the
body of tickets.

Kyle Sharp wrote:

3

Try doing your search with fulltext:search term. Does that turn up what
you need?

John Arends wrote:

4

I am continually frustrated by the search function in the RT program. I
want to search through the content of a ticket, but everytime I attemp to I
get a returned result of zero. Even if I go to an advanced search and enter
“content LIKE ‘word’” I still get a result of nothing. However, I am able
to perform a search by looking for a word that is contained in the subject,
but never a word that is in the content.

Have you seen the text on /Search/Simple.html?
I just did two fulltext searches today, I hadn’t ever done that before.

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.

5

I have just attempted a fulltext:word search and have returned zero results.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Jon Daley
Sent: Monday, January 08, 2007 2:09 PM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search not working

I am continually frustrated by the search function in the RT program. I
want to search through the content of a ticket, but everytime I attemp to
I
get a returned result of zero. Even if I go to an advanced search and
enter
“content LIKE ‘word’” I still get a result of nothing. However, I am able
to perform a search by looking for a word that is contained in the
subject,
but never a word that is in the content.

Have you seen the text on /Search/Simple.html?
I just did two fulltext searches today, I hadn’t ever done that before.

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.
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

6

I have just attempted a fulltext:word search and have returned zero results.

What do you have in your system, database, RT and apache logs? Are there
any error messages we could use as a hint of what’s going wrong?

7

I have checked all of those logs and cannot find any error that is
connected.-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Monday, January 08, 2007 3:17 PM
To: Kyle Sharp
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search not working

On Mon, Jan 08, 2007 at 03:14:42PM -0800, Kyle Sharp wrote:

I have just attempted a fulltext:word search and have returned zero
results.

What do you have in your system, database, RT and apache logs? Are there
any error messages we could use as a hint of what’s going wrong?

8

Alright I finally got this working on my Linux machine, but not on the
Windows machine. Actually, I’m glad that it is working on Linux because
that is the OS I wanted to use. Still not sure why the Windows wouldn’t
work (using the ‘fulltext:word’ fails to return results). However I am able
to use the fulltext:word on Linux and everthing works wonderfully. Thank
you all for you help through this matter.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of Kyle Sharp
Sent: Monday, January 08, 2007 3:35 PM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Search not working

I have checked all of those logs and cannot find any error that is
connected.

9

What did you change?

Kyle Sharp wrote: