[rt-users] Shredder User plugin mangling tickets?

[Mathew Snyder]

I performed on my development server the steps you've laid out.  However, there
aren't any changes.

Thanks though.

Mathew

Raed El-hames wrote:
> You may have removed one of the watchers on this ticket , not necessarly
> the requester, it can be cc or admin cc
> What I would suggest that you get all users related to this ticket from
> Groups , and CachedGroupMembers table, the easiest way if you don't want
> to build joins is
> from sql :
> select * from Groups where Instance = YOUR Ticket ID and Domain =
> 'RT::Ticket-Role'             ==check the field names and Domain values
> I am doing this from memory
> from every Groups.id you get back do:
> select MemberId from CachedGroupMembers where GroupId = The Groupid you got
> For every Member Id you get check the users table that its still there:
> select * from Users where id = The above MemberId
> If its not there Scream ..
> Kidding Just remove it from CachedGroupMembers
> delete * from CachedGroupMembers where Memberid = your member id and
> GroupId = Your group Id ...
> I think deleting entries from CachedGroupMembers does n't break anything
> (I donr it few times before).. but for liability sake do it at your own
> risk.
> BTW do not delete anything from the Groups table
> 
> Roy
> 
> ----- Original Message ----- From: "Mathew Snyder" <theillien at yahoo.com>
> To: "Roy El-Hames" <rfh at pipex.net>
> Cc: <rt-users at lists.bestpractical.com>
> Sent: Saturday, December 02, 2006 6:41 AM
> Subject: Re: [rt-users] Shredder User plugin mangling tickets?
> 
> 
>> 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
>>>>
>>>>
>>>
>>>
>> _______________________________________________
>> 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
>>
>>
>> -- 
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.1.409 / Virus Database: 268.15.4/563 - Release Date:
>> 02/12/2006
>>
>>
> 
>