Re: [rt-users] Simple search using email address fails

Jesse Vincent Wed, 24 Oct 2007 11:32:49 -0700

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 '[EMAIL PROTECTED]')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 [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

PGP.sig
Description: This is a digitally signed message part

_______________________________________________
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 [EMAIL PROTECTED] or call us at +1 617 812 0745.


Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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

Re: [rt-users] Simple search using email address fails

Reply via email to