[rt-users] Shredder User plugin mangling tickets?

Mathew Snyder 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:
> 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: 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 mailing list