[rt-users] Deleting RTFM with RT 3.6.0pre1 and RTFM 2.2.0RC1

[Dando - Email.it]

Phil Smith III wrote:
> Well, I still haven't gotten the graphing working, but it's a background task at this point.
> 
> Now I'm trying to delete a test RTFM ticket.  The Web UI says it worked, but it still shows up in all searches and in the Overview.
> 
> Nothing in any logs that I can see.
> 
> Is anyone else running this combination, can try it?
> 
> ...phsiii
> 

Hi, we have the same problem with different environments :

RT 3.6.0pre1, RTFM 2.2.0rc2, AT 1.2.3  installed from scratch

on POSTGRESQL 8.0.

and

RT 3.4.5, RTFM 2.2.0rc2, AT 1.2.3  installed from scratch

on POSTGRESQL 7.4.

The logs said:

==== /opt/rt3/var/log/rt3.log ====
....
....
DBD::Pg::st execute failed: ERROR:  column main.field does not exist
(/usr/local/share/perl/5.8.7/DBIx/SearchBuilder/Handle.pm:492)
[Tue May  2 14:30:40 2006] [warning]: RT::Handle=HASH(0x3021960) couldn't
execute the query 'SELECT main.* FROM Links main   WHERE ((main.Field =
'fsck.com-rtfm://example.it/article/15')) AND ((main.Type = 'Target')) ' at
/usr/local/share/perl/5.8.7/DBIx/SearchBuilder/Handle.pm line 505
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x3021960)', 'SELECT
main.* FROM Links main   WHERE ((main.Field = \'fsck.c...') called at
/usr/local/share/perl/5.8.7/DBIx/SearchBuilder.pm line 231
.....
.....
Tue May  2 14:30:40 2006] [warning]: DBD::Pg::st execute failed: ERROR:  current
transaction is aborted, commands ignored until end of transaction block
(/usr/local/share/perl/5.8.7/DBIx/SearchBuilder/Handle.pm:492)
[Tue May  2 14:30:40 2006] [warning]: RT::Handle=HASH(0x3021960) couldn't
execute the query 'SELECT main.* FROM Transactions main   WHERE ((main.ObjectId
= '15')) AND ((main.ObjectType = 'RT::FM::Article'))  ORDER BY main.Created ASC,
main.id ASC ' at /usr/local/share/perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
505       DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x3021960)',
'SELECT main.* FROM Transactions main   WHERE ((main.ObjectId ...') called at
/usr/local/share/perl/5.8.7/DBIx/SearchBuilder.pm line 231
......
......
====================================


==== /var/log/postgresql-main.log =====
........
........
ERROR:  column main.field does not exist
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
ERROR:  current transaction is aborted, commands ignored until end of
transaction block
.......
.......
========================================


Any clue ?

Regards

Dando