> 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
