[rt-users] Re: Custom Field Searching broken again?

[David Snyder]

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

[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
execute failed: You have an error in your SQL syntax near 'ON ( 
ObjectCustomFieldValues_1.CustomField = CustomFields_2.id))   WHERE 
((main.' at line 1 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/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: 
RT::Handle=HASH(0xad70a30) couldn't execute the query '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%')) ' at 
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 
line 489., referer: http://fasit-rhel1.its.yale.edu/rt3.4/Search/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
execute failed: You have an error in your SQL syntax near 'ON ( 
ObjectCustomFieldValues_1.CustomField = CustomFields_2.id))   WHERE 
((main.' at line 1 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/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: 
RT::Handle=HASH(0xad70a30) couldn't execute the query '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%')) ' at 
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 
line 489., referer: http://fasit-rhel1.its.yale.edu/rt3.4/Search/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
execute failed: You have an error in your SQL syntax near 'ON ( 
ObjectCustomFieldValues_1.CustomField = CustomFields_2.id))   WHERE 
((main.' at line 1 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/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: 
RT::Handle=HASH(0xad70a30) couldn't execute the query '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%')) ' at 
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 
line 489., referer: http://fasit-rhel1.its.yale.edu/rt3.4/Search/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: DBD::mysql::st 
execute failed: You have an error in your SQL syntax near 'ON ( 
ObjectCustomFieldValues_1.CustomField = CustomFields_2.id))   WHERE 
((main.' at line 1 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/Build.html
[Thu Jan 13 16:19:51 2005] [error] [client 130.132.101.242] FastCGI: 
server "/opt/rt3.4rc5/bin/mason_handler.fcgi" stderr: 
RT::Handle=HASH(0xad70a30) couldn't execute the query 'SELECT DISTINCT 
main.* 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%')) ORDER BY main.id ASC' at 
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 
line 489., referer: http://fasit-rhel1.its.yale.edu/rt3.4/Search/Build.html