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