[rt-users] Simple search using email address fails

[Geoff Roberts]

Hi,

I am using RT 3.6.4 with RTFM 2.2.0 RC7.

Simple searching (ie, clicking on the simple search link in the top menu) 
fails when I search using an email address.

No results are returned. Searching by subject name, Ticket number, queue name 
and fulltext work OK.

When searching by email address I get the following error in the logs (NOTE 
I've changed the email address and server name I used in the example to 
protect the innocent).

FastCGI: server "/usr/local/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
execute failed: Unknown column 'Users_3.id' in 'on clause' 
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 
492., referer: http://internalserver/rt/Search/Simple.html

FastCGI: server "/usr/local/rt3/bin/mason_handler.fcgi" stderr: 
RT::Handle=HASH(0x2523023c) couldn't execute the query 'SELECT COUNT(DISTINCT 
main.id) FROM ((Tickets main  JOIN Groups Groups_1  ON ((Groups_1.Domain 
= 'RT::Ticket-Role')) AND ( (Groups_1.Type = 'Requestor')) AND (  
Groups_1.Instance = main.id))  LEFT JOIN CachedGroupMembers 
CachedGroupMembers_2  ON ( CachedGroupMembers_2.GroupId = Groups_1.id) AND ( 
(CachedGroupMembers_2.MemberId = Users_3.id))) , Users Users_3  WHERE 
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
((main.Type = 'ticket')) AND ( (  ( (Users_3.EmailAddress 
LIKE '%username at somecompany.com%')AND(CachedGroupMembers_2.id IS NOT 
NULL) )  ) ) ' 
at /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 
505, referer: http://internalserver/rt/Search/Simple.html

I am using mysql 5.0.45 on the server side (4.1.20 on the client side), Perl 
5.8.8 and DBD::mysql v4.005, DBI v1.59, DBIx::SearchBuilder v1.43.

I have also tried with a mysql client 5.0.45. The same error is returned.

Any ideas as to why the query above is failing?

Kind regards,

Geoff