[rt-users] Simple search using email address fails

[Huw Selley]

Hi,


On 24/10/07 3:51, "Geoff Roberts" <geoff at apro.com.au> wrote:

<snip>
> 
> 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

Can you run that query yourself on your mysql server? At the very least you
should get an error telling you what mysql thinks is wrong with the query
which might help.

Regards
Huw



s2s company email disclaimer    : http://www.s2s.ltd.uk/datasheets/email_disclaimer.pdf
s2s company registration number : 3952958
s2s VAT registration number     : GB763132055
Business premises               : Ground Floor, Overline House, Crawley, West Sussex, RH10 1JA
Registered address              : 29 High Street, Crawley, West Sussex, RH10 1BQ
Place of registration           : England