[rt-users] Simple search using email address fails

[Jesse Vincent]

Can you test with current versions of RTFM (2.2.1) and SearchBuilder  
(1.49)?


On Oct 24, 2007, at 10:51 AM, Geoff Roberts wrote:

> 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
>
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:
>
> If you sign up for a new RT support contract before December 31,  
> we'll take
> up to 20 percent off the price. This sale won't last long, so get  
> in touch today.
>     Email us at sales at bestpractical.com or call us at +1 617 812 0745.
>
>
> 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
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071024/84118bbe/attachment.sig>