Error on reply to ticket

RT Users
1

Hi,

my config:
RT2.0.8
Postgres7.1.3

RT2 ist working nice, but I have some problems witch sending a replay or
resolve email to the requester.
The auto-repay on create works without any problem.

here are a log (debug)

DBD::Pg::st execute failed: ERROR:  Attribute main.base must be

GROUPed or used in an aggregate function at /usr/local/lib/perl5/sit
e_perl/5.6.1/DBIx/SearchBuilder.pm line 227, line 160.
DBIx::SearchBuilder error:ERROR: Attribute main.base must be GROUPed or
used in an aggregate function
Query String is SELECT count(main.id) FROM Links main WHERE
((lower(main.Type) = ‘memberof’)) AND ((lower(main.Target) = ’
fsck.com-rt://nextra.de/nextra.de/ticket/103’)) ORDER BY main.Base ASC
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 240, line 160.
DBD::Pg::st execute failed: ERROR: Attribute main.base must be GROUPed
or used in an aggregate function at /usr/local/lib/perl5/sit
e_perl/5.6.1/DBIx/SearchBuilder.pm line 227, line 160.
DBIx::SearchBuilder error:ERROR: Attribute main.base must be GROUPed or
used in an aggregate function
Query String is SELECT count(main.id) FROM Links main WHERE
((lower(main.Type) = ‘memberof’)) AND ((lower(main.Target) = ’
fsck.com-rt://nextra.de/nextra.de/ticket/103’)) ORDER BY main.Base ASC
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 240, line 160.

any suggestion ?

regards,
alexander
Nextra Deutschland | Alexander Kunz
GmbH & Co. KG | Capacity Planning & Optimization
Region Mitte | Tel.: +49 (0)6151 88008-897
Birkenweg 14a | Fax: +49 (0)6151 88008-500
64295 Darmstadt | Mobil: +49 (0)175 9309601
http://www.nextra.de | E-Mail: alexander.kunz@nextra.de

2

In DBIx::SearchBuilder, sub _DoCount,

change

$QueryString .=  $self->_OrderClause . $self->_LimitClause;

to

$QueryString .=   $self->_LimitClause;

and restart apache and tell me how rt behaves with that.

-jOn Mon, Oct 08, 2001 at 06:15:20PM +0100, Alexander Kunz wrote:

Hi,

my config:
RT2.0.8
Postgres7.1.3

RT2 ist working nice, but I have some problems witch sending a replay or
resolve email to the requester.
The auto-repay on create works without any problem.

here are a log (debug)

DBD::Pg::st execute failed: ERROR:  Attribute main.base must be

GROUPed or used in an aggregate function at /usr/local/lib/perl5/sit
e_perl/5.6.1/DBIx/SearchBuilder.pm line 227, line 160.
DBIx::SearchBuilder error:ERROR: Attribute main.base must be GROUPed or
used in an aggregate function
Query String is SELECT count(main.id) FROM Links main WHERE
((lower(main.Type) = ‘memberof’)) AND ((lower(main.Target) = ’
fsck.com-rt://nextra.de/nextra.de/ticket/103’)) ORDER BY main.Base ASC
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 240, line 160.
DBD::Pg::st execute failed: ERROR: Attribute main.base must be GROUPed
or used in an aggregate function at /usr/local/lib/perl5/sit
e_perl/5.6.1/DBIx/SearchBuilder.pm line 227, line 160.
DBIx::SearchBuilder error:ERROR: Attribute main.base must be GROUPed or
used in an aggregate function
Query String is SELECT count(main.id) FROM Links main WHERE
((lower(main.Type) = ‘memberof’)) AND ((lower(main.Target) = ’
fsck.com-rt://nextra.de/nextra.de/ticket/103’)) ORDER BY main.Base ASC
DBD::Pg::st fetchrow_array failed: no statement executing at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 240, line 160.

any suggestion ?

regards,
alexander

Nextra Deutschland | Alexander Kunz
GmbH & Co. KG | Capacity Planning & Optimization
Region Mitte | Tel.: +49 (0)6151 88008-897
Birkenweg 14a | Fax: +49 (0)6151 88008-500
64295 Darmstadt | Mobil: +49 (0)175 9309601
http://www.nextra.de | E-Mail: alexander.kunz@nextra.de

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

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.