[rt-users] Shredder User plugin mangling tickets?
theillien at yahoo.com
Sat Dec 2 01:40:23 EST 2006
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:
> 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)
> 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
>> 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
>> uppercase 'N'?
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
More information about the rt-users