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" <[EMAIL PROTECTED]> > To: "Roy El-Hames" <[EMAIL PROTECTED]> > Cc: <[email protected]> > 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: [EMAIL PROTECTED] >>>> >>>> >>>> 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: [EMAIL PROTECTED] >> >> >> 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 >> >> > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
