Unowned tickets not showing?

List,

I have a RT 4.0.6 on debian squeeze, with postgres as a backend (8.4)
running for a while now. I’m getting reports that some tickets, even
though the owner is set to “nobody”, are not showing on the list of
unowned ticket for people. One of the users is “managing” the queue and
assigning ticket. She’s got a few ticket she “found” by looking at "new"
tickets (from the list on the right of the main page), that are not
showing for her in the “unowned” tickets. My first thought was that she
had too many and the “missing” ones where just the 21st and 22nd tickets
on the main page. I was wrong. She showed me, she only has 5 tickets
listed as “unowned”, and 2 more if you look at the all tickets in queue,
and those have owner set to “nobody”.

I’m a little confused as to how I can tackle the problem at this point.
Logs don’t show much, the ticket is in thereŠ there is only one "nobody"
user in the DB. Anybody seen this before?

Thanks,
Jok
| Joachim Thuau | IT Systems Engineer - Linux / SpaceX |

Hi Jok,

It’s seems to be related to the following :From: Kevin Falcone falcone@bestpractical.com
Date: 1 March 2013 19:09
Subject: Re: [rt-users] 10 Unowned tickets showing nothing
To: rt-users@lists.bestpractical.com

I’ve a problem with RT4’s “N” newest unowned tickets:
If I don’t have permission to see the system wide newest tickets, I won’t
see anything.
I mean, the system first extract the list, then decides if I have
permission to see the tickets. Is there a way to fix this?

You probably want to turn this config option on.

http://bestpractical.com/rt/docs/latest/RT_Config.html#UseSQLForACLChecks

It’s going to be defaulted on for 4.2, and while it does perform weirdly
in some rights configurations, it’s almost certainly the fix you’re
looking for.

-kevin

It’s seems to be related to the following :

Thank you! That has helped tremendously!

Thanks,
Jok

http://bestpractical.com/rt/docs/latest/RT_Config.html#UseSQLForACLChecks

It’s going to be defaulted on for 4.2, and while it does perform weirdly
in some rights configurations, it’s almost certainly the fix you’re
looking for.