Templating Error

   _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL
   syntax. Check the manual that corresponds to your MySQL server version for
   the right syntax to use near ')' at line 1")

   Debugging information follows

    1. While evaluating the standard:'request/batch' expression on line 13

                                 Current variables:
       templates <roundup.cgi.templating.Templates instance at 0x836d374>     
       repeat    <roundup.cgi.PageTemplates.TALES.SafeMapping instance at     
                 0x83e9ce4>                                                   
       template  <Roundup PageTemplate 'issue.index.html'>                    
       default   <roundup.cgi.PageTemplates.TALES.Default instance at         
                 0x8200b2c>                                                   
       db        <roundup.cgi.templating.HTMLDatabase instance at 0x843a6bc>  
       utils     <roundup.cgi.templating.utils instance at 0x836d1d4>         
       request   <roundup.cgi.templating.HTMLRequest instance at 0x83fe86c>   
       tracker   <module '_roundup_tracker_1' from                            
                 '/var/lib/roundup/tracker/__init__.pyo'>                     
       context   <HTMLClass(0x836cee4) issue>                                 
       nothing   None                                                         
       config    <module '_roundup_tracker_1.config' from                     
                 '/var/lib/roundup/tracker/config.pyo'>                       
       options   {'ok_message': [], 'error_message': []}                      
       loop      <roundup.cgi.PageTemplates.TALES.SafeMapping instance at     
                 0x83e9ce4>                                                   
       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 "/usr/lib/python2.2/site-packages/roundup/cgi/client.py", line 527, in renderContext                                                                                      
    result = pt.render(self, None, None, **args)                                                                                                                                 
  File "/usr/lib/python2.2/site-packages/roundup/cgi/templating.py", line 246, 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 345, in do_optTag_tal                                                                          
    self.do_optTag(stuff)                                                                                                                                                        
  File "/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 330, in do_optTag                                                                              
    return self.no_tag(start, program)                                                                                                                                           
  File "/usr/lib/python2.2/site-packages/roundup/cgi/TAL/TALInterpreter.py", line 325, in no_tag                                                                                 
    self.interpret(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 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 226, in evaluate                                                                              
    v = expression(self)                                                                                                                                                         
  File "/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 189, in __call__                                                                        
    return self._eval(econtext)                                                                                                                                                  
  File "/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 184, in _eval                                                                           
    return render(ob, econtext.vars)                                                                                                                                             
  File "/usr/lib/python2.2/site-packages/roundup/cgi/PageTemplates/Expressions.py", line 90, in render                                                                           
    ob = ob()                                                                                                                                                                    
  File "/usr/lib/python2.2/site-packages/roundup/cgi/templating.py", line 2033, in batch                                                                                         
    filterspec = self.filterspec                                                                                                                                                 
  File "/usr/lib/python2.2/site-packages/roundup/backends/indexer_dbm.py", line 148, in search                                                                                   
    hits = self.find(search_terms)                                                                                                                                               
  File "/usr/lib/python2.2/site-packages/roundup/backends/indexer_rdbms.py", line 81, in find                                                                                    
    self.db.cursor.execute(sql, tuple(l))                                                                                                                                        
  File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 66, in execute                                                                                                
    r = self._query(query % self.__conn.literal(args))                                                                                                                           
  File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 168, in _query                                                                                                
    rowcount = self._BaseCursor__do_query(q)                                                                                                                                     
  File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 112, in __do_query                                                                                            
    db.query(q)                                                                                                                                                                  
ProgrammingError: (1064, "You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1")