"Tickets active in the last 10 days" page does not work

[Zverikk]

The following reports do not work as of now:

• ​http://josm.openstreetmap.de/report/3
• ​http://josm.openstreetmap.de/report/6
• ​http://josm.openstreetmap.de/report/7
• ​http://josm.openstreetmap.de/report/10
• ​http://josm.openstreetmap.de/report/13

[stoecker]

Report 10 fixed.

[stoecker]

3,6,7 fix. Have no idea yet how to fix 13.

[simon04]

Concerning number 13, this Stack Overflow answer might be helpful: ​http://stackoverflow.com/a/12693353/205629, i.e., drop the DISTINCT keyword (is this needed?) or add the ORDER BY clauses to the SELECT clauses.

Since I don't have a Trac installation, I cannot test the query on my own …

[stoecker]

Ok. 13 seems fixed as well. Could please someone who is not involved in nearly all tickets check if results are correct ;-)

[akks]

Replying to stoecker:

Ok. 13 seems fixed as well. Could please someone who is not involved in nearly all tickets check if results are correct ;-)

I am involved only in 192 tickets. It works OK :)

[skyper]

report/8 needs some fine-tuning as #8340 should not be listed.

[skyper]

Replying to skyper:

report/8 needs some fine-tuning as #8340 should not be listed.

/query?status=assigned&status=needinfo&status=new&status=reopened&summary=~[Patch&summary=~[patch&summary=~[PATCH&col=id&col=summary&col=status&col=type&col=priority&col=component&col=version&report=8&desc=1&order=id should work.

[stoecker]

Change the ticket text instead.