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
