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: [email protected] [mailto:[email protected]] On Behalf Of Paul Tomblin Sent: Wednesday, July 25, 2012 10:25 AM To: Betz, Gregory Cc: [email protected] 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 <[email protected]<mailto:[email protected]>> 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
