Hi,
On 24/10/07 3:51, "Geoff Roberts" <[EMAIL PROTECTED]> 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 '[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 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 _______________________________________________ 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