Templating Error

psycopg.ProgrammingError: ERROR: invalid input syntax for integer: "12345a" select _activity,_actor,_creation,_creator,_name,_order from _priority where id='12345a'

Debugging information follows

  1. While evaluating the standard:'context/priority/field' expression on line 46
    Current variables:
    templates<roundup.cgi.templating.Templates instance at 0x40d7006c>
    repeat<roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0x40e009ec>
    false0
    context<HTMLClass(0x40e0032c) issue>
    utils<roundup.cgi.templating.TemplatingUtils instance at 0x40e003ec>
    db<roundup.cgi.templating.HTMLDatabase instance at 0x40e002ec>
    nothingNone
    i18n<roundup.cgi.TranslationService.TranslationService instance at 0x40df26cc>
    true1
    default<roundup.cgi.PageTemplates.TALES.Default instance at 0x407a3f4c>
    request<HTMLRequest FieldStorage(None, None, [FieldStorage('title', None, 'TEST'), FieldStorage('priority', None, '12345a'), FieldStorage('status', None, '-1'), FieldStorage('superseder', None, ''), FieldStorage('nosy', None, ''), FieldStorage('assignedto', None, '-1'), FieldStorage('topic', None, ''), FieldStorage('@note', None, 'TEST'), FieldStorage('@file', '', ''), FieldStorage('@template', None, 'item'), FieldStorage('@required', None, 'title,priority'), FieldStorage('@action', None, 'new'), FieldStorage('submit', None, 'Submit New Entry')])>
    tracker<roundup.instance.Tracker instance at 0x407f844c>
    template<Roundup PageTemplate 'issue.item.html'>
    config<roundup.configuration.CoreConfig instance at 0x40d4d74c>
    options{'ok_message': [], 'error_message': ["Error: property priority: '12345a' is not a priority."]}
    loop<roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0x40e009ec>
    attrs{'tal:replace': 'structure context/priority/field'}
  2. A problem occurred in your template "issue.item.html".
Full traceback:
Traceback (most recent call last):
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/client.py", line 729, in renderContext
    result = pt.render(self, None, None, **args)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/templating.py", line 322, in render
    getEngine().getContext(c), output, tal=1, strictinsert=0)()
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 192, in __call__
    self.interpret(self.program)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 666, in do_useMacro
    self.interpret(macro)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 411, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 396, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 391, in no_tag
    self.interpret(program)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 689, in do_defineSlot
    self.interpret(slot)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 632, in do_condition
    self.interpret(block)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 564, in do_insertStructure_tal
    structure = self.engine.evaluateStructure(expr)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/PageTemplates/TALES.py", line 227, in evaluate
    return expression(self)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 194, in __call__
    return self._eval(econtext)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 189, in _eval
    return render(ob, econtext.vars)
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 95, in render
    ob = ob()
  File "/usr/local/lib/python2.4/site-packages/roundup/cgi/templating.py", line 1710, in field
    value = linkcl.get(self._value, k)
  File "/usr/local/lib/python2.4/site-packages/roundup/backends/rdbms_common.py", line 1453, in get
    d = self.db.getnode(self.classname, nodeid)
  File "/usr/local/lib/python2.4/site-packages/roundup/backends/rdbms_common.py", line 945, in getnode
    self.sql(sql, (nodeid,))
  File "/usr/local/lib/python2.4/site-packages/roundup/backends/rdbms_common.py", line 153, in sql
    self.cursor.execute(sql, args)
ProgrammingError: ERROR:  invalid input syntax for integer: "12345a"

select _activity,_actor,_creation,_creator,_name,_order from _priority where id='12345a'