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.kugel...@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: sa...@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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
