Error in log of fresh install of RT 3.6.6

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@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@ndshq.com
sent To: djackson@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@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@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@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@ndshq.com
sent To: djackson@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@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@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@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

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
LBNLOn 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@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@ndshq.com sent To:
djackson@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@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@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@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@ndshq.com sent To:
djackson@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@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@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@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



The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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’}];From: Kenneth Crocker [mailto:KFCrocker@lbl.gov]
Sent: Thursday, April 03, 2008 2:50 PM
To: mpfraser@ndshq.com
Cc: rt-users@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

Mark,

Sorry. My fingers are just so fat that sometimes it looks like I can't 

spell or got lost or something. When I wrote a recipient was
“privileged” as a reason to NOT get an email, I obviously meant “Not
Privileged”. Sorry.

Kenn
LBNLOn 4/3/2008 11:49 AM, Kenneth Crocker wrote:

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@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@ndshq.com sent To:
djackson@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@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@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@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@ndshq.com sent To:
djackson@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@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@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@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



The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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
LBNLOn 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@lbl.gov]
Sent: Thursday, April 03, 2008 2:50 PM
To: mpfraser@ndshq.com
Cc: rt-users@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@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@ndshq.com sent To:
djackson@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@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@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@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@ndshq.com sent To:
djackson@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@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@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@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



The rt-users Archives

Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

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

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.

[snip]

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)

Install DBIx::SearchBuilder 0.53

I will answer any questions in reply and any ideas would be appreciated.

Respectfully,

Mark P. Fraser


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.