I looked at all the creators of transactions for the ticket and found that none are users that have been removed. However, root owns a few but I don't know if it is typical to have root create transactions. If it is, I'm wondering if maybe a link to another table, say Attachments was broken.
Roy El-Hames wrote: > Mathew; > I think the problem is its trying to build a join and can't find the > user id in the Users table, you need (from sql) to update the appropriate > Transactions row changing the Creator value to the id of the User > Nobody(or its safer to change it to your Id privileged user) > Roy > Mathew Snyder wrote: >> Jesse Vincent wrote: >> >>>> plugin. For the most part, this has been a successful operation. >>>> However, due >>>> to the number of legitimate users, picking out the spam users is not >>>> a perfect >>>> science and I've inadvertently removed legitimate users. >>>> >>>> This has resulted in a ticket getting mangled...I think. I'm not >>>> sure why it >>>> would cause the transactions to get messed up or even if it has. >>>> But this is >>>> the output generated on the latest ticket to suffer the problem: >>>> >>> You've removed the user a transaction referred to. RT can't find >>> something that's...well, never supposed to be removed. So it's >>> exploding. >>> >>> >> >> Besides, if I set the replace_relations field to nobody, shouldn't it >> assign all >> those transactions to the Nobody user? Or would I have to use the id for >> Nobody? Or is using nobody with lowercase 'n' not the same as Nobody >> with >> uppercase 'N'? >> >> Mathew >> _______________________________________________ >> 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