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

Paul Tomblin ptomblin at xcski.com
Wed Jul 25 13:18:52 EDT 2012 

That's just a consequence of the other error:
%if ($Members->Count == 0 ) {

$Members->Count returns an undef because of the error, which leads to the
second error.

On Wed, Jul 25, 2012 at 1:13 PM, Betz, Gregory <gregory.betz at thesiorg.com>wrote:

>  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] *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>
> 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****
>



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

More information about the rt-users mailing list