I am testing the default tracker with sqlite as
database back-end. Trying to group on topic on the
"List of issues" page causes an error. The traceback is
shown below (roundup 0.6.8.). Using the search page I
can sort or group on topics without problems.

Regards,
David

----

_sqlite.DatabaseError: no such column: _topic

Debugging information follows

   1. While evaluating the standard:'request/batch'
expression on line 15
      Current variables:
      templates    <roundup.cgi.templating.Templates
instance at 0x00EEAAD0>
      repeat   
<roundup.cgi.PageTemplates.TALES.SafeMapping instance
at 0x00EEABC0>
      default   
<roundup.cgi.PageTemplates.TALES.Default instance at
0x00EC1508>
      db    <roundup.cgi.templating.HTMLDatabase
instance at 0x00EEAA58>
      utils    <roundup.cgi.templating.utils instance
at 0x00EEAAA8>
      request    <roundup.cgi.templating.HTMLRequest
instance at 0x00DEFD00>
      tracker    <module '_roundup_tracker_1' from
'c:/home/roundup/universal\__init__.pyc'>
      context    <HTMLClass(0xeeaa80) issue>
      nothing    None
      config    <module '_roundup_tracker_1.config'
from 'c:/home/roundup/universal\config.pyc'>
      options    {'ok_message': [], 'error_message': []}
      loop   
<roundup.cgi.PageTemplates.TALES.SafeMapping instance
at 0x00EEABC0>
      attrs    {'tal:define': 'batch request/batch',
'tal:condition': 'context/is_view_ok'}
   2. A problem occurred in your template
"issue.index.html".

Full traceback:

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

Logged In: YES 
user_id=6405

This is a known bug and is fixed in 0.7