[rt-users] Transactions ObjectIDs

[Todd Chapman]

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