[rt-users] Error adding watcher to queue, bug?

[Munoz, Alvaro]

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 at hp.com>
P Antes de imprimir piensa en el medio ambiente

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080130/99c54e3e/attachment.htm>