[rt-devel] 2.1.72 Custom Field search error

Mon Feb 17 20:51:48 EST 2003

All,

When I attempt to perform a Search Query which involves a Custom Field (url 
below):

http://rt.host.edu.au/Search/Listing.html?Bookmark=FrT%253B%25402%257C%25252%257C%25241%257C7%25258%257C%252411%257CDESCRIPTION%25245%257CFIELD%25248%257COPERATOR%25245%257CVALUE%252415%257CQueue%2520%253D%2520General%25245%257CQueue%25241%257C%253D%25247%257CGeneral%25241%257C8&CompileRestriction=1&OwnerOp=%3D&ValueOfOwner=&RequestorOp=LIKE&ValueOfRequestor=&SubjectOp=LIKE&ValueOfSubject=&QueueOp=%3D&ValueOfQueue=&PriorityOp=%3C&ValueOfPriority=&DateType=Created&DateOp=%3C&ValueOfDate=&AttachmentField=Content&AttachmentFieldOp=LIKE&ValueOfAttachmentField=&StatusOp=%3D&ValueOfStatus=&CustomFieldOp1=LIKE&CustomField1=Problem&RowsPerPage=50&TicketsSortBy=id&TicketsSortOrder=DESC&RefreshSearchInterval=-1&Action=Search

I receive the following error:

error:
Unknown field: ITIL at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 217.

context:
...

277:
}
278:

279:
# All errors returned from this routine will be in exception form.
280:
local $SIG{'__DIE__'} = sub {
281:
rethrow_exception( $_[0] );
282:
};
283:

284:
#
285:
# $m is a dynamically scoped global containing this
...

code stack:
/usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm:281
/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:217
/opt/rt3/lib/RT/Tickets_Overlay_SQL.pm:297
/opt/rt3/lib/RT/Tickets_Overlay.pm:1946
/opt/rt3/lib/RT/Tickets_Overlay.pm:1688
/opt/rt3/share/html/Search/Listing.html:105
/opt/rt3/share/html/autohandler:162

The raw error is attached.

I previously had 2.1.69 installed and was receiving an error when I 
attempted to query a Custom Field with more than one search term.

i.e. Search Impact is Low (would work fine)
      Search Impact is Hight (would work fine)
      Search Impact is Low  Impact is High (would error out - different 
error than shown above).

So I upgraded to 2.1.72 to see if the error was still in place and am now 
receiving this new error. Any ideas?

Running RT within Apache 2/Mod_perl 1.99_07

-Brook

=========================================================================
=     _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/  _/ Brook Schofield                =
=    _/  _/ _/  _/ _/  _/ _/  _/ _/ _/   B.Schofield at mailbox.gu.edu.au  =
=   _/_/   _/_/_/ _/  _/ _/  _/ _/_/     Ph: +61 7 387 53779 - WCN 0.28 =
=  _/  _/ _/ _/  _/  _/ _/  _/ _/ _/     Directory Services Integration =
= _/_/_/ _/  _/ _/_/_/ _/_/_/ _/  _/     Griffith University QLD 4111   =
=========================================================================
-------------- next part --------------
Unknown field: ITIL at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 217.

Trace begun at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Exceptions.pm line 123
HTML::Mason::Exceptions::rethrow_exception('Unknown field: ITIL at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 217.^J') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 281
HTML::Mason::Request::__ANON__('Unknown field: ITIL at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 217.^J') called at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 217
RT::Tickets::_parser('RT::Tickets=HASH(0x135dd8c)', ' (  \'ITIL\' LIKE \'%Change Request%\'  ) ') called at /opt/rt3/lib/RT/Tickets_Overlay_SQL.pm line 297
RT::Tickets::FromSQL('RT::Tickets=HASH(0x135dd8c)', ' (  \'ITIL\' LIKE \'%Change Request%\'  ) ') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 1946
RT::Tickets::_ProcessRestrictions('RT::Tickets=HASH(0x135dd8c)') called at /opt/rt3/lib/RT/Tickets_Overlay.pm line 1688
RT::Tickets::Count('RT::Tickets=HASH(0x135dd8c)') called at /opt/rt3/share/html/Search/Listing.html line 105
HTML::Mason::Commands::__ANON__('DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm line 133
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x12491dc)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1045
eval {...}('HTML::Mason::Component::FileBased=HASH(0x12491dc)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1039
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)', 'HTML::Mason::Component::FileBased=HASH(0x12491dc)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 735
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)') called at /opt/rt3/share/html/autohandler line 162
HTML::Mason::Commands::__ANON__('DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm line 133
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xec1a28)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1040
eval {...}('HTML::Mason::Component::FileBased=HASH(0xec1a28)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 1039
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)', 'HASH(0x137f67c)', 'HTML::Mason::Component::FileBased=HASH(0xec1a28)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 336
eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)', 'HASH(0x137f67c)', 'HTML::Mason::Component::FileBased=HASH(0xec1a28)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 336
eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)', 'HASH(0x137f67c)', 'HTML::Mason::Component::FileBased=HASH(0xec1a28)', 'DateType', 'Created', 'OwnerOp', '=', 'CompileRestriction', 1, 'RefreshSearchInterval', -1, 'ValueOfOwner', '', 'QueueOp', '=', 'ValueOfAttachmentField', '', 'PriorityOp', '<', 'CustomField1', 'Change Request', 'AttachmentField', 'Content', 'Action', 'Search', 'Bookmark', 'FrT%3B%402%7C%250%7C%242%7C20', 'ValueOfRequestor', '', 'SubjectOp', 'LIKE', 'StatusOp', '=', 'TicketsSortBy', 'id', 'CustomFieldOp1', 'LIKE', 'ValueOfStatus', '', 'RowsPerPage', 50, 'ValueOfQueue', '', 'ValueOfPriority', '', 'ValueOfSubject', '', 'TicketsSortOrder', 'DESC', 'AttachmentFieldOp', 'LIKE', 'RequestorOp', 'LIKE', 'DateOp', '<', 'ValueOfDate', '') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Request.pm line 296
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 134
eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x13721e0)') called at /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/ApacheHandler.pm line 783
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x317044)', 'Apache::RequestRec=SCALAR(0xb79064)') called at /opt/rt3/bin/webmux.pl line 120
RT::Mason::handler('Apache::RequestRec=SCALAR(0xb79064)') called at -e line 0
eval {...}('Apache::RequestRec=SCALAR(0xb79064)') called at -e line 0