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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
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
