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