[rt-users] RT 3.4.0 rc's not completing search queries on custom fields?

[David Snyder]

>> I'm assuming this is something specific to my system, since I can't
>> imagine we'd have made it to release candidates without something that
>> major still outstanding.  (Although if someone else is able to duplicate
>> it, I'll be all ears...)
>
>
> It looks like this can be reproduced on rt3.fsck.com - a search in the 
> rt2.0 queue for subsystem = 'HTML::Mason frontend' yields no results, 
> whereas there is at least one ticket in the queue (#2) that matches.
>
> One more datapoint - I'm running 3.3.12 and the feature works in that 
> version, at least on queue/ticket CFs.
>
>> I'm just not sure where to start with
>> troubleshooting.
>
>
> If you have a perl script (and some spare time!), how about stepping 
> through with the debugger?
>
> Steve
>
 From my apache error log when I try to search on a Ticket Custom Field:
[Fri Jan 07 11:15:26 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
execute failed: Table 'rt34.TicketCustomFieldValues' doesn't exist at 
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 
line 475., referer: 
http://fasit-rhel1.its.yale.edu/rt3.4/Search/Edit.html?Order=ASC&Query=%20'CF.%7BType%7D'%20%3D%20'problem'%20&Rows=50&OrderBy=id&Format='%20%20%20%3Cb%3E%3Ca%20href%3D%22%2Frt3.4%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23'%2C%0A'%3Cb%3E%3Ca%20href%3D%22%2Frt3.4%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject'%2C%0A'__Status__'%2C%0A'__QueueName__'%2C%0A'__OwnerName__'%2C%0A'__Priority__'%2C%0A'__NEWLINE__'%2C%0A''%2C%0A'%3Csmall%3E__Requestors__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E'

I found that the TicketCustomFieldValues is not defined in schema.mysql, 
only in schema.Informix and schema.Sybase.    Also, mysql, Oracle, Pg, 
and SQLite have and ObjectCustomFieldValues tables, where Informix and 
Sybase do not.  I'm not smart enought to figure out which is right 
though, or how to translate from Informix or Sybase syntax to mysql to 
create the table.

David