<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3199" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2></FONT> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>Hi there,</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>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:</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT
size=2><STRONG>/rt3/lib/RT/Queue_Overlay.pm {AddWatcher
subfunction}</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>
$group->LoadQueueRoleGroup(Type => $args{'Type'}, Queue =>
$self->Id);</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2> unless
($group->id) {<BR>
return(0,$self->loc("Group not found"));</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>The odd point is that I get
this error just for one queue and it works for the rest of queues.
</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>For the queue that does not
work, Type = AdminCc and Queue = 16</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>For a queue that work,
Type = AdminCc and Queue = 11</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>Both Queues are similar and
have the same permissions (By the way, Im adding the watcher as
root):</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>mysql> select * from Queues
where Id =
16;<BR>+----+-----------------+-------------+-------------------+----------------+-----------------+---------------+--------------+---------+---------------------+---------------+---------------------+----------+<BR>|
id | Name |
Description | CorrespondAddress | CommentAddress | InitialPriority |
FinalPriority | DefaultDueIn | Creator |
Created
| LastUpdatedBy | LastUpdated |
Disabled
|<BR>+----+-----------------+-------------+-------------------+----------------+-----------------+---------------+--------------+---------+---------------------+---------------+---------------------+----------+<BR>|
16 | ADE_Requests
|
|
|
|
50 | 0
| 0
| 1 | 2007-08-22 13:03:00
| 1 |
2007-08-22 13:03:00 | 0 |
<BR>+----+-----------------+-------------+-------------------+----------------+-----------------+---------------+--------------+---------+---------------------+---------------+---------------------+----------+<BR>1
row in set (0,00 sec)</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>mysql> select * from Queues
where Id =
11;<BR>+----+-----------------+-------------+-------------------+----------------+-----------------+---------------+--------------+---------+---------------------+---------------+---------------------+----------+<BR>|
id | Name |
Description | CorrespondAddress | CommentAddress | InitialPriority |
FinalPriority | DefaultDueIn | Creator |
Created
| LastUpdatedBy | LastUpdated |
Disabled
|<BR>+----+-----------------+-------------+-------------------+----------------+-----------------+---------------+--------------+---------+---------------------+---------------+---------------------+----------+<BR>|
11 | INT_Requests
|
|
|
|
50 | 0
| 0
| 1 | 2007-07-06 11:03:47
| 1 |
2007-07-06 11:03:47 | 0 |
<BR>+----+-----------------+-------------+-------------------+----------------+-----------------+---------------+--------------+---------+---------------------+---------------+---------------------+----------+<BR>1
row in set (0,00 sec)</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>Getting to the syslog I found
the following error:</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>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) <BR>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) <BR>Jan 30
12:33:25 evia RT: RT::Handle=HASH(0x949510c) couldn't execute the query
<BR>'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:</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT> </DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>Thanks in
advance,</FONT></SPAN></DIV>
<DIV><SPAN class=478130211-30012008><FONT size=2>Regards,</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV align=left><SPAN lang=FR
style="FONT-SIZE: 36pt; COLOR: green; FONT-FAMILY: Webdings; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: FR; mso-fareast-language: ES; mso-bidi-language: AR-SA"><FONT
face="Times New Roman" color=#004080 size=2>Alvaro Muñoz
Sánchez</FONT></SPAN></DIV>
<DIV align=left>
<DIV align=left><SPAN lang=FR
style="FONT-SIZE: 36pt; COLOR: green; FONT-FAMILY: Webdings; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: FR; mso-fareast-language: ES; mso-bidi-language: AR-SA"><FONT
color=#000000><A href="mailto:alvaro.munoz.sanchez@hp.com"><FONT
face="Times New Roman" size=2></FONT></A></FONT></SPAN></DIV><SPAN lang=FR
style="FONT-SIZE: 36pt; COLOR: green; FONT-FAMILY: Webdings; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: FR; mso-fareast-language: ES; mso-bidi-language: AR-SA"><FONT
size=2><FONT size=4>P</FONT> <FONT face="Times New Roman">Antes de imprimir
piensa en el medio ambiente</FONT></FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV></BODY></HTML>