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