<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>I realize this has
been mentioned ad-nauseum on this list - but I can't seem to find a post that
discusses the fix.</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>First, the
particulars:</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>Debian, tracking
both sarge and sid. All software is installed "The Debian
Way."</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>Perl
v5.8.4;</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>DBD::mysql
v2.9003;</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>DBI
v1.46;</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>DBIx::SearchBuilder
v1.22;</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>mysql v14.7
Distrib 4.1.11</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>RT
v3.4.1;</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>When searching for
tickets with "(no value)" in the custom field, I see this in the
mysql.log:</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>SELECT<BR>
COUNT(DISTINCT main.id)<BR>FROM<BR> ((Tickets main LEFT
JOIN<BR> ObjectCustomFieldValues ObjectCustomFieldValues_1 ON
((ObjectCustomFieldValues_1.ObjectType = 'RT::Ticket'))<BR>
AND( (ObjectCustomFieldValues_1.Disabled = '0'))<BR>
AND( main.id = ObjectCustomFieldValues_1.ObjectId))<BR> JOIN
CustomFields CustomFields_2 ON ( ObjectCustomFieldValues_1.CustomField =
CustomFields_2.id)<BR> AND( (CustomFields_2.Name =
'Client')))<BR>WHERE<BR> ((main.EffectiveId =
main.id))<BR> AND ((main.Status !=
'deleted'))<BR> AND ((main.Type =
'ticket'))<BR> AND ((ObjectCustomFieldValues_1.Content LIKE
'%NULL%')<BR> AND(main.Queue =
'1')<BR> AND(main.Queue =
'1'))</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>This returns a
count of 0.</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>Whereas, when using
a query put together by based on a post by Ruslan U. Zakarov (posted to rt-users
on 1/14/2005, titled "Re: [rt-users] Re: Custom Field Searching broken
again?"):</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>SELECT<BR>
COUNT(DISTINCT main.id)<BR>FROM<BR> ((Tickets main LEFT JOIN<BR>
ObjectCustomFieldValues ObjectCustomFieldValues_1 ON ( main.id =
ObjectCustomFieldValues_1.ObjectId)))<BR>WHERE<BR> ((main.EffectiveId =
main.id)) AND ((main.Status != 'deleted')) AND<BR> ((main.Type =
'ticket'))<BR> AND ((ObjectCustomFieldValues_1.Content IS NULL))<BR>
AND main.Queue = '1'</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>This returns a
count of 91.</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>I note that David
Snyder (posted to rt-users on 1/14/2005 to the same thread as Ruslan) indicates
that an upgrade of mysql to 4.1 seemed to fix his problem.</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>My problem still
persists.</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>Thank you all for
any attention you can give me on this...</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma size=2>-
Richard</FONT></SPAN></DIV>
<DIV><SPAN class=816163017-04052005> </SPAN></DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=816163017-04052005><FONT face=Tahoma
size=2></FONT></SPAN> </DIV></BODY></HTML>