Opened 16 years ago
Last modified 7 years ago
#3207 closed defect
Bug in SQL of Postgres BackendDB — at Initial Version
| Reported by: | Owned by: | dagomez | |
|---|---|---|---|
| Priority: | highest | Component: | StractisticsPlugin |
| Severity: | normal | Keywords: | |
| Cc: | Trac Release: | 0.10 |
Description
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 ( )
