[rt-users] Group not found

Paul Tomblin ptomblin at xcski.com
Wed Jul 25 10:24:32 EDT 2012


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>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) 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) 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) 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/dd9f193c/attachment.htm>


More information about the rt-users mailing list