Re: [rt-users] RTx-Shredder question
On Wed, Aug 09, 2006 at 10:47:16AM +0200, Marco Avvisano wrote:
I'm trying to use RTx-Shredder on RT 3.6.0 from command line:
/opt/rt3/local/sbin/rtx-shredder --plugin 'Tickets=queue, queuename'
and return this error:
[crit]: Couldn't wipeout object: Can't call method IsLocal on an
undefined value at /opt/rt3/lib/RT/URI.pm line 247, STDIN line 1.
(/opt/rt3/lib/RT.pm:317)
Do you have Asset Tracker installed?
no ... it's possible to download a free version?
Is this a ticket that might of had a link at some point?
may be ... if i try to view the ticket, return me this error
error: Can't call method IsLocal on an undefined value at
/opt/rt3/lib/RT/URI.pm line 247.
context: ...
243: =cut
244:
245: sub IsLocal {
246: my $self = shift;
247: return $self-Resolver-IsLocal;
248: }
249:
250:
251: # }}}
...
code stack: /opt/rt3/lib/RT/URI.pm:247
/opt/rt3/lib/RT/Links_Overlay.pm:159
/opt/rt3/share/html/Elements/ShowLinks:85
/opt/rt3/share/html/Ticket/Elements/ShowSummary:90
/opt/rt3/share/html/Widgets/TitleBox:49
/opt/rt3/share/html/Ticket/Elements/ShowSummary:91
/opt/rt3/share/html/Ticket/Display.html:56
/opt/rt3/share/html/Widgets/TitleBox:49
/opt/rt3/share/html/Ticket/Display.html:57
/opt/rt3/share/html/autohandler:279
raw error
Can't call method IsLocal on an undefined value at /opt/rt3/lib/RT/URI.pm
line 247.
Trace begun at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method IsLocal on
an undefined value at /opt/rt3/lib/RT/URI.pm line 247.^J') called at
/opt/rt3/lib/RT/URI.pm line 247
RT::URI::IsLocal('RT::URI=HASH(0xa722694)') called at
/opt/rt3/lib/RT/Links_Overlay.pm line 159
RT::Links::Next('RT::Links=HASH(0xa7212dc)') called at
/opt/rt3/share/html/Elements/ShowLinks line 85
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0xa67c43c)')
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm
line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa71f75c)',
'Ticket', 'RT::Ticket=HASH(0xa67c43c)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {...} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, 'Ticket',
'RT::Ticket=HASH(0xa67c43c)') called at
/opt/rt3/share/html/Ticket/Elements/ShowSummary line 90
HTML::Mason::Commands::__ANON__ at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1315
HTML::Mason::Request::content('HTML::Mason::Request::CGI=HASH(0xa50ded4)')
called at /opt/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::__ANON__('title', 'Collegamenti', 'title_href',
'/Ticket/ModifyLinks.html?id=2', 'class', 'ticket-info-links') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa0b45d4)',
'title', 'Collegamenti', 'title_href', '/Ticket/ModifyLinks.html?id=2',
'class', 'ticket-info-links') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {...} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, undef, 'title', 'Collegamenti',
'title_href', '/Ticket/ModifyLinks.html?id=2', 'class', 'ticket-info-links')
called at /opt/rt3/share/html/Ticket/Elements/ShowSummary line 91
HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0xa67c43c)',
'Attachments', 'RT::Attachments=HASH(0xa5bc2c0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa6ba4fc)',
'Ticket', 'RT::Ticket=HASH(0xa67c43c)', 'Attachments',
'RT::Attachments=HASH(0xa5bc2c0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1251
eval {...} at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1245
HTML::Mason::Request::comp(undef, undef, 'Ticket',
'RT::Ticket=HASH(0xa67c43c)', 'Attachments',
'RT::Attachments=HASH(0xa5bc2c0)') called at
/opt/rt3/share/html/Ticket/Display.html line 56
HTML::Mason::Commands::__ANON__ at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1315
HTML::Mason::Request::content('HTML::Mason::Request::CGI=HASH(0xa50ded4)')
called at /opt/rt3/share/html/Widgets/TitleBox line 49
HTML::Mason::Commands::__ANON__('title', 'Metadati del ticket') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa0b45d4)',
'title', 'Metadati del ticket') called at
Re: [rt-users] RTx-Shredder question
Marco Avvisano wrote: I'm trying to use RTx-Shredder on RT 3.6.0 from command line: /opt/rt3/local/sbin/rtx-shredder --plugin 'Tickets=queue, queuename' and return this error: [crit]: Couldn't wipeout object: Can't call method IsLocal on an undefined value at /opt/rt3/lib/RT/URI.pm line 247, STDIN line 1. (/opt/rt3/lib/RT.pm:317) any ideas ? Marco - Original Message - From: Ruslan Zakirov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Sent: Friday, July 14, 2006 2:38 PM Subject: Re: [rt-users] RTx-Shredder question As I remember one of users reported that shredder deletes 500 records from different tables of his DB for four tickets only. Really the tickets table is la punta dell'iceberg. On 7/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I had a question about removing ticket from the database... I am not a database expert so this will be a green question... Instead of using RTx-Shredder why can't I simply run a query against the database to remove any tickets with the status of deleted? Will that leave too many other linked tables with data that is not linked? Is that why we should use RTx-Shredder? On my test Installs of RT I have deleted data this way without an issue... Just curious... ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html -- Best regards, Ruslan. ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html ___ 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 I'm no expert but I don't think there is supposed to be a space between the comma and the queuename: /opt/rt3/local/sbin/rtx-shredder --plugin 'Tickets=queue,queuename' Mathew Snyder ___ 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
Re: [rt-users] RTx-Shredder question
On Wed, Aug 09, 2006 at 10:47:16AM +0200, Marco Avvisano wrote: I'm trying to use RTx-Shredder on RT 3.6.0 from command line: /opt/rt3/local/sbin/rtx-shredder --plugin 'Tickets=queue, queuename' and return this error: [crit]: Couldn't wipeout object: Can't call method IsLocal on an undefined value at /opt/rt3/lib/RT/URI.pm line 247, STDIN line 1. (/opt/rt3/lib/RT.pm:317) Do you have Asset Tracker installed? Is this a ticket that might of had a link at some point? -Todd ___ 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
Re: [rt-users] RTx::Shredder question
Approvals are on Todo list(see Todo file), I don't know much about approvals to work on it. On 8/3/06, Todd Chapman [EMAIL PROTECTED] wrote: Ruslan, Shreder doesn't seem to find approval tickets. Am I missing something? -Todd ___ 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 -- Best regards, Ruslan. ___ 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
Re: [rt-users] RTx::Shredder question
On Fri, Aug 04, 2006 at 06:48:09PM +0400, Ruslan Zakirov wrote: Approvals are on Todo list(see Todo file), I don't know much about approvals to work on it. What's to know? Type = 'approval' On 8/3/06, Todd Chapman [EMAIL PROTECTED] wrote: Ruslan, Shreder doesn't seem to find approval tickets. Am I missing something? -Todd ___ 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 -- Best regards, Ruslan. ___ 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
Re: [rt-users] RTx-Shredder question
As I remember one of users reported that shredder deletes 500 records from different tables of his DB for four tickets only. Really the tickets table is la punta dell'iceberg. On 7/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I had a question about removing ticket from the database... I am not a database expert so this will be a green question... Instead of using RTx-Shredder why can't I simply run a query against the database to remove any tickets with the status of deleted? Will that leave too many other linked tables with data that is not linked? Is that why we should use RTx-Shredder? On my test Installs of RT I have deleted data this way without an issue... Just curious... ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html -- Best regards, Ruslan. ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] RTx-Shredder question
Hello, On Thu, Jul 13, 2006 at 11:48:46AM -0400, [EMAIL PROTECTED] wrote: snip Will that leave too many other linked tables with data that is not linked? Is that why we should use RTx-Shredder? snip Simply put, yes :) Sincerely, Frank Pater DCANet http://www.dca.net voice: 888-4-DCANET (888-432-2638) fax: 302-426-6386 pgpw2OCc4v6B5.pgp Description: PGP signature ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
Re: [rt-users] RTx-Shredder question
On 7/13/06, Frank Pater [EMAIL PROTECTED] wrote: Hello, On Thu, Jul 13, 2006 at 11:48:46AM -0400, [EMAIL PROTECTED] wrote: snip Will that leave too many other linked tables with data that is not linked? Is that why we should use RTx-Shredder? snip Simply put, yes :) However is this a bad thing? I mean if there is data in the database that I do not want and is associated with an ID number that does not exitst does that matter? Yes, it can break the WebUI. For example, attempting to load a ticket that contains a link to another ticket that has been removed from the database causes the web interface to dump an error which prevents you from accessing the existing ticket. Ruslan would have to confirm this, but I believe that Shredder will remove the link in the existing ticket when the referenced one is deleted from the database. Based on my experience restoring stuff from Shredder's sql dumps, I can confidently say that when it removes a single ticket from the database, many SQL actions occur. From this, I gather there is much more complexity involved than the situation I describe above. Sincerely, Frank Pater DCANet http://www.dca.net voice: 888-4-DCANET (888-432-2638) fax: 302-426-6386 pgpyTExKgqUGv.pgp Description: PGP signature ___ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
