[rt-users] Report "Resolved by owner" fails to output, generates error in log

[Ruslan Zakirov]

I believe this issue has been fixed in 3.8.HEAD, please test first RC
when it will be available.

On Mon, Apr 13, 2009 at 8:25 PM, Charles Kugelman
<Charles.Kugelman at kaplan.com> wrote:
> All,
>
>
>
> It’s been pointed out that the “Resolved by owner” report isn’t outputting
> results. I looked in the RT error log and found the entries below. Thoughts?
>
>
>
> ---Relevant Info---
>
> - RT Version: 3.8.2
>
> - HTTPD Package (RPM): httpd-2.2.3-22.el5
>
> - Mod_Perl Package (RPM): mod_perl-2.0.4-6.el5
>
> - Perl Package (RPM): perl-5.8.8-18.el5
>
> - OS: RedHat Enterprise Linux 5
>
> - Oracle Client: 10.2, Instant Client
>
> - Oracle Server (remote server): 11g
>
> - Mail Package (RPM): postfix-2.3.3-2
>
>
>
> ---Errors---
>
> [Mon Apr 13 16:08:14 2009] [warning]: DBD::Oracle::db prepare failed:
> ORA-00979: not a GROUP BY expression (DBD ERROR: error possibly near <*>
> indicator at char 29 in 'SELECT COUNT(main.id) AS id, <*>Users_2.Name AS
> col1 FROM Tickets main LEFT JOIN Users Users_2  ON ( Users_2.id = main.Owner
> ) LEFT JOIN Users Users_1  ON ( Users_1.id = main.Owner )  WHERE
> (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue =
> '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP BY
> Users_1.Name ') [for Statement "SELECT COUNT(main.id) AS id, Users_2.Name AS
> col1 FROM Tickets main LEFT JOIN Users Users_2  ON ( Users_2.id = main.Owner
> ) LEFT JOIN Users Users_1  ON ( Users_1.id = main.Owner )  WHERE
> (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue =
> '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP BY
> Users_1.Name "] at
> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 465,
> <GEN79> line 130.
> (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:465)
>
>
>
> [Mon Apr 13 16:08:14 2009] [warning]: RT::Handle=HASH(0x2b9ff6d2c540)
> couldn't prepare the query 'SELECT COUNT(main.id) AS id, Users_2.Name AS
> col1 FROM Tickets main LEFT JOIN Users Users_2  ON ( Users_2.id = main.Owner
> ) LEFT JOIN Users Users_1  ON ( Users_1.id = main.Owner )  WHERE
> (main.Status != 'deleted') AND (main.Status = 'resolved' AND main.Queue =
> '5') AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP BY
> Users_1.Name 'ORA-00979: not a GROUP BY expression (DBD ERROR: error
> possibly near <*> indicator at char 29 in 'SELECT COUNT(main.id) AS id,
> <*>Users_2.Name AS col1 FROM Tickets main LEFT JOIN Users Users_2  ON (
> Users_2.id = main.Owner ) LEFT JOIN Users Users_1  ON ( Users_1.id =
> main.Owner )  WHERE (main.Status != 'deleted') AND (main.Status = 'resolved'
> AND main.Queue = '5') AND (main.Type = 'ticket') AND (main.EffectiveId =
> main.id)  GROUP BY Users_1.Name ')
> (/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:472)
>
>
>
> Thanks,
>
>
>
> -CK
>
>
>
> _______________________________________________
> 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
>



-- 
Best regards, Ruslan.