[rt-users] Cannot comment on a ticket via email

[Binand Sethumadhavan]

Hi All,

Sorry for the long post.

We have a strange problem. One ticket allows comments to be recorded
via web, correspondence added via web and email, but comments are NOT
recorded via email. This happens with only ticket no. 11273 (is that
some sort of magic number? :)

When I send a mail to the comment email address, I get a message back,
saying, in subject, "Comment not recorded" and in body, "The comment
has been recorded". :-)

I am at my wit's end. RT is 2.0.15, RHDB 2.1 (Postgres 7.2.3). I
had done a vacuum analyse just before, and an index corrpution for
pg_statistic_relid_att_index had occured (which I think is a known
bug in Postgres' vacuumdb, considering the number of google hits I got).
I had to drop and recreate that particular index.

This is logged in rt.log8 (for every comment mail to that ticket):

[Fri May  9 10:44:01 2003] [warning]: RT::User=HASH(0x88254a0)->HasQueueRight
Couldn't find a queue id at /home/rt2/igmg/lib/
RT/User.pm line 715

RT::User::HasQueueRight('RT::User=HASH(0x88254a0)', 'Right',
'ShowTicket', 'TicketObj', 'RT::Ticket=HASH(0x88a22ac)') called at
/home/rt2/igmg/lib/RT/CurrentUser.pm line 238

RT::CurrentUser::HasQueueRight('RT::CurrentUser=HASH(0x87ed1dc)',
'Right', 'ShowTicket', 'TicketObj', 'RT::Ticket=HASH(0x88a22ac)')
called at /home/rt2/igmg/lib/RT/Transaction.pm line 777

RT::Transaction::CurrentUserHasRight('RT::Transaction=HASH(0x88211ec)',
'ShowTicket') called at /home/rt2/igmg/lib/RT/Transaction.pm line 754

RT::Transaction::_Value('RT::Transaction=HASH(0x88211ec)', 'Field')
called at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Record.pm
line 404

DBIx::SearchBuilder::Record::__ANON__('RT::Transaction=HASH(0x88211ec)')
called at /home/rt2/igmg/lib/RT/Condition/OwnerChange.pm line 21

RT::Condition::OwnerChange::IsApplicable('RT::Condition::OwnerChange=HASH(0x88ae8b0)')
called at /home/rt2/igmg/lib/RT/ScripCondition.pm line 175

RT::ScripCondition::IsApplicable('RT::ScripCondition=HASH(0x88caf4c)')
called at /home/rt2/igmg/lib/RT/Scrip.pm line 275

RT::Scrip::IsApplicable('RT::Scrip=HASH(0x882a24c)') called at
/home/rt2/igmg/lib/RT/Transaction.pm line 159 eval {...} called at
/home/rt2/igmg/lib/RT/Transaction.pm line 146

RT::Transaction::Create('RT::Transaction=HASH(0x8815174)', 'Ticket',
11273, 'TimeTaken', 0, 'Type', 'Comment', 'Data', ...) called at
/home/rt2/igmg/lib/RT/Ticket.pm line 2773

RT::Ticket::_NewTransaction('RT::Ticket=HASH(0x88052a8)', 'Type',
'Comment', 'Data', 'RE: [xxxxxxxxxxxx.com #11273] [Comment] FW: Launch
of Project Pr...', 'TimeTaken', 0, 'MIMEObj', ...) called at
/home/rt2/igmg/lib/RT/Ticket.pm line 1689

RT::Ticket::Comment('RT::Ticket=HASH(0x88052a8)', 'MIMEObj',
'MIME::Entity=HASH(0x87fbe64)') called at /etc/smrsh/rt-mailgate line
294

Binand