Hi Sven, i remember this problem at our installation some years ago, a hint from Ruz was to check inside the link table for this ticket number and fix the problem directly here (hopefully i remember correctly)
@Ruz: I think this solved the problem for us, several hundret years ago ;-) @Sven: Wie siehts mit nem Treffen Anfang Dezember bei Euch aus? Torsten Kuehne + Nagel (AG & Co.) KG, Geschaeftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius (Stellv.), Reiner Heiken (Stellv.), Bruno Mang, Alfred Manke, Christian Marnetté (Stellv.), Mark Reinhardt (Stellv.), Jens Wollesen, Rainer Wunn, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persoenlich haftende Gesellschaft: Kuehne & Nagel A.G., Sitz: Contern/Luxemburg Geschaeftsfuehrender Verwaltungsrat: Klaus-Michael Kuehne -----Urspruengliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Sven Sternberger Gesendet: Dienstag, 10. November 2009 13:57 An: Ruslan Zakirov Cc: [email protected] Betreff: Re: [rt-users] Problems with rt-shredder / rt-validator Hello! I'm still interested to get rid of the ticket. Now with rt3.8.6 I still get # /opt/rt3/sbin/rt-shredder --plugin "Tickets=query,Status ='deleted' AND id=228186;limit,100" SQL dump file is '/root/20091110T124735-0001.sql' Next 1 objects would be deleted: RT::Ticket-228186 object Do you want to proceed? [y/N] y Couldn't wipeout object: Can't call method "IsLocal" on an undefined value at /opt/rt3/sbin/../lib/RT/URI.pm line 249, <STDIN> line 1. ===================== /root/20091110T124735-0001.sql: INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842057','2483006','842057','22064','2483006'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842057','2483007','842057','22064','2483000'); INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`) VALUES('842057','849693','22064'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842057','2483000','842057','842057','2483000'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113090',NULL,NULL,'842057','RT::Group',NULL,NULL,NULL,'0','Create'); INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) VALUES(NULL,'RT::Ticket-Role','842057','228186',NULL,'Requestor'); INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) VALUES('0','842057','842057','Group'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842058','2483004','842058','10','2483004'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842058','2483005','842058','10','2483001'); INSERT INTO `GroupMembers`(`groupid`,`id`,`memberid`) VALUES('842058','849692','10'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842058','2483001','842058','842058','2483001'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113091',NULL,NULL,'842058','RT::Group',NULL,NULL,NULL,'0','Create'); INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) VALUES(NULL,'RT::Ticket-Role','842058','228186',NULL,'Owner'); INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) VALUES('0','842058','842058','Group'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842059','2483002','842059','842059','2483002'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113092',NULL,NULL,'842059','RT::Group',NULL,NULL,NULL,'0','Create'); INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) VALUES(NULL,'RT::Ticket-Role','842059','228186',NULL,'Cc'); INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) VALUES('0','842059','842059','Group'); INSERT INTO `CachedGroupMembers`(`disabled`,`groupid`,`id`,`immediateparentid`,`memberid`,`via`) VALUES('0','842060','2483003','842060','842060','2483003'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113093',NULL,NULL,'842060','RT::Group',NULL,NULL,NULL,'0','Create'); INSERT INTO `Groups`(`description`,`domain`,`id`,`instance`,`name`,`type`) VALUES(NULL,'RT::Ticket-Role','842060','228186',NULL,'AdminCc'); INSERT INTO `Principals`(`disabled`,`id`,`objectid`,`principaltype`) VALUES('0','842060','842060','Group'); INSERT INTO `Attachments`(`content`,`contentencoding`,`contenttype`,`created`,`creator`,`filename`,`headers`,`id`,`messageid`,`parent`,`subject`,`transactionid`) VALUES('xxxx','none','text/plain','2007-07-30 12:21:57','1',NULL,'Content-Type: text/plain\nContent-Disposition: inline\nContent-Transfer-Encoding: binary\nMIME-Version: 1.0\nX-Mailer: MIME-tools 5.420 (Entity 5.420)\n','621573','','0','','1113094'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-07-30 12:21:57','1',NULL,NULL,'1113094',NULL,NULL,'228186','RT::Ticket',NULL,NULL,NULL,'0','Create'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2007-09-18 14:15:43','22064',NULL,'Status','1172242',NULL,'deleted','228186','RT::Ticket',NULL,'new',NULL,'0','Status'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2009-09-10 14:13:25','22064',NULL,'Status','2215411',NULL,'open','228186','RT::Ticket',NULL,'deleted',NULL,'0','Status'); INSERT INTO `Transactions`(`created`,`creator`,`data`,`field`,`id`,`newreference`,`newvalue`,`objectid`,`objecttype`,`oldreference`,`oldvalue`,`referencetype`,`timetaken`,`type`) VALUES('2009-09-10 14:13:45','22064',NULL,'Status','2215414',NULL,'deleted','228186','RT::Ticket',NULL,'open',NULL,'0','Status'); On Thu, 2009-09-10 at 20:09 +0400, Ruslan Zakirov wrote: > Hi Sven, > > rt-validator lacks some checks regarding links and probably doesn't > catch many cases regarding Links table. > > On Thu, Sep 10, 2009 at 12:35 PM, Sven > Sternberger<[email protected]> wrote: > > Hello! > > > > RT3.8.4/mysql5/ScientificLinux 5 (RHEL-Clone) > > > > I try to erease an old tickets from our RT, but this fails with the > > message "Couldn't wipeout object: Can't call method "IsLocal" on an > > undefined value at /opt/rt3/sbin/../lib/RT/URI.pm line 249, <STDIN> > > line 1." > > > > I tried rt-validator. But this don't help, the ticket can't be > > wipeout afterwards. * > > > > If I try to open the ticket in the Web-UI, the Link-Box is missing > > instead there is the message Can't call method "Object" on an > > undefined value at /opt/rt3/bin/../lib/RT/URI.pm line 232" > > > > I found one record in the Links table which referenced this ticket > > (as LocalBase). I deleted this record, but the problem remains. * > > > > (* on a test machine, with copy of the production data) > > > > Any ideas what I can do to repair the DB? > > > > best regards! > > > > sven > > > > _______________________________________________ > > 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 _______________________________________________ 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
