[rt-users] Error in log of fresh install of RT 3.6.6

[Kenneth Crocker]

Mark,


	Sorry. I didn't mean to sound pedantic. I didn't know how experienced 
you were on any of this. Hell, I'm REALLY new to alot of it. However, to 
your question. If I understand what you're asking, it is why the last 
error? If so, it is because the value that exists in 
"($self->DatabaseVersion, 1)" is not numeric and the condition is a 
numeric comparison. I'm not a MySQL guy, but does that make any sense to 
you, about that data element? Hope this helps.


Kenn
LBNL


On 4/3/2008 12:11 PM, Mark Fraser (Google Mail) wrote:
> Thanks, but actually, my concern was really for the last item. I am not
> trying to be "smart", however I understand the general function and can even
> look at the specific code in the referenced file. I was trying not to have
> to figure out why the established code was generating this specific error,
> i.e. is it a bug or the result or poor data checking on the part of the
> original programmer. 
> 
> The following code snippet is from the "offending " file,
> "/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm"  :
> 
> sub DistinctQuery {
>     my $self = shift;
>     my $statementref = shift;
>     my $sb = shift;
> 
>     return $self->SUPER::DistinctQuery( $statementref, $sb, @_ )
>         if $sb->_GroupClause || $sb->_OrderClause !~ /(?<!main)\./;
> 
>     if ( substr($self->DatabaseVersion, 1) == 4 ) {        #<<<<<<<<<<<
> HERE, Line 87
>         local $sb->{'group_by'} = [{FIELD => 'id'}];
> 
> 
> -----Original Message-----
> From: Kenneth Crocker [mailto:KFCrocker at lbl.gov] 
> Sent: Thursday, April 03, 2008 2:50 PM
> To: mpfraser at ndshq.com
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Error in log of fresh install of RT 3.6.6
> 
> Mark,
> 
> 
> 	A couple of those entries are just informational. The ones that said
> "Not Sending" are alerting you to the fact that a scrip was enacted,
> probably a notification scrip, and for one or more reasons, it did NOT send
> any email to anyone. The reasons for not sending an email could be the
> recipient (like an added "cc" when you clicked "reply") was privileged, or
> the scrip that was enacted was "Notify Requestor" and you didn't have a
> scrip for "others" and when you added a "cc", you created an other, or if
> YOU were the requestor and you got into the ticket and hit "reply" RT won't
> "notify" the user that caused the transaction to initiate (RT figures if you
> did the work, it would be redundant to TELL you that you did the work. In
> that case you want the action to be "Autoreply"). Anyway, that's what those
> are. Nothing to worry about. The LAST one, however, seems to be telling you
> that someone tried to create a query that was comparing to fields that were
> not of the same type, like comparing an alpha field (like name) to a numeric
> field (like time or a quantity field or something). The search failed
> because of it. Hope this helps.
> 
> Kenn
> LBNL
> 
> On 4/3/2008 10:47 AM, Mark Fraser wrote:
>> I just finished installing RT 3.6.6 on a clean Linux system yesterday. 
>> I still have some configuration to do. I noticed that it was 
>> generating the following log entries with the last line showing an 
>> error. Without parsing the code myself, I do not know why this error 
>> is occurring and if it is of any great significance.
>>
>>
>> Apr  3 13:11:01 tracker RT: 
>> <rt-3.6.6-7675-1207242660-944.5-3-0 at ndshq.com> #5/119 - Scrip 3
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:266)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242660-944.5-3-0 at ndshq.com> sent  To: 
>> djackson at fednews.com
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:297)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242660-814.5-4-0 at ndshq.com> #5/119 - Scrip 4
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:266)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242660-814.5-4-0 at ndshq.com> No recipients found. 
>> Not sending. 
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:278)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242661-1454.5-15-0 at ndshq.com> #5/119 - Scrip 15
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:266)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242661-1454.5-15-0 at ndshq.com> sent  To: 
>> djackson at fednews.com
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:297)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242661-958.5-16-0 at ndshq.com> #5/119 - Scrip 16
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:266)
>>
>> Apr  3 13:11:02 tracker RT: 
>> <rt-3.6.6-7675-1207242661-958.5-16-0 at ndshq.com> No recipients found. 
>> Not sending. 
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Action/SendEmail.pm:278)
>>
>> Apr  3 13:11:02 tracker RT: Ticket 5 created in queue 'Support' by 
>> djackson at fednews.com
>> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Ticket_Overlay.pm:756)
>>
>> Apr  3 13:19:27 tracker RT: Argument ".0.27" isn't numeric in numeric 
>> eq
>> (==) at
>> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 
>> 87. 
>> (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm:87)
>>
>> I will answer any questions in reply and any ideas would be appreciated.
>>
>> Respectfully,
>>
>> Mark P. Fraser
>>
>>
>> ----------------------------------------------------------------------
>> --
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com Commercial support: 
>> sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
> 
>