Hi there,
Im getting an odd error while trying to add a watcher to a queue. When adding a new AdminCc to a queue I get a “Group not found” error that comes from:
/rt3/lib/RT/Queue_Overlay.pm {AddWatcher subfunction}
$group->LoadQueueRoleGroup(Type => $args{‘Type’}, Queue => $self->Id);
unless ($group->id) {
return(0,$self->loc(“Group not found”));
The odd point is that I get this error just for one queue and it works for the rest of queues.
For the queue that does not work, Type = AdminCc and Queue = 16
For a queue that work, Type = AdminCc and Queue = 11
Both Queues are similar and have the same permissions (By the way, Im adding the watcher as root):
mysql> select * from Queues where Id = 16;
| id | Name | Description | CorrespondAddress | CommentAddress | InitialPriority | FinalPriority | DefaultDueIn | Creator | Created | LastUpdatedBy | LastUpdated | Disabled |
| 16 | ADE_Requests | | | | 50 | 0 | 0 | 1 | 2007-08-22 13:03:00 | 1 | 2007-08-22 13:03:00 | 0 |
1 row in set (0,00 sec)
mysql> select * from Queues where Id = 11;
| id | Name | Description | CorrespondAddress | CommentAddress | InitialPriority | FinalPriority | DefaultDueIn | Creator | Created | LastUpdatedBy | LastUpdated | Disabled |
| 11 | INT_Requests | | | | 50 | 0 | 0 | 1 | 2007-07-06 11:03:47 | 1 | 2007-07-06 11:03:47 | 0 |
1 row in set (0,00 sec)
Getting to the syslog I found the following error:
Jan 30 12:33:24 evia RT: Use of uninitialized value in join or string at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 1015. (/usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm:1015)
Jan 30 12:33:24 evia RT: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1 at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
Jan 30 12:33:25 evia RT: RT::Handle=HASH(0x949510c) couldn’t execute the query
'SELECT count(main.id) FROM GroupMembers main WHERE (main.GroupId = ) ’ at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 ^IDBIx::SearchBuilder::Handle::SimpleQuery() called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 294 ^IDBIx::SearchBuilder::_DoCount() called at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder.pm line 1379 ^IDBIx::SearchBuilder::Count() called at /usr/local/rtir/rt3/share/html/Admin/Elements/EditQueueWatchers line 46 ^IHTML::Mason::Commands::ANON() called at /usr/share/perl5/HTML/Mason/Component.pm line 135 ^IHTML::Mason::Component::run() called at /usr/share/perl5/HTML/Mason/Request.pm line 1256 ^Ieval {…} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246 ^IHTML::Mason::Request::comp() called at /usr/local/rtir/rt3/share/html/Admin/Queues/People.html line 71 ^IHTML::Mason::Commands::ANON() called at /usr/share/perl5/HTML/Mason/Component.pm line 135 ^IHTML::Mason:
Thanks in advance,
Regards,
Alvaro Muñoz Sánchez
mailto:alvaro.munoz.sanchez@hp.com
P Antes de imprimir piensa en el medio ambiente