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

Roedel, Mark MarkRoedel at letu.edu
Fri Jan 7 12:17:50 EST 2005


As of 3.4.0 rc2, there's no schema.SQLite in etc/upgrade that would have
made this change.  (Although it does appear to be created correctly if
you're starting from scratch.)

--
MarkR


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jesse
Vincent
Sent: Friday, January 07, 2005 11:15 AM
To: Roedel, Mark
Cc: rt-bugs at fsck.com; rt-users at lists.bestpractical.com; David Snyder
Subject: Re: [rt-users] RT 3.4.0 rc's not completing search queries
oncustomfields?




On Fri, Jan 07, 2005 at 11:12:04AM -0600, Roedel, Mark wrote:
> 
> 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?

The change should have been made for every _supported_ database. SQLite,
MySQL, Postgresql and Oracle.

 
> --
> 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
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com
> 

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

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





More information about the rt-users mailing list