id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
3207,Bug in SQL of Postgres BackendDB,valtoni.boaventura@…,dagomez,"Occurs when i call the plugin (i don't see any page yet):

Traceback (most recent call last):
{{{
  File ""/usr/local/lib/python2.5/site-packages/trac/web/main.py"", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File ""/usr/local/lib/python2.5/site-packages/trac/web/main.py"", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File ""build/bdist.linux-i686/egg/stractistics/web_ui.py"", line 116, in process_request
    db)
  File ""build/bdist.linux-i686/egg/stractistics/global_reports.py"", line 31, in global_reports
    weeks_back, db)
  File ""build/bdist.linux-i686/egg/stractistics/global_reports.py"", line 66, in _repository_activity
    revisions = _retrieve_revisions(authors, start_date, end_date, db)
  File ""build/bdist.linux-i686/egg/stractistics/global_reports.py"", line 140, in _retrieve_revisions
    revisions = execute_sql_expression(db, sql_expr, map_rows)
  File ""build/bdist.linux-i686/egg/stractistics/util.py"", line 117, in execute_sql_expression
    cursor.execute(sql_expr)
  File ""/usr/local/lib/python2.5/site-packages/trac/db/util.py"", line 51, in execute
    return self.cursor.execute(sql)
  File ""/usr/local/lib/python2.5/site-packages/trac/db/util.py"", line 51, in execute
    return self.cursor.execute(sql)
  File ""/usr/local/lib/python2.5/site-packages/pyPgSQL/PgSQL.py"", line 3111, in execute
    raise OperationalError, msg
OperationalError: ERROR:  syntax error at or near "")""
LINE 4: ...e > 1206528374 AND r.time < 1213785974 AND r.author IN (  ) 
}}}",defect,new,highest,StractisticsPlugin,normal,,,,0.10