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

[Mark Fraser (Google Mail)]

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