Roundup Tracker - Issues

Issue 666615

classification
Searching for Id broken in 0.5.4
Type: Severity: normal
Components: Database Versions:
process
Status: closed fixed
:
: richard : indenbir, richard
Priority: normal :

Created on 2003-01-12 11:34 by indenbir, last changed 2003-01-12 11:34 by indenbir.

Messages
msg585 Author: [hidden] (indenbir) Date: 2003-01-12 11:34
Searching for an Id from the Web Interface doesn't work.

I'm using sqlite and the classic template. The bug can
be reproduced with the unchanged templates from the
distribution.

Obviously, the SQL statement or the db schema is broken
(there is no column _id in _issue):

select id from _issue  where (_priority in (%s)) and
_id LIKE '%%1%%' ('1',)

Here's the debug info 

Templating Error

Debugging information follows

   1. While evaluating the standard:'request/batch'
expression on line 13
      Current variables:
      templates <roundup.cgi.templating.Templates
instance at 0x8543544>
      repeat
<roundup.cgi.PageTemplates.TALES.SafeMapping instance
at 0x85471e4>
      default <roundup.cgi.PageTemplates.TALES.Default
instance at 0x8306144>
      db <roundup.cgi.templating.HTMLDatabase instance
at 0x83d6064>
      utils <roundup.cgi.templating.utils instance at
0x83c4ccc>
      request <roundup.cgi.templating.HTMLRequest
instance at 0x834222c>
      tracker <module '_roundup_tracker_1' from
'/home/idb/Daten/Prog/trackers/test1/__init__.pyo'>
      context <HTMLClass(0x835228c) issue>
      nothing None
      config <module '_roundup_tracker_1.config' from
'/home/idb/Daten/Prog/trackers/test1/config.pyo'>
      options {'ok_message': [], 'error_message': []}
      loop <roundup.cgi.PageTemplates.TALES.SafeMapping
instance at 0x85471e4>
      attrs {'tal:define': 'batch request/batch',
'tal:condition': 'context/is_view_ok'}
   2. A problem occurred in your template "issue.index".

Full traceback:

Traceback (most recent call last):
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/client.py",
line 368, in renderContext
    return pt.render(self, None, None, **args)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/templating.py",
line 187, in render
    getEngine().getContext(c), output, tal=1,
strictinsert=0)()
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 154, in __call__
    self.interpret(self.program)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 186, in interpret
    handlers[opcode](self, args)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 525, in do_useMacro
    self.interpret(macro)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 186, in interpret
    handlers[opcode](self, args)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 549, in do_defineSlot
    self.interpret(slot)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 186, in interpret
    handlers[opcode](self, args)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py",
line 402, in do_setLocal_tal
    self.engine.setLocal(name,
self.engine.evaluateValue(expr))
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/TALES.py",
line 225, in evaluate
    v = expression(self)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/Expressions.py",
line 188, in __call__
    return self._eval(econtext)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/Expressions.py",
line 183, in _eval
    return render(ob, econtext.vars)
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/Expressions.py",
line 89, in render
    ob = ob()
  File
"/usr/lib/python2.2/site-packages/roundup/cgi/templating.py",
line 1539, in batch
    l = klass.filter(matches, filterspec, sort, group)
  File
"/usr/lib/python2.2/site-packages/roundup/backends/rdbms_common.py",
line 1877, in filter
    self.db.cursor.execute(sql, args)
  File
"/usr/lib/python2.2/site-packages/sqlite/main.py", line
316, in execute
    self.rs = self.con.db.execute(SQL % parms)
DatabaseError: no such column: _id

 
History
Date User Action Args
2003-01-12 11:34:44indenbircreate