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

Thu Apr 3 15:38:17 EDT 2008

On Apr 3, 2008, at 3: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.

This was a simple typo introduced in DBIx-SearchBuilder 1.52 and
fixed the next day in 1.53.  It should have been
substr($self->DatabaseVersion, 0, 1)

It is probably worth upgrading to 1.53 if you're using 1.52, but
Ruz could say more.

-kevin

>
>
> 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
>
> _______________________________________________
> 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
>