[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).


Upgraded to mysql 4.1.9 and now it's working with no problems.

Thanks,

David