On Fri, Jun 16, 2006 at 02:06:40PM +0100, Dermot Williams wrote: > Hi List, > > Owing to an unlikely series of events, all of the ObjectID values in the > Transactions table of our RT3 database have been set to the default > value, 0. Obviously this means that there is now no way to associate > tickets with their content. Does anyone have any ideas about how I can > restore the IDs? I'm 99.99% sure that it can't be done but I thought > that I'd ask anyway, just on the offchance that there is. > > And please don't mention backups. Grrrr! >
Here is a possilbe solution. Might not work 100%. The Headers column of the Attachments table should have Subject (at least some should). If you can match this to the Subject in the Tickets table, then you can use the TransactionId in the Attachments table to get the transaction and assign the ObjectId. -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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
