[rt-users] Shredder User plugin mangling tickets?

Sat Dec 2 01:41:14 EST 2006

This is the 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(0xa45b39c)') called at
/usr/local/rt-3.6.1/lib/RT/Transaction_Overlay.pm line 602
RT::Transaction::BriefDescription('RT::Transaction=HASH(0xa45b39c)') called at
/usr/local/rt-3.6.1/share/html/Ticket/Elements/ShowTransaction line 54
HTML::Mason::Commands::__ANON__('Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'AttachmentContent', 'RT::Attachments=HASH(0xa42ebd8)', 'ShowHeaders', undef,
'Collapsed', undef, 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
'UpdatePath', '/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'Transaction', 'RT::Transaction=HASH(0xa45b39c)', 'ShowHeaders', undef,
'Collapsed', undef, 'RowNum', 12, 'ShowTitleBarCommands', 1, 'Attachments',
'ARRAY(0xa40c70c)', 'AttachmentContent', 'HASH(0xa4a0288)', '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(0xa308b10)',
'Attachments', 'RT::Attachments=HASH(0xa4bc418)', 'Ticket',
'RT::Ticket=HASH(0xa4625ac)', 'AttachmentContent',
'RT::Attachments=HASH(0xa42ebd8)', 'ShowHeaders', undef, 'Collapsed', undef,
'Tickets', undef, 'AttachPath', '/Ticket/Attachment', 'UpdatePath',
'/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)', 'Transaction',
'RT::Transaction=HASH(0xa45b39c)', 'ShowHeaders', undef, 'Collapsed', undef,
'RowNum', 12, 'ShowTitleBarCommands', 1, 'Attachments', 'ARRAY(0xa40c70c)',
'AttachmentContent', 'HASH(0xa4a0288)', '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(0xa4bc418)', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'AttachmentContent', 'RT::Attachments=HASH(0xa42ebd8)', 'ShowHeaders', undef,
'Collapsed', undef, 'Tickets', undef, 'AttachPath', '/Ticket/Attachment',
'UpdatePath', '/Ticket/Update.html', 'Ticket', 'RT::Ticket=HASH(0xa4625ac)',
'Transaction', 'RT::Transaction=HASH(0xa45b39c)', 'ShowHeaders', undef,
'Collapsed', undef, 'RowNum', 12, 'ShowTitleBarCommands', 1, 'Attachments',
'ARRAY(0xa40c70c)', 'AttachmentContent', 'HASH(0xa4a0288)', '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(0xa4625ac)',
'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef, 'Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'AttachmentContent',
'RT::Attachments=HASH(0xa42ebd8)') 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(0xa2ff7f0)',
'Ticket', 'RT::Ticket=HASH(0xa4625ac)', 'Tickets', undef, 'Collapsed', undef,
'ShowHeaders', undef, 'Attachments', 'RT::Attachments=HASH(0xa4bc418)',
'AttachmentContent', 'RT::Attachments=HASH(0xa42ebd8)') 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(0xa4625ac)',
'Tickets', undef, 'Collapsed', undef, 'ShowHeaders', undef, 'Attachments',
'RT::Attachments=HASH(0xa4bc418)', 'AttachmentContent',
'RT::Attachments=HASH(0xa42ebd8)') called at
/usr/local/rt-3.6.1/share/html/Ticket/Display.html line 63
HTML::Mason::Commands::__ANON__('id', 39852, 'id', 39852) 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(0xa207760)',
'id', 39852, 'id', 39852) 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', 39852, 'id', 39852) 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(0xa4e966c)',
'id', 39852) called at /usr/local/rt-3.6.1/share/html/autohandler line 279
HTML::Mason::Commands::__ANON__('id', 39852) 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(0x9e1cf98)',
'id', 39852) 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', 39852) 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(0xa4e966c)')
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(0xa4e966c)')
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(0x8f437b0)',
'Apache2::RequestRec=SCALAR(0xa4bc454)') 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(0xa4bc454)') called at -e line 0

Mathew

Roy El-Hames wrote:
> Mathew;
> I think the problem is its trying to build a join and can't find the
> user id in the Users table, you need (from sql) to update the appropriate
> Transactions row changing the Creator value to the id of the User
> Nobody(or its safer to change it to your Id privileged user)
> Roy
> Mathew Snyder wrote:
>> Jesse Vincent wrote:
>>  
>>>> plugin.  For the most part, this has been a successful operation. 
>>>> However, due
>>>> to the number of legitimate users, picking out the spam users is not
>>>> a perfect
>>>> science and I've inadvertently removed legitimate users.
>>>>
>>>> This has resulted in a ticket getting mangled...I think.  I'm not
>>>> sure why it
>>>> would cause the transactions to get messed up or even if it has. 
>>>> But this is
>>>> the output generated on the latest ticket to suffer the problem:
>>>>       
>>> You've removed the user a transaction referred to. RT can't find
>>> something that's...well, never supposed to be removed. So it's
>>> exploding.
>>>
>>>     
>>
>> Besides, if I set the replace_relations field to nobody, shouldn't it
>> assign all
>> those transactions to the Nobody user?  Or would I have to use the id for
>> Nobody?  Or is using nobody with lowercase 'n' not the same as Nobody
>> with
>> uppercase 'N'?
>>
>> Mathew
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>   
> 
> 