Templating Error

psycopg.ProgrammingError: ERROR: value "20030921115726" is out of range for type integer select count(*) from _file where id='20030921115726'

Debugging information follows

  1. While evaluating the standard:'msg/content/hyperlinked' expression on line 186
    Current variables:
    templates<roundup.cgi.templating.Templates instance at 0xa918d66c>
    repeat<roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0xa937b4ac>
    false0
    context<HTMLItem(0x-56c84f34) issue 220>
    utils<roundup.cgi.templating.TemplatingUtils instance at 0xa937bb2c>
    db<roundup.cgi.templating.HTMLDatabase instance at 0xa937b24c>
    nothingNone
    i18n<roundup.cgi.TranslationService.TranslationService instance at 0xa93af30c>
    true1
    default<roundup.cgi.PageTemplates.TALES.Default instance at 0xa9dcf2cc>
    request<HTMLRequest FieldStorage(None, None, [])>
    tracker<roundup.instance.Tracker instance at 0xa9189dcc>
    template<Roundup PageTemplate 'issue.item.html'>
    config<roundup.configuration.CoreConfig instance at 0xa918910c>
    options{'ok_message': [], 'error_message': []}
    loop<roundup.cgi.PageTemplates.TALES.SafeMapping instance at 0xa937b4ac>
    status_notresolved'-1,1,2,3,4,5,6'
    columns_showall'id,creation,title,status'
    columns_topic'id,activity,title,creator,assignedto,priority'
    kw_edit0
    msg<HTMLItem(0x-56e03154) msg 816>
    attrs{'tal:content': 'structure msg/content/hyperlinked'}
    kw_edit_link0
    columns_search'id,activity,title,creator,assignedto,status'
    kw_create0
    columns'id,activity,title,creator,status'
  2. A problem occurred in your template "issue.item.html".
Full traceback:
Traceback (most recent call last):
  File "/usr/local/src/roundup/roundup/cgi/client.py", line 730, in renderContext
    result = pt.render(self, None, None, **args)
  File "/usr/local/src/roundup/roundup/cgi/templating.py", line 323, in render
    getEngine().getContext(c), output, tal=1, strictinsert=0)()
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 192, in __call__
    self.interpret(self.program)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 666, in do_useMacro
    self.interpret(macro)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 411, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 396, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 391, in no_tag
    self.interpret(program)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 689, in do_defineSlot
    self.interpret(slot)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 632, in do_condition
    self.interpret(block)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 632, in do_condition
    self.interpret(block)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 608, in do_loop_tal
    self.interpret(block)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 411, in do_optTag_tal
    self.do_optTag(stuff)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 396, in do_optTag
    return self.no_tag(start, program)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 391, in no_tag
    self.interpret(program)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 236, in interpret
    handlers[opcode](self, args)
  File "/usr/local/src/roundup/roundup/cgi/TAL/TALInterpreter.py", line 564, in do_insertStructure_tal
    structure = self.engine.evaluateStructure(expr)
  File "/usr/local/src/roundup/roundup/cgi/PageTemplates/TALES.py", line 227, in evaluate
    return expression(self)
  File "/usr/local/src/roundup/roundup/cgi/PageTemplates/Expressions.py", line 194, in __call__
    return self._eval(econtext)
  File "/usr/local/src/roundup/roundup/cgi/PageTemplates/Expressions.py", line 189, in _eval
    return render(ob, econtext.vars)
  File "/usr/local/src/roundup/roundup/cgi/PageTemplates/Expressions.py", line 95, in render
    ob = ob()
  File "/usr/local/src/roundup/roundup/cgi/templating.py", line 1257, in hyperlinked
    return self.plain(hyperlink=1)
  File "/usr/local/src/roundup/roundup/cgi/templating.py", line 1279, in plain
    s = self.hyper_re.sub(self._hyper_repl, s)
  File "/usr/local/src/roundup/roundup/cgi/templating.py", line 1249, in _hyper_repl
    if not cl.hasnode(s2):
  File "/usr/local/src/roundup/roundup/backends/rdbms_common.py", line 1843, in hasnode
    return self.db.hasnode(self.classname, nodeid)
  File "/usr/local/src/roundup/roundup/backends/rdbms_common.py", line 1031, in hasnode
    self.sql(sql, (nodeid,))
  File "/usr/local/src/roundup/roundup/backends/rdbms_common.py", line 154, in sql
    self.cursor.execute(sql, args)
ProgrammingError: ERROR:  value "20030921115726" is out of range for type integer

select count(*) from _file where id='20030921115726'