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

[Dando - Email.it]

Jesse Vincent wrote:
> 
> 
>>Hi, we have the same problem with different environments :
> 
> 
> What do you click on to cause that error to hit the database?
> 

We follow the same steps as Phil Smith III:

"..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..."

Shortly:

Create a Test Class | Create a Test Article | Overview | Click Test Article |
Click Delete | "Are you sure.." YES |  WebUI message "Article #17 deleted" |
Overview | Test Article still here unchanged.

Tried with an already existing RTFM 2.04 upgrade to 2.2rc2 and with a clean RTFM
2.2rc2 install, same thing.

Thanks

Dando

> 
> 
>>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