3.8.1 -- Ticket Search doesn't find requestor?

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.

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.