id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
8343	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 ') and time_started >= 1292889600 and time_started < 1293556199' at line 1")	christer	rjollos	==== How to Reproduce ====\r\n\r\nWhile doing a GET operation on `/hours`, Trac issued an internal error.\r\n\r\n''(please provide additional details here)''\r\n\r\nRequest parameters:\r\n{{{\r\n{/trac/hours}\r\n}}}\r\n\r\nUser agent: `Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.12) Gecko/20101027 Fedora/3.6.12-1.fc13 Firefox/3.6.12`\r\n\r\n==== System Information ====\r\n|| '''`Trac`''' || `0.12` ||\r\n|| '''`Babel`''' || `0.9.5` ||\r\n|| '''`Docutils`''' || `0.6` ||\r\n|| '''`Genshi`''' || `0.6` ||\r\n|| '''`mod_wsgi`''' || `3.2 (WSGIProcessGroup  WSGIApplicationGroup %{GLOBAL})` ||\r\n|| '''`MySQL`''' || `server: "5.0.77-log", client: "5.1.52", thread-safe: 0` ||\r\n|| '''`MySQLdb`''' || `1.2.3c1` ||\r\n|| '''`Pygments`''' || `1.3.1` ||\r\n|| '''`Python`''' || `2.7 (r27:82500, Sep 16 2010, 18:02:00) ` [[br]] `[GCC 4.5.1 20100907 (Red Hat 4.5.1-3)]` ||\r\n|| '''`setuptools`''' || `0.6` ||\r\n|| '''`Subversion`''' || `1.6.13 (r1002816)` ||\r\n|| '''`jQuery`''' || `1.4.2` ||\r\n\r\n==== Enabled Plugins ====\r\n|| '''`TracHoursPlugin`''' || `0.5.2` ||\r\n\r\n==== Python Traceback ====\r\n{{{\r\nTraceback (most recent call last):\r\n  File "/usr/lib/python2.7/site-packages/Trac-0.12-py2.7.egg/trac/web/main.py", line 513, in _dispatch_request\r\n    dispatcher.dispatch(req)\r\n  File "/usr/lib/python2.7/site-packages/Trac-0.12-py2.7.egg/trac/web/main.py", line 235, in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "/usr/lib/python2.7/site-packages/TracHoursPlugin-0.5.2-py2.7.egg/trachours/hours.py", line 243, in process_request\r\n    return self.process_timeline(req)\r\n  File "/usr/lib/python2.7/site-packages/TracHoursPlugin-0.5.2-py2.7.egg/trachours/hours.py", line 518, in process_timeline\r\n    return self.display_html(req, query)\r\n  File "/usr/lib/python2.7/site-packages/TracHoursPlugin-0.5.2-py2.7.egg/trachours/hours.py", line 711, in display_html\r\n    time_records = self.get_ticket_hours(ticket_ids, from_date=from_date, to_date=to_date, worker_filter=data['cur_worker_filter'])\r\n  File "/usr/lib/python2.7/site-packages/TracHoursPlugin-0.5.2-py2.7.egg/trachours/hours.py", line 144, in get_ticket_hours\r\n    result = get_all_dict(self.env, sql, *args)\r\n  File "/usr/lib/python2.7/site-packages/TracSQLHelper-0.2.1-py2.7.egg/tracsqlhelper/__init__.py", line 51, in get_all_dict\r\n    desc, rows = get_all(env, sql, *params);\r\n  File "/usr/lib/python2.7/site-packages/TracSQLHelper-0.2.1-py2.7.egg/tracsqlhelper/__init__.py", line 23, in __call__\r\n    cur.execute(sql, params)\r\n  File "/usr/lib/python2.7/site-packages/Trac-0.12-py2.7.egg/trac/db/util.py", line 65, in execute\r\n    return self.cursor.execute(sql_escape_percent(sql), args)\r\n  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 173, in execute\r\n    self.errorhandler(self, exc, value)\r\n  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler\r\n    raise errorclass, errorvalue\r\nProgrammingError: (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 ') and time_started >= 1292889600 and time_started < 1293556199' at line 1")\r\n}}}	defect	closed	high	TracHoursPlugin	normal	fixed	mysql hours		0.12