[rt-users] can't add watcher: group not found

[Ferdinand Hoffmann]

 hi all,

I can't add watchers (Cc's or AdminCc's) to a new queue.
I always get (after selecting the user) the error message: group not found

the other queues (all imported from rt2) are working as expected,
no problem while adding/deleting watchers.

the db-layout is a little bit extended (for ticket escalation):

ALTER TABLE Queues
  ADD DefaultResponseTime smallint(4) NOT NULL default '0',
  ADD WarnFromHour varchar(5) NOT NULL default '00:00',
  ADD WarnToHour varchar(5) NOT NULL default '00:00',
  ADD WarnBetweenDays smallint(1) NOT NULL default '0';

I use the attached Queue_Local.pm and a accordingly modified UI
(share/html/Admin/Queues/Modify.html).

the problem first appeared in rt 3.0.4 and the update to 3.0.5 couldn't solve it.

the according log entries:

[Fri Sep 12 12:17:13 2003] [debug]: Adding a watcher 30 to AdminCc
 (/opt/rt3/share/html/Admin/Queues/People.html:141)
[Fri Sep 12 12:17:13 2003] [warning]: DBD::mysql::st execute failed: You have an error in your SQL syntax near '))  ' at line 1 at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.
 (/opt/rt3/lib/RT.pm:247)
[Fri Sep 12 12:17:13 2003] [warning]: DBIx::SearchBuilder error:You have an error in your SQL syntax near '))  ' at line 1
        Query String is SELECT count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))
 (/opt/rt3/lib/RT.pm:247)
[Fri Sep 12 12:17:13 2003] [warning]: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 248.
 (/opt/rt3/lib/RT.pm:247)
[Fri Sep 12 12:17:13 2003] [warning]: DBD::mysql::st execute failed: You have an error in your SQL syntax near '))  ' at line 1 at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 234.
 (/opt/rt3/lib/RT.pm:247)
[Fri Sep 12 12:17:13 2003] [warning]: DBIx::SearchBuilder error:You have an error in your SQL syntax near '))  ' at line 1
        Query String is SELECT count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))
 (/opt/rt3/lib/RT.pm:247)
[Fri Sep 12 12:17:13 2003] [warning]: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 248.
 (/opt/rt3/lib/RT.pm:247)

 Regards,
  Ferdinand Hoffmann


just network services gmbh
kirchenstraße 17c-d
81675 münchen

tel +49 (0)89 167856-17
fax +49 (0)89 167856-75
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Queue_Local.pm
Type: application/octet-stream
Size: 2825 bytes
Desc: Queue_Local.pm
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030912/3c3da783/attachment.obj>