id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
3207	Bug in SQL of Postgres BackendDB	valtoni.boaventura@prodepa.pa.gov.br	rjollos	Occurs when i call the plugin (i don't see any page yet):\r\n\r\nTraceback (most recent call last):\r\n{{{\r\n  File "/usr/local/lib/python2.5/site-packages/trac/web/main.py", line 406, in dispatch_request\r\n    dispatcher.dispatch(req)\r\n  File "/usr/local/lib/python2.5/site-packages/trac/web/main.py", line 237, in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "build/bdist.linux-i686/egg/stractistics/web_ui.py", line 116, in process_request\r\n    db)\r\n  File "build/bdist.linux-i686/egg/stractistics/global_reports.py", line 31, in global_reports\r\n    weeks_back, db)\r\n  File "build/bdist.linux-i686/egg/stractistics/global_reports.py", line 66, in _repository_activity\r\n    revisions = _retrieve_revisions(authors, start_date, end_date, db)\r\n  File "build/bdist.linux-i686/egg/stractistics/global_reports.py", line 140, in _retrieve_revisions\r\n    revisions = execute_sql_expression(db, sql_expr, map_rows)\r\n  File "build/bdist.linux-i686/egg/stractistics/util.py", line 117, in execute_sql_expression\r\n    cursor.execute(sql_expr)\r\n  File "/usr/local/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute\r\n    return self.cursor.execute(sql)\r\n  File "/usr/local/lib/python2.5/site-packages/trac/db/util.py", line 51, in execute\r\n    return self.cursor.execute(sql)\r\n  File "/usr/local/lib/python2.5/site-packages/pyPgSQL/PgSQL.py", line 3111, in execute\r\n    raise OperationalError, msg\r\nOperationalError: ERROR:  syntax error at or near ")"\r\nLINE 4: ...e > 1206528374 AND r.time < 1213785974 AND r.author IN (  ) \r\n}}}	defect	new	highest	StractisticsPlugin	normal				0.10