[MacPorts] #42896: Could not sort tickets by status

[MacPorts]

#42896: Could not sort tickets by status
-----------------------------+-------------------------
  Reporter:  xeron.oskom@…   |      Owner:  wsiegrist@…
      Type:  defect          |     Status:  new
  Priority:  Normal          |  Milestone:
 Component:  server/hosting  |    Version:
Resolution:                  |   Keywords:
      Port:                  |
-----------------------------+-------------------------
Description changed by ryandesign@…:

Old description:

> Trac web interface shows error when I'm trying to sort tickets by status:
>
> {{{
> Report execution failed:
> ORDER BY "status" is ambiguous LINE 10: ...lue, milestone, severity, time
> ) AS tab ORDER BY "status" A... ^
> }}}
>
> Example link: https://trac.macports.org/report/9?sort=status&asc=1
>
> Sorting by any other field works:
> https://trac.macports.org/report/9?sort=ticket&asc=1
>
> Also status field shown 2 times. May be related.

New description:

 Trac web interface shows error when I'm trying to sort tickets by status:

 {{{
 Report execution failed:
 ORDER BY "status" is ambiguous LINE 10: ...lue, milestone, severity, time
 ) AS tab ORDER BY "status" A... ^
 }}}

 Example link: report:9?sort=status&asc=1

 Sorting by any other field works: report:9?sort=ticket&asc=1

 Also status field shown 2 times. May be related.

--

-- 
Ticket URL: <https://trac.macports.org/ticket/42896#comment:2>
MacPorts <http://www.macports.org/>
Ports system for OS X