Templating Error

psycopg.ProgrammingError: ERROR: Table name "_priority" specified more than once select _issue.id,_priority._order,_priority._order from _issue,_priority,_priority where _issue.__retired__ <> 1 and _issue._priority = _priority.id and _issue._priority = _priority.id order by _priority._order,_priority._order desc

Debugging information follows

  1. In ('select _issue.id,_priority._order,_priority._order from _issue,_priority,_priority where _issue.__retired__ <> 1 and _issue._priority = _priority.id and _issue._priority = _priority.id order by _priority._order,_priority._order desc', ())
  2. While evaluating the standard:'request/batch' expression on line 13
    Current variables:
    templates <roundup.cgi.templating.Templates instance at 0x4063b22c>
    repeat <roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0x4065830c>
    template <Roundup PageTemplate 'issue.index.html'>
    default <roundup.cgi.PageTemplates.TALES.Default instance at 0x40628acc>
    db <roundup.cgi.templating.HTMLDatabase instance at 0x4063b1ac>
    utils <roundup.cgi.templating.utils instance at 0x4063b20c>
    request <roundup.cgi.templating.HTMLRequest instance at 0x40300f4c>
    tracker <module '_roundup_tracker_1' from '/usr/local/roundup/trackers/arch/__init__.pyc'>
    context <HTMLClass(0x40656e4c) issue>
    nothing None
    config <module '_roundup_tracker_1.config' from '/usr/local/roundup/trackers/arch/config.py'>
    options {'ok_message': [], 'error_message': []}
    loop <roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0x4065830c>
    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 "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/client.py", line 519, in renderContext
    result = pt.render(self, None, None, **args)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/templating.py", line 245, in render
    getEngine().getContext(c), output, tal=1, strictinsert=0)()
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 154, in __call__
    self.interpret(self.program)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 186, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 525, in do_useMacro
    self.interpret(macro)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 186, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 345, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 330, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 325, in no_tag
    self.interpret(program)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 186, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 549, in do_defineSlot
    self.interpret(slot)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 186, in interpret
    handlers[opcode](self, args)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 402, in do_setLocal_tal
    self.engine.setLocal(name, self.engine.evaluateValue(expr))
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/PageTemplates/TALES.py", line 226, in evaluate
    v = expression(self)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 189, in __call__
    return self._eval(econtext)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 184, in _eval
    return render(ob, econtext.vars)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 90, in render
    ob = ob()
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/cgi/templating.py", line 2027, in batch
    l = klass.filter(matches, filterspec, sort, group)
  File "/usr/local/ActivePython-2.3/lib/python2.3/site-packages/roundup/backends/rdbms_common.py", line 2199, in filter
    self.db.cursor.execute(sql)
ProgrammingError: ERROR:  Table name "_priority" specified more than once

select _issue.id,_priority._order,_priority._order from _issue,_priority,_priority  where _issue.__retired__ <> 1 and _issue._priority = _priority.id and _issue._priority = _priority.id order by _priority._order,_priority._order desc