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

[Roedel, Mark]

Looks like ObjectCustomFieldValues is the correct table name.  (It's
renamed from TicketCustomFieldValues in the upgrade schema files in
etc/upgrade/3.3.0 for mysql, pgsql and Oracle.)  I wonder why the same
change wasn't made for the other supported databases?


--
MarkR



-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of David
Snyder
Sent: Friday, January 07, 2005 10:34 AM
To: rt-users at lists.bestpractical.com
Cc: rt-bugs at fsck.com
Subject: Re: [rt-users] RT 3.4.0 rc's not completing search queries on
customfields?


 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%20hre
f%3D%22%2Frt3.4%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3
C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject'%2C%0A'__Status__'%2C%0A'__QueueNam
e__'%2C%0A'__OwnerName__'%2C%0A'__Priority__'%2C%0A'__NEWLINE__'%2C%0A''
%2C%0A'%3Csmall%3E__Requestors__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__Creat
edRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__ToldRelative__%3C%2Fsmall
%3E'%2C%0A'%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csm
all%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



_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com