[rt-users] Ticket owner in database set to "no owner shown in search results"

Alex Hall ahall at autodist.com
Wed Jan 4 12:48:52 EST 2017

While this is still a mystery, please disregard the below email. I was
reading the columns wrong and mistook the subject for the owner. The owner
is actually set properly, yet this and another ticket come up if you search
for tickets whose owner is 'nobody'. Odd, but not quite as odd as I had in
the below message.

On Wed, Jan 4, 2017 at 12:18 PM, Alex Hall <ahall at autodist.com> wrote:

> Hi all,
> A while ago I was asking why owners don't always show in search results. I
> just had a look at one such ticket in the database:
> select * from Tickets where id = 527;
> The "Owner" column is set to the value "no owner shown in search results".
> I don't know how it got that way, or what it means. More puzzling still, if
> I open the ticket in the web UI, the owner is correct. Yet, this ticket
> shows up if I search for tickets in the UI with "Owner='nobody'". Somehow,
> RT knows the owner, but in the Tickets table has it set to this odd value
> I've never seen. What would cause this and, more importantly, how do I stop
> it from happening?
> We have a script set up to make the requestor the owner automatically, but
> that's working (I got it straight from the Wiki). This means that users
> aren't manually adding themselves as owners, they're relying on the script
> to do it for them when the ticket is created. Yet, sometimes, we get a
> ticket like the one described above--no owner in the database or searches,
> but an owner when you view the actual ticket. Any thoughts as to how to fix
> this, and how RT knows the owner? Is it substituting the creator somehow?
> I'm very confused! Thanks for any suggestions.
> --
> Alex Hall
> Automatic Distributors, IT department
> ahall at autodist.com

Alex Hall
Automatic Distributors, IT department
ahall at autodist.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20170104/0ecf6d36/attachment.html>

More information about the rt-users mailing list