[rt-users] 3.8.1 -- Ticket Search doesn't find requestor?

[RT]

All -

The issue still exists, and I'm hoping the following details can shed
some light on things (and hopefully keep someone else from running
into similar problems!).

About my configuration:

CentOS 5.2 (all updates applied)
mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0
Server version: Apache/2.2.3
mod_perl-2.0.2-6.3.el5 (CentOS distributed)

Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
    osname=linux, osvers=2.6.18-53.1.14.el5pae, archname=i386-linux-thread-multi
    uname='linux builder16.centos.org 2.6.18-53.1.14.el5pae #1 smp wed
mar 5 12:07:47 est 2008 i686 athlon i386 gnulinux '

I upgraded to DBIx-SearchBuilder-1.54, per some suggestions in the
mailing list archives.

When I run a fulltext search on the requestor e-mail address, I get
the following results (see image) --

http://is.gd/2oZ6

When I use the Query Builder, the Requestors in green show up properly.

For some reason, the Requestors do not appear in the red-circled
tickets when using the Query Builder. However, when I view the ticket
itself (using Display.html?id=XXXX), the Requestor is displayed
properly under "People".

It appears that one part of the database has the Requestor set
properly, but the tables that the query builder (/Search/Build.html)
uses are not finding the Requestor in the proper place.

There are no errors reported in the apache error log(s), the mysql
error log or in /var/log/messages.

Is there some database query I can run to ensure the Requestor is
populated properly where /Search/Build.html is expecting it? New
tickets don't appear to have the issue -- only legacy tickets. If
there's a query I can run, or any other information I can provide,
please let me know.

Thanks again for any assistance you can offer.

Below is the output of "make fixdeps", which may shed some light on my
configuration.

/usr/bin/perl ./sbin/rt-test-dependencies --verbose --install
--with-mysql --with-fastcgi
perl:
       >=5.8.3(5.8.8)...found
users:
       rt group (apache)...found
       bin owner (root)...found
       libs owner (root)...found
       libs group (bin)...found
       web owner (apache)...found
       web group (apache)...found
CLI dependencies:
       Term::ReadKey...found
       Getopt::Long >= 2.24...found
       HTTP::Request::Common...found
       Term::ReadLine...found
       Text::ParseWords...found
       LWP...found
CORE dependencies:
       Class::ReturnValue >= 0.40...found
       Text::Quoted >= 2.02...found
       CSS::Squish >= 0.06...found
       Encode >= 2.13...found
       Module::Versions::Report >= 1.05...found
       MIME::Entity >= 5.425...found
       DBI >= 1.37...found
       Locale::Maketext::Lexicon >= 0.32...found
       Devel::StackTrace >= 1.19...found
       Digest::base...found
       Time::ParseDate...found
       File::Temp >= 0.18...found
       Locale::Maketext >= 1.06...found
       Tree::Simple >= 1.04...found
       Text::Template...found
       Scalar::Util...found
       HTML::Scrubber >= 0.08...found
       File::Spec >= 0.8...found
       Calendar::Simple...found
       DBIx::SearchBuilder >= 1.54...found
       Mail::Mailer >= 1.57...found
       File::ShareDir...found
       Regexp::Common...found
       Digest::MD5 >= 2.27...found
       HTML::Entities...found
       Cache::Simple::TimedExpiry...found
       File::Glob...found
       Locale::Maketext::Fuzzy...found
       Time::HiRes...found
       Text::Wrapper...found
       Log::Dispatch >= 2.0...found
       UNIVERSAL::require...found
       Email::Address...found
DASHBOARDS dependencies:
       HTML::RewriteAttributes >= 0.02...found
       MIME::Types...found
FASTCGI dependencies:
       CGI::Fast...found
       CGI >= 3.38...found
       FCGI...found
GPG dependencies:
       PerlIO::eol...found
       GnuPG::Interface...found
ICAL dependencies:
       Data::ICal...found
MAILGATE dependencies:
       Pod::Usage...found
       HTML::TreeBuilder...found
       Getopt::Long...found
       HTML::FormatText...found
       LWP::UserAgent...found
MASON dependencies:
       Storable >= 2.08...found
       CSS::Squish >= 0.06...found
       Apache::Session >= 1.53...found
       Errno...found
       Devel::StackTrace >= 1.19...found
       CGI::Cookie >= 1.20...found
       Text::WikiFormat >= 0.76...found
       XML::RSS >= 1.05...found
       HTML::Mason >= 1.36...found
       Digest::MD5 >= 2.27...found
MYSQL dependencies:
       DBD::mysql >= 2.1018...found
SMTP dependencies:
       Net::SMTP...found
STANDALONE dependencies:
       Net::Server::PreFork...found
       Net::Server...found
       HTTP::Server::Simple >= 0.34...found
       HTTP::Server::Simple::Mason >= 0.09...found

All dependencies have been found.

> Message: 6
> Date: Mon, 8 Sep 2008 15:58:22 -0500
> From: RT <rt at ragweed.net>
> Subject: [rt-users] 3.8.1 -- Ticket Search doesn't find requestor?
> To: rt-users at lists.bestpractical.com
> Message-ID:
>        <6222db450809081358x28c4875dpb7e284a3f6c6d816 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> All -
>
> I recently updated from 3.6.5 to 3.8.1, but have run into an issue
> with Ticket Search.
>
> If I view a ticket from "Display.html?id=XXX", the requestor is set to
> the expected value.
>
> However, if I search for the ticket using the "/Search/Build.html"
> query builder, it doesn't display. The query is irrelevant, it simply
> doesn't show up in the search results.
>
> If I remove the requestor and re-add them, they will then show up in
> the search as expected.
>
> Any ideas are appreciated.
>
> Thank you.