Templating Error

_sqlite.DatabaseError: ambiguous column name: rhs_.id

Debugging information follows

  1. In ('select _issue.id,rhs_._order,rhs_._username from _issue LEFT OUTER JOIN _priority as rhs_ on _issue._priority=rhs_.id LEFT OUTER JOIN _user as rhs_ on _issue._creator=rhs_.id where _issue.__retired__ <> 1 order by rhs_._order,rhs_._username', ())
  2. While evaluating the standard:'request/batch' expression on line 17
    Current variables:
    templates<roundup.cgi.templating.Templates instance at 0x00A9A558>
    repeat<roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0x00BCB878>
    false0
    context<HTMLClass(0xbcb710) issue>
    utils<roundup.cgi.templating.TemplatingUtils instance at 0x00BCB7B0>
    db<roundup.cgi.templating.HTMLDatabase instance at 0x00BCB760>
    nothingNone
    i18n<roundup.cgi.TranslationService.TranslationService instance at 0x00B3DA58>
    true1
    default<roundup.cgi.PageTemplates.TALES.Default instance at 0x0092F620>
    request<HTMLRequest FieldStorage(None, None, [MiniFieldStorage('@sort', 'creator'), MiniFieldStorage('@group', 'priority'), MiniFieldStorage('filter', 'status,assignedto'), MiniFieldStorage('@columns', 'id,activity,title,creator,status'), MiniFieldStorage('status', '-1,1,2,3,4,5,6')])>
    tracker<roundup.instance.Tracker instance at 0x00A6FB70>
    template<Roundup PageTemplate 'issue.index.html'>
    config<roundup.configuration.CoreConfig instance at 0x00A6F6C0>
    options{'ok_message': [], 'error_message': []}
    loop<roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0x00BCB878>
    attrs{'tal:define': 'batch request/batch', 'tal:condition': 'context/is_view_ok'}
  3. A problem occurred in your template "issue.index.html".
Full traceback:
Traceback (most recent call last):
  File "C:\Home\RoundupTest\roundup\cgi\client.py", line 720, in renderContext
    result = pt.render(self, None, None, **args)
  File "C:\Home\RoundupTest\roundup\cgi\templating.py", line 322, in render
    getEngine().getContext(c), output, tal=1, strictinsert=0)()
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 192, in __call__
    self.interpret(self.program)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 666, in do_useMacro
    self.interpret(macro)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 411, in do_optTag_tal
    self.do_optTag(stuff)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 396, in do_optTag
    return self.no_tag(start, program)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 391, in no_tag
    self.interpret(program)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 689, in do_defineSlot
    self.interpret(slot)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "C:\Home\RoundupTest\roundup\cgi\TAL\TALInterpreter.py", line 462, in do_setLocal_tal
    self.engine.setLocal(name, self.engine.evaluateValue(expr))
  File "C:\Home\RoundupTest\roundup\cgi\PageTemplates\TALES.py", line 227, in evaluate
    return expression(self)
  File "C:\Home\RoundupTest\roundup\cgi\PageTemplates\Expressions.py", line 194, in __call__
    return self._eval(econtext)
  File "C:\Home\RoundupTest\roundup\cgi\PageTemplates\Expressions.py", line 189, in _eval
    return render(ob, econtext.vars)
  File "C:\Home\RoundupTest\roundup\cgi\PageTemplates\Expressions.py", line 95, in render
    ob = ob()
  File "C:\Home\RoundupTest\roundup\cgi\templating.py", line 2342, in batch
    l = [id for id in klass.filter(matches, filterspec, sort, group)
  File "C:\Home\RoundupTest\roundup\backends\back_sqlite.py", line 353, in filter
    filterspec, sort=sort, group=group))
  File "C:\Home\RoundupTest\roundup\backends\rdbms_common.py", line 2215, in filter
    self.db.sql(sql, args)
  File "C:\Home\RoundupTest\roundup\backends\rdbms_common.py", line 139, in sql
    self.cursor.execute(sql)
  File "C:\Python24\Lib\site-packages\sqlite\main.py", line 244, in execute
    self.rs = self.con.db.execute(SQL)
DatabaseError: ambiguous column name: rhs_.id