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

[David Snyder]

> 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%'))

oops--it seems I'm still running the stock redhat mysql-3.23.58-2.3 on 
this box.  I'll upgrade to something that meets the stated system 
requirements and get back to you.  (FWIW that query fails from 
commandline as well with the same error).

Sorry,

David