Error on autoReply

Upgraded to the latest snapshot (1.3.83), and also the latest
DBIx:SearchBuilder.pm. AutoReply has stopped working. Here’s the
contents of the log file:

Debug mode enabled
Use of uninitialized value in pattern match (m//) at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder.pm line 893,
line 21.
DBD::Pg::st execute failed: ERROR: Attribute main.scripcondition must
be GROUPed or used in an aggregate function
DBIx::SearchBuilder error:ERROR: Attribute main.scripcondition must be
GROUPed or used in an aggregate function

    Query String is SELECT main.* FROM Scrips main, ScripConditions

ScripConditions_1 WHERE ((ScripConditions_1.ApplicableTransTypes LIKE
’%Create%’) OR (ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’))
AND ((main.Queue = ‘2’) OR (main.Queue = ‘0’)) AND main.ScripCondition =
ScripConditions_1.id GROUP BY main.id
DBD::Pg::st fetchrow_hashref failed: no statement executing
Use of uninitialized value in delete at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record/Cachable.pm
line 136, line 21.
Ticket 27 created in queue ‘TechOps’

The ticket is getting created fine, but the autoreply, sh’e dead Jim.

— Gavin Adams
Promisant Ltd.
Bermuda

Ho-hum. Will be fixed in DBIx::SearchBuilder 0.38On Fri, Jun 01, 2001 at 01:59:34PM -0300, Adams, Gavin wrote:

Upgraded to the latest snapshot (1.3.83), and also the latest
DBIx:SearchBuilder.pm. AutoReply has stopped working. Here’s the
contents of the log file:

Debug mode enabled
Use of uninitialized value in pattern match (m//) at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder.pm line 893,
line 21.
DBD::Pg::st execute failed: ERROR: Attribute main.scripcondition must
be GROUPed or used in an aggregate function
DBIx::SearchBuilder error:ERROR: Attribute main.scripcondition must be
GROUPed or used in an aggregate function

    Query String is SELECT main.* FROM Scrips main, ScripConditions

ScripConditions_1 WHERE ((ScripConditions_1.ApplicableTransTypes LIKE
’%Create%’) OR (ScripConditions_1.ApplicableTransTypes LIKE ‘%Any%’))
AND ((main.Queue = ‘2’) OR (main.Queue = ‘0’)) AND main.ScripCondition =
ScripConditions_1.id GROUP BY main.id
DBD::Pg::st fetchrow_hashref failed: no statement executing
Use of uninitialized value in delete at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record/Cachable.pm
line 136, line 21.
Ticket 27 created in queue ‘TechOps’

The ticket is getting created fine, but the autoreply, sh’e dead Jim.

— Gavin Adams
Promisant Ltd.
Bermuda


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

autoconf is your friend until it mysteriously stops working, at which
point it is a snarling wolverine attached to your genitals by its teeth
(that said, it’s better than most of the alternatives) – Nathan Mehl

That’ll teach me! :slight_smile: Backed down to 0.33, working again.

— Gavin Adams
Promisant Ltd.
Bermuda

-----Original Message-----
From: Jesse [mailto:jesse@fsck.com]
Sent: Friday, June 01, 2001 15:26
To: Adams, Gavin
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Error on autoReply

Ho-hum. Will be fixed in DBIx::SearchBuilder 0.38

Upgraded to the latest snapshot (1.3.83), and also the latest
DBIx:SearchBuilder.pm. AutoReply has stopped working. Here’s the
contents of the log file:

Debug mode enabled
Use of uninitialized value in pattern match (m//) at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder.pm line 893,

line 21.
DBD::Pg::st execute failed: ERROR: Attribute main.scripcondition
must

be GROUPed or used in an aggregate function
DBIx::SearchBuilder error:ERROR: Attribute main.scripcondition must
be

GROUPed or used in an aggregate function

    Query String is SELECT main.* FROM Scrips main,

ScripConditions

ScripConditions_1 WHERE ((ScripConditions_1.ApplicableTransTypes
LIKE

‘%Create%’) OR (ScripConditions_1.ApplicableTransTypes LIKE
’%Any%’))

AND ((main.Queue = ‘2’) OR (main.Queue = ‘0’)) AND
main.ScripCondition =

ScripConditions_1.id GROUP BY main.id
DBD::Pg::st fetchrow_hashref failed: no statement executing
Use of uninitialized value in delete at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record/Cachable.pm
line 136, line 21.
Ticket 27 created in queue ‘TechOps’

The ticket is getting created fine, but the autoreply, sh’e dead
Jim.

— Gavin Adams
Promisant Ltd.
Bermuda


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users


jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

autoconf is your friend until it mysteriously stops working, at which
point it is a snarling wolverine attached to your genitals by its
teeth
(that said, it’s better than most of the alternatives) – Nathan
Mehl