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

[Jesse Vincent]

> Hi, we have the same problem with different environments :

What do you click on to cause that error to hit the database?


> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 
> 
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
> 

--