[rt-users] Unassigning tickets does not work
JC Boggio
rt-users at thefreecat.org
Tue Feb 7 14:21:41 EST 2012
Thomas,
Le 07/02/2012 17:47, Thomas Sibley a écrit :
> Unless you're seeing problems in the logs, I think you're fine. Nobody
> displays as the Owner in the Basics section of the ticket display page,
> right?
Nope, still me.
I give the ticket to some coworker :
select * from tickets where id=27155;
id | effectiveid | queue | type | issuestatement | resolution | owner | subject | initialpriority | finalpriority | priority | timeestimated | timeworked | status | timeleft | told | starts | started | due | resolved | lastupdatedby | lastupdated | creator | created | disabled
-------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+--------+----------+------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------
27155 | 27155 | 33 | ticket | 0 | 0 | 104 | [0450757d] **Temps de réponse anormal - rca0450757dcpe01 | 0 | 0 | 0 | 0 | 0 | open | 0 | | 1970-01-01 00:00:00 | 2012-02-07 13:23:52 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 22 | 2012-02-07 19:13:07 | 19061 | 2012-02-07 13:14:20 | 0
I steal the ticket :
select * from tickets where id=27155;
id | effectiveid | queue | type | issuestatement | resolution | owner | subject | initialpriority | finalpriority | priority | timeestimated | timeworked | status | timeleft | told | starts | started | due | resolved | lastupdatedby | lastupdated | creator | created | disabled
-------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+--------+----------+------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------
27155 | 27155 | 33 | ticket | 0 | 0 | 22 | [0450757d] **Temps de réponse anormal - rca0450757dcpe01 | 0 | 0 | 0 | 0 | 0 | open | 0 | | 1970-01-01 00:00:00 | 2012-02-07 13:23:52 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 22 | 2012-02-07 19:08:19 | 19061 | 2012-02-07 13:14:20 | 0
I change it to "Nobody in particular" :
select * from tickets where id=27155;
id | effectiveid | queue | type | issuestatement | resolution | owner | subject | initialpriority | finalpriority | priority | timeestimated | timeworked | status | timeleft | told | starts | started | due | resolved | lastupdatedby | lastupdated | creator | created | disabled
-------+-------------+-------+--------+----------------+------------+-------+----------------------------------------------------------+-----------------+---------------+----------+---------------+------------+--------+----------+------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------
27155 | 27155 | 33 | ticket | 0 | 0 | 22 | [0450757d] **Temps de réponse anormal - rca0450757dcpe01 | 0 | 0 | 0 | 0 | 0 | open | 0 | | 1970-01-01 00:00:00 | 2012-02-07 13:23:52 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 22 | 2012-02-07 19:09:34 | 19061 | 2012-02-07 13:14:20 | 0
The yellow "Results" box says :
Intervenant changé de cat à Nobody
The history says :
JC BOGGIO - Non pris
Unfortunately, on the box underneath "modify users for ticket 27155", I see myself.
Same thing on "Ticket metadata" page.
And as you see on the query, owner is not 6.
select id,name from users where id in (1,6,22);
id | name
----+-----------
1 | RT_System
6 | Nobody
22 | cat
Nothing in /var/log/apache2/error.log
More information about the rt-users
mailing list