[rt-users] Re: Custom Field Searching broken again?

[Jesse Vincent]

On Thu, Jan 13, 2005 at 04:25:41PM -0500, David Snyder wrote:
> David Snyder wrote:
> 
> >I've just installed 3.4.0rc5  (previously was testing rc2).  Is it 
> >just me, or is custom field searching still not working?
> >
> >David
> 
> I meant to include this from my apache error log.  This was when trying 
> to search for tickets where a global custom field contains "problem."
> Also, I've got SearchBuilder 1.19

What version of mysql are you running?
If you run this command from the mysql commandline, what do you get?


SELECT COUNT(DISTINCT main.id) FROM ((Tickets main LEFT JOIN
	ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( main.id = 
	ObjectCustomFieldValues_1.ObjectId)) JOIN CustomFields CustomFields_2
	ON ( ObjectCustomFieldValues_1.CustomField = CustomFields_2.id))  WHERE
	((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND 
	((main.Type = 'ticket')) AND ((ObjectCustomFieldValues_1.Content LIKE  
	'%problem%')) 


--