Rtir problems: Lookup, blocks

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I’m running RT3.4.1 and RTIR 1.1.5. At the moment I find two problems

    • I can’t get working Tools->Lookup. Lookup.html can’t find any ticket nor from incidents,
      investigations, reports or blocks queues. Logs indicates four warnings like:
      [Tue Mar 1 15:02:02 2005] [warning]: DBD::mysql::st execute failed: Table ‘rt3test._3’ doesn’t
      exist at /usr/local/lib/perl5/site_perl/5.8.2/DBIx/SearchBuilder/Handle.pm line 480.
      (/usr/local/rt-3.4.1/lib/RT.pm:277)
      [Tue Mar 1 15:02:02 2005] [warning]: RT::Handle=HASH(0x93a9fcc) couldn’t execute the query ‘SELECT
      DISTINCT main.* FROM (Tickets main JOIN _3 ON ( Attachments_2.TransactionId = _3.id)) ,
      Transactions Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.ObjectType =
      ‘RT::Ticket’)AND(Transactions_1.ObjectType = ‘RT::Ticket’)AND(Transactions_1.ObjectType =
      ‘RT::Ticket’)AND(Transactions_1.ObjectType = ‘RT::Ticket’)or(Transactions_1.ObjectType =
      ‘RT::Ticket’)) AND ((main.EffectiveId = main.id)) AND ((main.Status != ‘deleted’)) AND ((main.Type =
      ‘ticket’)) AND ( ( ( (Attachments_2.ContentType = ‘text/plain’)AND(Attachments_2.TransactionId =
      Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) OR ( (Attachments_2.ContentType =
      ‘text’)AND(Attachments_2.TransactionId = Transactions_1.id)AND(main.id = Transactions_1.ObjectId) )
      OR ( (Attachments_2.ContentType = ‘text/html’)AND(Attachments_2.TransactionId =
      Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) ) AND ( (Attachments_2.Content LIKE
      ’%1.2.3.4%’)AND(Attachments_2.TransactionId = Transactions_1.id)AND(main.id =
      Transactions_1.ObjectId) ) AND ( (Attachments_2.Created > ‘2004-12-31 15:02:02’)AND(main.id =
      Transactions_1.ObjectId) ) ) ’ at /usr/local/lib/perl5/site_perl/5.8.2/DBIx/SearchBuilder/Handle.pm
      line 494.
      (/usr/local/rt-3.4.1/lib/RT.pm:277)
    • After block creation I don’t have link ‘Activate’, just links ‘Reply’ and ‘Comment’. Should I
      configure block queue somehow in order to have appropriate functions?

Does anoyone else has similar problems?

Best regards


Marius

Marius Urkis
LITNET CERT
http://cert.litnet.lt
E-mail: marius@litnet.lt
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)

iD8DBQFCJIgBHS98nbdNAJwRAhYMAJ4/vzH+aeKckrcMpjWtbYM9ZM/5fACfeFjq
k2ixsC/R6FN25BxBkU4zV/A=
=IDQp
-----END PGP SIGNATURE-----