[rt-users] EXTERNAL: Re: Group not found

Betz, Gregory gregory.betz at thesiorg.com
Wed Jul 25 10:28:48 EDT 2012 

Hey Paul,

Thanks for the quick response.

I use the root account when attempting to put watchers on the queues, so I don't think this is the issue

Thanks,
Greg

From: ptomblin at gmail.com [mailto:ptomblin at gmail.com] On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 10:25 AM
To: Betz, Gregory
Cc: rt-users at lists.bestpractical.com
Subject: EXTERNAL: Re: [rt-users] Group not found

I've seen this exact thing happen when the person trying to add the watchers didn't have permissions to the queues in question.  Rather than handling it properly, RT sticks a null queue name into the query, which the query doesn't like much.
On Wed, Jul 25, 2012 at 10:18 AM, Betz, Gregory <gregory.betz at thesiorg.com<mailto:gregory.betz at thesiorg.com>> wrote:
Hello all,

I am having issues trying to add watchers to most of my queues.  When I try to add a user or group I receive the error message "Group not found".

I can set watchers for 2 queues (one is the General queue) out of 9 total queues.

Also, I noticed that the 2 queues that I can set watchers has items under Roles in Group Rights while the queues that I cannot set the watchers does not.

The following error message is displayed in /var/log/httpd/error_log

======================================================================================================================================================

[Wed Jul 25 12:05:06 2012] [warning]: DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"

LINE 1: ...nt(main.id<http://main.id>) FROM GroupMembers main  WHERE (main.GroupId = )

                                                                     ^ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)





[Wed Jul 25 12:05:06 2012] [warning]: RT::Handle=HASH(0x7fbc4de27b10) couldn't execute the query 'SELECT count(main.id<http://main.id>) FROM GroupMembers main  WHERE (main.GroupId = ) ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.

        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fbc4de27b10)', 'SELECT count(main.id<http://main.id>) FROM GroupMembers main  WHERE (main.Gro...') called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 291

        DBIx::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 331

        RT::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1407

        DBIx::SearchBuilder::Count('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 48

        HTML::Mason::Commands::__ANON__('QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4febff68)', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /opt/rt4/local/html/Admin/Elements/EditQueueWatcherGroup line 55

        HTML::Mason::Commands::__ANON__('Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4febca88)', 'Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, 'Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /opt/rt4/local/html/Admin/Queues/People.html line 65

        HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'Queue-AddWatcher-Principal-30', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4feaff30)', 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 955

        HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)', 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'UserString', '', ...) called at /opt/rt4/local/html/Admin/autohandler line 49

        HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'Queue-AddWatcher-Principal-30', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4ea48560)', 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', ...) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548

        RT::Interface::Web::ShowRequestedPage('HASH(0x7fbc4feafc00)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295

        RT::Interface::Web::HandleRequest('HASH(0x7fbc4feafc00)') called at /opt/rt4/local/html/autohandler line 53

        HTML::Mason::Commands::__ANON__('UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', 'LIKE', 'GroupString', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4e16e7c0)', 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', 'LIKE', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, undef, 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 433

        HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)') called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

        eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

        HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)') called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 342

        HTML::Mason::Interp::exec(undef, undef, 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', ...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

        eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

        HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x7fbc4d42e258)', 'HTML::Mason::FakeApache=HASH(0x7fbc5000a380)', 'HASH(0x7fbc4fec58c0)') called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52

        HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7fbc50014e68)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255

        RT::Interface::Web::Handler::__ANON__('CODE(0x7fbc50014e68)') called at /usr/local/share/perl5/Plack/Util.pm line 324

        Plack::Util::__ANON__('CODE(0x7fbc4febe048)') called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 68

        Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 'Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)', 'CODE(0x7fbc4cd08338)') called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 91

        Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)') called at -e line 0

        eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:103)
 ======================================================================================================================================================

Any help would be greatly appreciated!

Thanks,
Greg




--
http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120725/d206332e/attachment.htm>

More information about the rt-users mailing list