[rt-users] Merge Tickets bug?

Joseph_Micciche at Progressive.com Joseph_Micciche at Progressive.com
Tue Jul 5 13:29:06 EDT 2005


Jesse Vincent <jesse at bestpractical.com> wrote on 07/05/2005 11:37:02 AM:

> > What is expected behavior? and can I retain the Subject of the
principal
> > ticket?

> The expected behaviour is that 2183's subject should remain the same.
> I'm betting that MySQL is loading the wrong "half" of the merged ticket,
> possibly because RT isn't being specific enough.

> Can you show us the output of:

> SELECT * From Tickets where EffectiveId = 2183;

Here is the output of that query, Jesse (sorry for the csv format):

"2183";"2183";"3";"ticket";"0";"0";"457";"xxx-requests
2183";"11";"99";"11";"0";"0";"resolved";"0";NULL;"2005-06-02
04:00:00";"2005-06-02 20:17:46";"2005-07-01 04:00:00";"2005-07-05
15:07:04";"12";"2005-07-05 15:07:06";"306";"2005-06-02 19:51:45";"0"

"2316";"2183";"3";"ticket";"0";"0";"10";"xxx-requests
2183";"11";"99";"11";"0";"0";"resolved";"0";NULL;"1970-01-01
00:00:00";"1970-01-01 00:00:00";"2005-07-12 14:35:30";"1970-01-01
00:00:00";"457";"2005-07-05 14:35:45";"457";"2005-07-05 14:35:30";"0"

or:

Dumping data for table Tickets
2183  2183  3     ticket      0     0     457   xxx-requests 2183 11    99
11    0     0     resolved    0     NULL  2005-06-02 04:00:00
2005-06-02 20:17:46     2005-07-01 04:00:00     2005-07-05 15:07:04     12
2005-07-05 15:07:06     306   2005-06-02 19:51:45     0

2316  2183  3     ticket      0     0     10    xxx-requests 2183 11    99
11    0     0     resolved    0     NULL  1970-01-01 00:00:00
1970-01-01 00:00:00     2005-07-12 14:35:30     1970-01-01 00:00:00     457
2005-07-05 14:35:45     457   2005-07-05 14:35:30     0

(Unfortunately I resolved it after merging - but I can do a test ticket to
repeat and get those results if it'd help.)

joe




More information about the rt-users mailing list