[rt-users] Error on reply to ticket

[Jesse Vincent]

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.


	-j

On 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, <GEN17> 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, <G
> EN17> 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, <GEN20> 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, <G
> EN20> 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 at nextra.de
> ------------------------------------------------------------------------
> -
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

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