[rt-users] Add queue watcher problem

Ferdinand Hoffmann hoffmanf at junese.de
Thu Sep 4 09:27:18 EDT 2003


 Hi,

we've running rt-3.0.4 with mysql-3.23.52 and apache 1.3 (mod_perl1)
on a SuSE 8.1 box.
All tickets and users are imported from rt2 (with rt-2-to-3 v1.12).
If I try to add a watcher to a _new_ (not imported) queue i got
the error:
 group not found

the logfile contains then the following entries:

Sep  3 16:04:32 linuxnms RT: Adding a watcher 30 to AdminCc
Sep  3 16:04:32 linuxnms RT: 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:235)
Sep  3 16:04:32 linuxnms RT: DBIx::SearchBuilder error:You have an error in your SQL syntax near '))  ' at line 1 ^IQuery String is SELECT count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))    (/opt/rt3/lib/RT.pm:235)
Sep  3 16:04:32 linuxnms RT: 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:235)
Sep  3 16:04:32 linuxnms RT: 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:235)
Sep  3 16:04:32 linuxnms RT: DBIx::SearchBuilder error:You have an error in your SQL syntax near '))  ' at line 1 ^IQuery String is SELECT count(main.id) FROM GroupMembers main  WHERE ((main.GroupId = ))    (/opt/rt3/lib/RT.pm:235)
Sep  3 16:04:32 linuxnms RT: 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:235)

any ideas?

 regards,
  Ferdinand Hoffmann



More information about the rt-users mailing list