Ticket Errors

Mathew_Snyder2 · February 7, 2007, 7:30am

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

Mathew_Snyder2 · February 7, 2007, 8:00am

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:

Ruslan_Zakirov · February 8, 2007, 1:49pm

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Mathew_Snyder2 · February 8, 2007, 2:19pm

Ruslan,

I will do this as soon as I get to work tonight.

Mathew

Ruslan Zakirov wrote:

Mathew_Snyder2 · February 8, 2007, 2:24pm

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:

Ruslan_Zakirov · February 8, 2007, 2:31pm

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?
Yes, it’s aliases, but you shouldn’t replace anything except XXXX as
it’s SQL’s feature. Look into the FROM part, for example “Tickets t”,
long variant is “Tickets AS t”.

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.

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Mathew_Snyder2 · February 9, 2007, 2:59am

This query has me confused. There are lowercase letters placed by themselves in
locations I’m not used to seeing criteria placed. Can someone please clarify
what I’m supposed to enter?

Mathew

Ruslan Zakirov wrote:

Ruslan_Zakirov · February 9, 2007, 3:41am

I’m just trying to help you figure out what had happened with your
tickets and as well gather debug info to fix shredder.

To get debug infon you have to run the following query from mysql or
Pg shell, but first of all you should find a ticket that generate that
error you posted and replace XXXXX with the ticket’s ID.

SELECT u.Name, txn.Field, txn.NewValue, 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;

This query selects all AddWatcher transactions from the ticket and
shows if user that’s been added as watcher still exist in the DB.On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

This query has me confused. There are lowercase letters placed by themselves in
locations I’m not used to seeing criteria placed. Can someone please clarify
what I’m supposed to enter?

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Mathew_Snyder2 · February 9, 2007, 3:43am

I know. I just didn’t understand the SQL syntax.

Mathew

Ruslan Zakirov wrote:

Ruslan_Zakirov · February 9, 2007, 4:02am

I know. I just didn’t understand the SQL syntax.
And? Should I describe it? I don’t think so. Google for ‘Learning SQL’.

Mathew

Ruslan Zakirov wrote:

I’m just trying to help you figure out what had happened with your
tickets and as well gather debug info to fix shredder.

To get debug infon you have to run the following query from mysql or
Pg shell, but first of all you should find a ticket that generate that
error you posted and replace XXXXX with the ticket’s ID.

SELECT u.Name, txn.Field, txn.NewValue, 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;

This query selects all AddWatcher transactions from the ticket and
shows if user that’s been added as watcher still exist in the DB.

This query has me confused. There are lowercase letters placed by
themselves in
locations I’m not used to seeing criteria placed. Can someone please
clarify
what I’m supposed to enter?

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.

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Mathew_Snyder2 · February 9, 2007, 4:07am

There’s no need for hostilities.

Mathew

Ruslan Zakirov wrote:> On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

I know. I just didn’t understand the SQL syntax.
And? Should I describe it? I don’t think so. Google for ‘Learning SQL’.

Mathew

Ruslan Zakirov wrote:

I’m just trying to help you figure out what had happened with your
tickets and as well gather debug info to fix shredder.

To get debug infon you have to run the following query from mysql or
Pg shell, but first of all you should find a ticket that generate that
error you posted and replace XXXXX with the ticket’s ID.

SELECT u.Name, txn.Field, txn.NewValue, 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;

This query selects all AddWatcher transactions from the ticket and
shows if user that’s been added as watcher still exist in the DB.

On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

This query has me confused. There are lowercase letters placed by
themselves in
locations I’m not used to seeing criteria placed. Can someone please
clarify
what I’m supposed to enter?

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.
Buy a copy at http://rtbook.bestpractical.com

Mathew_Snyder2 · February 9, 2007, 4:19am

It would appear I removed someone that was added as a CC:

Is it possible to correct this?

Ruslan Zakirov wrote:

der_Mouse · February 9, 2007, 4:30am

[top-posting damage repaired manually -dM]

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;
This query has me confused. There are lowercase letters placed by
themselves in locations I’m not used to seeing criteria placed.
I’m jsut trying to help you figure out […]
I know. I just didn’t understand the SQL syntax.

Then it would help to say what lowercase letters are puzzling you;
there are lots of lowercase letters in that query, and without knowing
which ones have you baffled, we’re left guessing.

I’m going to guess that the ones that are baffling you are the alias
names, like “t” in “Tickets t” and “txn” in “Transactions txn” or “u”
in “Users u”. These are an alternative syntax for what you may know as
“Tickets AS t” or “Transaction AS txn” or “Users AS u”: providing an
alternative name for referring to something elsewhere in the query (in
this case presumably for brevity, but there are cases, such as using
the same table multiple times, where this is actually necessary).

/~\ The ASCII der Mouse
\ / Ribbon Campaign
X Against HTML mouse@rodents.montreal.qc.ca
/ \ Email! 7D C8 61 52 5D E7 2D 39 4E F1 31 3E E8 B3 27 4B

Ruslan_Zakirov · February 9, 2007, 5:52am

It would appear I removed someone that was added as a CC:

±-------±----------±--------------±-------------±------+
| Name | Field | ReferenceType | NewReference | tid |
±-------±----------±--------------±-------------±------+
| NULL | Cc | NULL | NULL | 55767 |
| rbates | Requestor | NULL | NULL | 55767 |
±-------±----------±--------------±-------------±------+

Is it possible to correct this?
Yes, sure.
This means that you’ve deleted a user who was added as Cc watcher to
ticket 55767. As well this means a bug exists in shredder and I’ve
fixed it and released shredder 0.05.

The following query is more informative:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL AND t.id = XXXXX;

This query selects only transactions with problems. txn_id column in
the result will show you problematic Transactions and NewValue column
will show you ids of the users that don’t exist anymore.

You can safely delete this transactions using the following query:
DELETE FROM Transactions WHERE id IN (xxx, xxx, xxx,…);

Also, you can select all such transactions from your DB:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL;

If amount of the transactions is too big then I could help you write
down a delete query that will delete all this txns.

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.

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Ruslan_Zakirov · February 9, 2007, 6:00am

I’m terribly sorry bu here is more correct queries:

SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
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 Principals p ON p.id =
txn.NewValue WHERE p.id IS NULL AND t.id = XXX;

and

SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
txn.ReferenceType, txn.NewReference, txn.ObjectId tid FROM
Transactions txn LEFT JOIN Principals p ON p.id = txn.NewValue WHERE
txn.Type = ‘AddWatcher’ AND txn.ObjectType = ‘RT::Ticket’ AND p.id IS
NULL;On 2/9/07, Ruslan Zakirov ruslan.zakirov@gmail.com wrote:

On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

It would appear I removed someone that was added as a CC:

±-------±----------±--------------±-------------±------+
| Name | Field | ReferenceType | NewReference | tid |
±-------±----------±--------------±-------------±------+
| NULL | Cc | NULL | NULL | 55767 |
| rbates | Requestor | NULL | NULL | 55767 |
±-------±----------±--------------±-------------±------+

Is it possible to correct this?
Yes, sure.
This means that you’ve deleted a user who was added as Cc watcher to
ticket 55767. As well this means a bug exists in shredder and I’ve
fixed it and released shredder 0.05.

The following query is more informative:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL AND t.id = XXXXX;

This query selects only transactions with problems. txn_id column in
the result will show you problematic Transactions and NewValue column
will show you ids of the users that don’t exist anymore.

You can safely delete this transactions using the following query:
DELETE FROM Transactions WHERE id IN (xxx, xxx, xxx,…);

Also, you can select all such transactions from your DB:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL;

If amount of the transactions is too big then I could help you write
down a delete query that will delete all this txns.

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

Best regards, Ruslan.

Mathew_Snyder2 · February 9, 2007, 6:11am

The results of each query are attached as .txt files.

Ruslan Zakirov wrote:

first.txt (839 Bytes)

second.txt (11.6 KB)

Ruslan_Zakirov · February 9, 2007, 6:35am

Ok, I’ve got all info I needed. Thanks.

Now you can delete these transactions and get rid of those errors.

If you’re using mysql 4.1 and greater then you can use the following queries:
DELETE txn FROM Transactions txn LEFT JOIN Principals p ON (
txn.NewValue = p.id ) WHERE txn.Type = ‘AddWatcher’ AND p.id IS NULL;
DELETE txn FROM Transactions txn LEFT JOIN Principals p ON (
txn.OldValue = p.id ) WHERE txn.Type = ‘DelWatcher’ AND p.id IS NULL;On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

The results of each query are attached as .txt files.

Ruslan Zakirov wrote:

I’m terribly sorry bu here is more correct queries:

SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
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 Principals p ON p.id =
txn.NewValue WHERE p.id IS NULL AND t.id = XXX;

and

SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
txn.ReferenceType, txn.NewReference, txn.ObjectId tid FROM
Transactions txn LEFT JOIN Principals p ON p.id = txn.NewValue WHERE
txn.Type = ‘AddWatcher’ AND txn.ObjectType = ‘RT::Ticket’ AND p.id IS
NULL;

On 2/9/07, Ruslan Zakirov ruslan.zakirov@gmail.com wrote:

On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

It would appear I removed someone that was added as a CC:

±-------±----------±--------------±-------------±------+
| Name | Field | ReferenceType | NewReference | tid |
±-------±----------±--------------±-------------±------+
| NULL | Cc | NULL | NULL | 55767 |
| rbates | Requestor | NULL | NULL | 55767 |
±-------±----------±--------------±-------------±------+

Is it possible to correct this?
Yes, sure.
This means that you’ve deleted a user who was added as Cc watcher to
ticket 55767. As well this means a bug exists in shredder and I’ve
fixed it and released shredder 0.05.

The following query is more informative:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL AND t.id = XXXXX;

This query selects only transactions with problems. txn_id column in
the result will show you problematic Transactions and NewValue column
will show you ids of the users that don’t exist anymore.

You can safely delete this transactions using the following query:
DELETE FROM Transactions WHERE id IN (xxx, xxx, xxx,…);

Also, you can select all such transactions from your DB:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL;

If amount of the transactions is too big then I could help you write
down a delete query that will delete all this txns.

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

mysql> SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
→ 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 Principals p ON p.id =
→ txn.NewValue WHERE p.id IS NULL AND t.id = 55767;
±-----±--------------±-------±------±---------±--------------±-------------±------+
| id | PrincipalType | txn_id | Field | NewValue | ReferenceType | NewReference | tid |
±-----±--------------±-------±------±---------±--------------±-------------±------+
| NULL | NULL | 377862 | Cc | 3368 | NULL | NULL | 55767 |
±-----±--------------±-------±------±---------±--------------±-------------±------+
1 row in set (0.00 sec)
mysql> SELECT p.id, p.PrincipalType, txn.id txn_id, txn.Field, txn.NewValue,
→ txn.ReferenceType, txn.NewReference, txn.ObjectId tid FROM
→ Transactions txn LEFT JOIN Principals p ON p.id = txn.NewValue WHERE
→ txn.Type = ‘AddWatcher’ AND txn.ObjectType = ‘RT::Ticket’ AND p.id IS
→ NULL;
±-----±--------------±-------±----------±---------±--------------±-------------±------+
| id | PrincipalType | txn_id | Field | NewValue | ReferenceType | NewReference | tid |
±-----±--------------±-------±----------±---------±--------------±-------------±------+
| NULL | NULL | 195 | Cc | 270 | NULL | NULL | 15015 |
| NULL | NULL | 2596 | Requestor | 2112 | NULL | NULL | 15305 |
| NULL | NULL | 2273 | Requestor | 1872 | NULL | NULL | 15387 |
| NULL | NULL | 2274 | Requestor | 1874 | NULL | NULL | 15387 |
| NULL | NULL | 4231 | Cc | 60 | NULL | NULL | 15671 |
| NULL | NULL | 4666 | Cc | 60 | NULL | NULL | 15728 |
| NULL | NULL | 4810 | AdminCc | 2112 | NULL | NULL | 15745 |
| NULL | NULL | 6023 | Cc | 60 | NULL | NULL | 15913 |
| NULL | NULL | 6174 | Requestor | 180 | NULL | NULL | 15936 |
| NULL | NULL | 6369 | Cc | 2670 | NULL | NULL | 15958 |
| NULL | NULL | 6586 | Requestor | 4756 | NULL | NULL | 15994 |
| NULL | NULL | 6589 | Requestor | 2670 | NULL | NULL | 15994 |
| NULL | NULL | 6590 | Requestor | 4758 | NULL | NULL | 15994 |
| NULL | NULL | 8229 | Requestor | 3980 | NULL | NULL | 16195 |
| NULL | NULL | 8470 | Cc | 5870 | NULL | NULL | 16235 |
| NULL | NULL | 10810 | Requestor | 7490 | NULL | NULL | 16572 |
| NULL | NULL | 12068 | Cc | 7706 | NULL | NULL | 16770 |
| NULL | NULL | 13686 | Cc | 60 | NULL | NULL | 17039 |
| NULL | NULL | 15175 | AdminCc | 3368 | NULL | NULL | 17299 |
| NULL | NULL | 19283 | Requestor | 2508 | NULL | NULL | 17973 |
| NULL | NULL | 27026 | Cc | 3368 | NULL | NULL | 19448 |
| NULL | NULL | 27032 | Cc | 3368 | NULL | NULL | 19463 |
| NULL | NULL | 27022 | Cc | 3368 | NULL | NULL | 19470 |
| NULL | NULL | 28635 | Cc | 80 | NULL | NULL | 19698 |
| NULL | NULL | 30104 | Cc | 3368 | NULL | NULL | 19875 |
| NULL | NULL | 34258 | Cc | 3368 | NULL | NULL | 20689 |
| NULL | NULL | 35064 | Requestor | 29500 | NULL | NULL | 20765 |
| NULL | NULL | 37891 | Cc | 3368 | NULL | NULL | 21147 |
| NULL | NULL | 37451 | Cc | 80 | NULL | NULL | 21325 |
| NULL | NULL | 37455 | Cc | 3368 | NULL | NULL | 21325 |
| NULL | NULL | 41186 | Cc | 3980 | NULL | NULL | 22037 |
| NULL | NULL | 46850 | Cc | 43751 | NULL | NULL | 23378 |
| NULL | NULL | 50198 | Cc | 46908 | NULL | NULL | 23926 |
| NULL | NULL | 50744 | Cc | 3368 | NULL | NULL | 24139 |
| NULL | NULL | 50741 | Cc | 3368 | NULL | NULL | 24140 |
| NULL | NULL | 55822 | Cc | 3368 | NULL | NULL | 24528 |
| NULL | NULL | 56273 | Cc | 3368 | NULL | NULL | 24569 |
| NULL | NULL | 54174 | Requestor | 8080 | NULL | NULL | 24918 |
| NULL | NULL | 57190 | Cc | 3368 | NULL | NULL | 25636 |
| NULL | NULL | 62220 | Requestor | 29500 | NULL | NULL | 25955 |
| NULL | NULL | 60048 | Cc | 3368 | NULL | NULL | 26286 |
| NULL | NULL | 60638 | Cc | 3368 | NULL | NULL | 26421 |
| NULL | NULL | 61226 | Cc | 3368 | NULL | NULL | 26560 |
| NULL | NULL | 63750 | AdminCc | 3368 | NULL | NULL | 27124 |
| NULL | NULL | 67219 | Cc | 3368 | NULL | NULL | 27552 |
| NULL | NULL | 67687 | Cc | 3368 | NULL | NULL | 27913 |
| NULL | NULL | 69689 | Cc | 56816 | NULL | NULL | 28316 |
| NULL | NULL | 69767 | Cc | 69640 | NULL | NULL | 28316 |
| NULL | NULL | 91506 | Cc | 87643 | NULL | NULL | 31135 |
| NULL | NULL | 93739 | Cc | 70530 | NULL | NULL | 31709 |
| NULL | NULL | 94865 | Cc | 46726 | NULL | NULL | 31954 |
| NULL | NULL | 96762 | Cc | 94386 | NULL | NULL | 32376 |
| NULL | NULL | 96885 | Cc | 94462 | NULL | NULL | 32405 |
| NULL | NULL | 97572 | Requestor | 92077 | NULL | NULL | 32548 |
| NULL | NULL | 98231 | Requestor | 70530 | NULL | NULL | 32602 |
| NULL | NULL | 98295 | Cc | 28368 | NULL | NULL | 32662 |
| NULL | NULL | 98296 | Cc | 13287 | NULL | NULL | 32662 |
| NULL | NULL | 98297 | Cc | 95798 | NULL | NULL | 32662 |
| NULL | NULL | 99376 | Requestor | 28368 | NULL | NULL | 32662 |
| NULL | NULL | 99378 | Cc | 95792 | NULL | NULL | 32662 |
| NULL | NULL | 99380 | Requestor | 13287 | NULL | NULL | 32662 |
| NULL | NULL | 99361 | Cc | 3448 | NULL | NULL | 32843 |
| NULL | NULL | 103316 | Requestor | 65511 | NULL | NULL | 33745 |
| NULL | NULL | 105409 | Cc | 3368 | NULL | NULL | 34100 |
| NULL | NULL | 105671 | Requestor | 2638 | NULL | NULL | 34139 |
| NULL | NULL | 106944 | Cc | 3368 | NULL | NULL | 34251 |
| NULL | NULL | 107906 | Cc | 3368 | NULL | NULL | 34544 |
| NULL | NULL | 108606 | Cc | 3368 | NULL | NULL | 34645 |
| NULL | NULL | 120082 | Cc | 101555 | NULL | NULL | 34676 |
| NULL | NULL | 115778 | Cc | 3368 | NULL | NULL | 34956 |
| NULL | NULL | 111031 | Requestor | 103208 | NULL | NULL | 35077 |
| NULL | NULL | 111441 | Cc | 108236 | NULL | NULL | 35157 |
| NULL | NULL | 113017 | Requestor | 13287 | NULL | NULL | 35427 |
| NULL | NULL | 118641 | Cc | 114272 | NULL | NULL | 35642 |
| NULL | NULL | 115584 | Requestor | 20559 | NULL | NULL | 35899 |
| NULL | NULL | 122977 | Requestor | 56991 | NULL | NULL | 37107 |
| NULL | NULL | 122590 | Cc | 3368 | NULL | NULL | 37109 |
| NULL | NULL | 123679 | Cc | 118250 | NULL | NULL | 37276 |
| NULL | NULL | 123685 | Cc | 3980 | NULL | NULL | 37276 |
| NULL | NULL | 123688 | Requestor | 3980 | NULL | NULL | 37276 |
| NULL | NULL | 124658 | Cc | 115066 | NULL | NULL | 37442 |
| NULL | NULL | 126140 | Cc | 114272 | NULL | NULL | 37672 |
| NULL | NULL | 128117 | Requestor | 121662 | NULL | NULL | 38015 |
| NULL | NULL | 129436 | Cc | 122762 | NULL | NULL | 38247 |
| NULL | NULL | 131431 | Cc | 2638 | NULL | NULL | 38591 |
| NULL | NULL | 132796 | Requestor | 115066 | NULL | NULL | 38825 |
| NULL | NULL | 138759 | Cc | 93112 | NULL | NULL | 39852 |
| NULL | NULL | 138760 | Cc | 12404 | NULL | NULL | 39852 |
| NULL | NULL | 139254 | Requestor | 131402 | NULL | NULL | 40025 |
| NULL | NULL | 170704 | Cc | 145261 | NULL | NULL | 42026 |
| NULL | NULL | 165328 | Cc | 143705 | NULL | NULL | 42380 |
| NULL | NULL | 178572 | Requestor | 145221 | NULL | NULL | 43382 |
| NULL | NULL | 263341 | Cc | 100603 | NULL | NULL | 44028 |
| NULL | NULL | 189265 | Cc | 151286 | NULL | NULL | 44042 |
| NULL | NULL | 189268 | Cc | 151288 | NULL | NULL | 44042 |
| NULL | NULL | 189271 | Cc | 151290 | NULL | NULL | 44042 |
| NULL | NULL | 191666 | Cc | 3368 | NULL | NULL | 44190 |
| NULL | NULL | 205214 | Cc | 3368 | NULL | NULL | 45009 |
| NULL | NULL | 285102 | Cc | 3368 | NULL | NULL | 45042 |
| NULL | NULL | 217596 | Requestor | 159539 | NULL | NULL | 45721 |
| NULL | NULL | 224299 | Cc | 162093 | NULL | NULL | 46213 |
| NULL | NULL | 224300 | Requestor | 29760 | NULL | NULL | 46213 |
| NULL | NULL | 233472 | Cc | 165261 | NULL | NULL | 46833 |
| NULL | NULL | 260741 | Cc | 3368 | NULL | NULL | 48741 |
| NULL | NULL | 284029 | Requestor | 3980 | NULL | NULL | 49971 |
| NULL | NULL | 288692 | Requestor | 185022 | NULL | NULL | 50658 |
| NULL | NULL | 298445 | Cc | 10268 | NULL | NULL | 51160 |
| NULL | NULL | 307010 | Cc | 3368 | NULL | NULL | 51802 |
| NULL | NULL | 314703 | Cc | 3368 | NULL | NULL | 52094 |
| NULL | NULL | 320961 | Cc | 196017 | NULL | NULL | 52511 |
| NULL | NULL | 336707 | Cc | 3368 | NULL | NULL | 53444 |
| NULL | NULL | 340022 | Cc | 3368 | NULL | NULL | 53686 |
| NULL | NULL | 363180 | Cc | 3368 | NULL | NULL | 53858 |
| NULL | NULL | 343420 | Cc | 3368 | NULL | NULL | 53870 |
| NULL | NULL | 345199 | Cc | 3368 | NULL | NULL | 54012 |
| NULL | NULL | 377862 | Cc | 3368 | NULL | NULL | 55767 |
±-----±--------------±-------±----------±---------±--------------±-------------±------+
116 rows in set (2.03 sec)

Best regards, Ruslan.

Mathew_Snyder2 · February 9, 2007, 6:37am

sweet. Thanks Ruslan. I’ll have to print all of this out for future use
because I KNOW it will come up again… se la vie

Thanks again.

Ruslan Zakirov wrote:

Mathew_Snyder2 · February 10, 2007, 2:37am

Ruslan,

I was able to run the query you provided the other day and eliminated over 3500
transactions that were left behind. We are now able to access all data in this,
as well as other, tickets that suffered from the same problem.

Again, Thank you. This is a life saver.

Mathew

Ruslan Zakirov wrote:> On 2/9/07, Mathew Snyder theillien@yahoo.com wrote:

It would appear I removed someone that was added as a CC:

±-------±----------±--------------±-------------±------+
| Name | Field | ReferenceType | NewReference | tid |
±-------±----------±--------------±-------------±------+
| NULL | Cc | NULL | NULL | 55767 |
| rbates | Requestor | NULL | NULL | 55767 |
±-------±----------±--------------±-------------±------+

Is it possible to correct this?
Yes, sure.
This means that you’ve deleted a user who was added as Cc watcher to
ticket 55767. As well this means a bug exists in shredder and I’ve
fixed it and released shredder 0.05.

The following query is more informative:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL AND t.id = XXXXX;

This query selects only transactions with problems. txn_id column in
the result will show you problematic Transactions and NewValue column
will show you ids of the users that don’t exist anymore.

You can safely delete this transactions using the following query:
DELETE FROM Transactions WHERE id IN (xxx, xxx, xxx,…);

Also, you can select all such transactions from your DB:
SELECT u.Name, txn.id txn_id, txn.Field, txn.NewValue, 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
u.id IS NULL;

If amount of the transactions is too big then I could help you write
down a delete query that will delete all this txns.

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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com