Ambiguous selection of field

[anonymous]

I did a custom report and I grouped records by 'milestone' .Then I clicked on a column to sort by it (in this case it is called severity). I got this error:

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 379, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 230, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/ticket/query.py", line 443, in process_request
    self.display_html(req, query)
  File "/usr/lib/python2.4/site-packages/trac/ticket/query.py", line 552, in display_html
    tickets = query.execute(req, db)
  File "/usr/lib/python2.4/site-packages/trac/ticket/query.py", line 158, in execute
    cursor.execute(sql, args)
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 47, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: ambiguous column name: severity.value

[Emmanuel Blot]

Can you provide the custom report source, as well as the Trac version you're using ? TIA.

[sid]

Closing due to lack of followup from the original reporter. It is not possible to debug this issue without the report SQL. Please reopen if you can provide that information. Thanks.