[rt-users] Ticket Errors

Mathew theillien at yahoo.com
Thu Feb 8 09:24:03 EST 2007 

Am I correct in assuming that all the txn and u and such are just
abbreviations and need to be replaced with Users and Transactions in the
actual query?

Mathew

Ruslan Zakirov wrote:
> Please, run the following SQL query:
> SELECT u.Name, txn.Field, txn.ReferenceType, txn.NewReference, t.id
> tid FROM Tickets t JOIN Transactions txn ON txn.Type = 'AddWatcher'
> AND txn.ObjectType = 'RT::Ticket' AND txn.ObjectId = t.id LEFT JOIN
> Users u ON u.id = txn.NewValue WHERE t.id = XXXXX;
> 
> Where XXXX id of the ticket. Then send me results.
> 
> 
> On 2/7/07, Mathew Snyder <theillien at yahoo.com> wrote:
>> I'd like to add to this.  I've looked at the database and found that
>> there are
>> 63 transactions attached to this ticket.  There are also no
>> transactions for
>> which there isn't a user.  I've looked up the names on each user id in
>> the
>> transactions table and found that they correspond to someone that
>> would likely
>> have had a part in the ticket.
>>
>> There are as many user id entries as there are transactions.  What I
>> mean is,
>> there are multiple entries for some ids but all transactions have a
>> user id
>> attached to it.  This tells me that the transactions aren't corrupted
>> by a
>> missing user that possibly got Shredded out of the database.
>>
>> As I've said before, this isn't the first time we've seen this so I'm
>> beginning
>> to think this is a bug of some sort.
>>
>> The full error follows.
>>
>> error:          Can't call method "Name" on an undefined value at
>> /usr/local/rt-3.6.1//lib/RT/Transaction_Overlay.pm line 690.
>> context:
>> ...
>> 686:    AddWatcher => sub {
>> 687:    my $self = shift;
>> 688:    my $principal = RT::Principal->new($self->CurrentUser);
>> 689:    $principal->Load($self->NewValue);
>> 690:    return $self->loc( "[_1] [_2] added", $self->Field,
>> $principal->Object->Name);
>> 691:    },
>> 692:    DelWatcher => sub {
>> 693:    my $self = shift;
>> 694:    my $principal = RT::Principal->new($self->CurrentUser);
>> ...
>> code stack:     /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm:690
>> /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm:602
>> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction:54
>> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowHistory:102
>> /usr/local/rt-3.6.1/share/html/Ticket/Display.html:63
>> /usr/local/rt-3.6.1/share/html/autohandler:279
>>
>>
>>
>> raw error
>> Can't call method "Name" on an undefined value at
>> /usr/local/rt-3.6.1//lib/RT/Transaction_Overlay.pm line 690.
>>
>>
>> Trace begun at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Exceptions.pm line 129
>> HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "Name"
>> on an
>> undefined value at /usr/local/rt-3.6.1//lib/RT/Transaction_Overlay.pm
>> line
>> 690.^J') called at /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm
>> line 690
>> RT::Transaction::__ANON__('RT::Transaction=HASH(0xc706568)') called at
>> /usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 602
>> RT::Transaction::BriefDescription('RT::Transaction=HASH(0xc706568)')
>> called at
>> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction line 54
>> HTML::Mason::Commands::__ANON__('Attachments',
>> 'RT::Attachments=HASH(0xc99b5f0)', 'Ticket',
>> 'RT::Ticket=HASH(0xc54ce28)',
>> 'AttachmentContent', 'RT::Attachments=HASH(0xc98d840)', 'ShowHeaders',
>> undef,
>> 'Collapsed', undef, 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
>> 'UpdatePath', '/Ticket/Update.html', 'Ticket',
>> 'RT::Ticket=HASH(0xc54ce28)',
>> 'Transaction', 'RT::Transaction=HASH(0xc706568)', 'ShowHeaders', undef,
>> 'Collapsed', undef, 'RowNum', 23, 'ShowTitleBarCommands', 1,
>> 'Attachments',
>> 'ARRAY(0xc59f11c)', 'AttachmentContent', 'HASH(0xc6a31d4)',
>> 'LastTransaction',
>> 0) called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm
>> line 135
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbf6c9a0)',
>>
>> 'Attachments', 'RT::Attachments=HASH(0xc99b5f0)', 'Ticket',
>> 'RT::Ticket=HASH(0xc54ce28)', 'AttachmentContent',
>> 'RT::Attachments=HASH(0xc98d840)', 'ShowHeaders', undef, 'Collapsed',
>> undef,
>> 'Tickets', undef, 'AttachPath', '/Ticket/Attachment', 'UpdatePath',
>> '/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xc54ce28)',
>> 'Transaction',
>> 'RT::Transaction=HASH(0xc706568)', 'ShowHeaders', undef, 'Collapsed',
>> undef,
>> 'RowNum', 23, 'ShowTitleBarCommands', 1, 'Attachments',
>> 'ARRAY(0xc59f11c)',
>> 'AttachmentContent', 'HASH(0xc6a31d4)', 'LastTransaction', 0) called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 1245
>> HTML::Mason::Request::comp(undef, undef, 'Attachments',
>> 'RT::Attachments=HASH(0xc99b5f0)', 'Ticket',
>> 'RT::Ticket=HASH(0xc54ce28)',
>> 'AttachmentContent', 'RT::Attachments=HASH(0xc98d840)', 'ShowHeaders',
>> undef,
>> 'Collapsed', undef, 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
>> 'UpdatePath', '/Ticket/Update.html', 'Ticket',
>> 'RT::Ticket=HASH(0xc54ce28)',
>> 'Transaction', 'RT::Transaction=HASH(0xc706568)', 'ShowHeaders', undef,
>> 'Collapsed', undef, 'RowNum', 23, 'ShowTitleBarCommands', 1,
>> 'Attachments',
>> 'ARRAY(0xc59f11c)', 'AttachmentContent', 'HASH(0xc6a31d4)',
>> 'LastTransaction',
>> 0) called at
>> /usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowHistory line 102
>> HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0xc54ce28)',
>> 'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef,
>> 'Attachments',
>> 'RT::Attachments=HASH(0xc99b5f0)', 'AttachmentContent',
>> 'RT::Attachments=HASH(0xc98d840)') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbf63114)',
>>
>> 'Ticket', 'RT::Ticket=HASH(0xc54ce28)', 'Tickets', undef, 'Collapsed',
>> undef,
>> 'ShowHeaders', undef, 'Attachments', 'RT::Attachments=HASH(0xc99b5f0)',
>> 'AttachmentContent', 'RT::Attachments=HASH(0xc98d840)') called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 1245
>> HTML::Mason::Request::comp(undef, undef, 'Ticket',
>> 'RT::Ticket=HASH(0xc54ce28)',
>> 'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef,
>> 'Attachments',
>> 'RT::Attachments=HASH(0xc99b5f0)', 'AttachmentContent',
>> 'RT::Attachments=HASH(0xc98d840)') called at
>> /usr/local/rt-3.6.1/share/html/Ticket/Display.html line 63
>> HTML::Mason::Commands::__ANON__('id', 55767, 'id', 55767) called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbbdd85c)',
>>
>> 'id', 55767, 'id', 55767) called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251
>> eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 1245
>> HTML::Mason::Request::comp(undef, undef, 'id', 55767, 'id', 55767)
>> called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 914
>> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xc99be60)',
>>
>> 'id', 55767) called at /usr/local/rt-3.6.1/share/html/autohandler line
>> 279
>> HTML::Mason::Commands::__ANON__('id', 55767) called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135
>> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbb4ad10)',
>>
>> 'id', 55767) called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 1246
>> eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 1245
>> HTML::Mason::Request::comp(undef, undef, undef, 'id', 55767) called at
>> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459
>> eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 459
>> eval {...} at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm
>> line 411
>> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xc99be60)')
>>
>> called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm
>> line 168
>> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xc99be60)')
>>
>> called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm
>> line 826
>> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xb0c1e5c)',
>>
>> 'Apache2::RequestRec=SCALAR(0xc98d78c)') called at
>> /usr/local/rt-3.6.1/bin/webmux.pl line 123
>> eval {...} at /usr/local/rt-3.6.1/bin/webmux.pl line 123
>> RT::Mason::handler('Apache2::RequestRec=SCALAR(0xc98d78c)') called at
>> -e line 0
>> eval {...} at -e line 0
>>
>> If we don't protect the freedom of speech, how will we know who the
>> assholes are?
>> http://theillien.blogspot.com
>>
>>
>> Mathew Snyder wrote:
>> > I think I've asked about this before and I'm fairly certain I
>> already know the
>> > answer.  However, I'm not certain it should be happening.
>> >
>> > We keep getting the error "Can't call method "Name" on an undefined
>> value..."
>> > If I recall correctly this is a result of eliminating via Shredder a
>> user which
>> > was at one point attatched to a ticket.  The only problem with this
>> is that the
>> > only users I remove are those that are created when we receive spam.
>> >
>> > So is this the only explanation?  More and more of these tickets
>> keep appearing
>> > but I can't figure out how all of these users are disappearing.
>> >
>> > Thanks
>> > Mathew
>> > _______________________________________________
>> > 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
>> >
>> _______________________________________________
>> 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
>>
> 
>

More information about the rt-users mailing list