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
Queue_Local.pm (2.76 KB)