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:[EMAIL PROTECTED]>
P Antes de imprimir piensa en el medio ambiente
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
