Trac "lost" my tickets

0 views
Skip to first unread message

Jani Tiainen

unread,
Nov 4, 2008, 3:27:59 AM11/4/08
to trac-...@googlegroups.com
I had very old trac db that contained priorities and severities. I
decided to upgrade it a bit newer version, removed all severities and
made priorities more sane.

But, this killed all SQL based reports. How to fix that? This shouldn't
happen in first place of course...

--
Jani Tiainen

"Tein sein mihin näillä lahjoilla pystyin.
Tein sen, en yhtään enempää." - Martti Servo & Napander

Jani Tiainen

unread,
Nov 5, 2008, 4:55:04 AM11/5/08
to trac-...@googlegroups.com
Jani Tiainen kirjoitti:

> I had very old trac db that contained priorities and severities. I
> decided to upgrade it a bit newer version, removed all severities and
> made priorities more sane.

So, how I could recover my missing 700 tickets...

One resolution that I would like to use is to push mass update to all
tickets that don't have entry in my "priority" field to use default
value "normal" with attached text "Automatic update due new priority
classes" (or something like that) but how I can run such a mass update?

Remy Blank

unread,
Nov 5, 2008, 2:06:28 PM11/5/08
to trac-...@googlegroups.com
Jani Tiainen wrote:
> So, how I could recover my missing 700 tickets...

I suppose you haven't actually lost your tickets, have you? At least on
my test install, if I set e.g. a priority to a value not present in the
defined priorities, the ticket still appears on the custom query page.
You can't set a filter on the priority for "invalid" values, though, as
the drop-down is populated only with defined priorities.

You were mentioning SQL-based reports. If those give you trouble, you'll
have no choice but to fix the SQL so that it works with the new values.

-- Remy

signature.asc

Jani Tiainen

unread,
Nov 6, 2008, 2:19:21 AM11/6/08
to trac-...@googlegroups.com
Remy Blank kirjoitti:

> Jani Tiainen wrote:
>> So, how I could recover my missing 700 tickets...
>
> I suppose you haven't actually lost your tickets, have you? At least on
> my test install, if I set e.g. a priority to a value not present in the
> defined priorities, the ticket still appears on the custom query page.
> You can't set a filter on the priority for "invalid" values, though, as
> the drop-down is populated only with defined priorities.

You're right.

> You were mentioning SQL-based reports. If those give you trouble, you'll
> have no choice but to fix the SQL so that it works with the new values.

I would rather fix all my (open) tickets to have some sensible value.
Many people still uses SQL reports .

Of course I would be more than happy to have SQL reports disabled and
forward people always to query page from sql reports.

Remy Blank

unread,
Nov 6, 2008, 4:19:52 PM11/6/08
to trac-...@googlegroups.com
Jani Tiainen wrote:
> I would rather fix all my (open) tickets to have some sensible value.
> Many people still uses SQL reports .

Ah, I wasn't suggesting dropping SQL reports altogether. You would have
to edit the SQL for the reports that stopped working and fix it so that


it works with the new values.

Unfortunately, batch ticket editing is not yet integrated into Trac,
although there has been some work on that (there's an experimental
branch in the sandbox, but I have no idea of its status).

-- Remy

signature.asc
Reply all
Reply to author
Forward
0 new messages