[rt-users] EXTERNAL: Re: Group not found
Betz, Gregory
gregory.betz at thesiorg.com
Wed Jul 25 13:13:03 EDT 2012
Also, I noticed the following message after the aforementioned warning message in the log.
Use of uninitialized value in numeric eq (==) at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 3. (/opt/rt4/local/html/Admin/Elements/EditQueueWatchers:3)
Thanks,
Greg
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Betz, Gregory
Sent: Wednesday, July 25, 2012 10:29 AM
To: Paul Tomblin
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] EXTERNAL: Re: Group not found
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> [mailto:ptomblin at gmail.com]<mailto:[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<mailto: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/62bb9cb3/attachment.htm>
More information about the rt-users
mailing list