id summary reporter owner description type status priority component severity resolution keywords cc release 11433 "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 '== 'status' \n ORDER BY tc.time' at line 4"")" Zinway Ryan J Ollos "==== How to Reproduce ==== While doing a GET operation on `/ticketstats`, Trac issued an internal error. ''(please provide additional details here)'' Request parameters: {{{ {} }}} User agent: `Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1712.4 Safari/537.36` ==== System Information ==== || '''`Trac`''' || `1.0.1` || || '''`Trac`''' || `1.0.1` || || '''`Babel`''' || `0.9.4` || || '''`Docutils`''' || `0.6` || || '''`Genshi`''' || `0.6 (without speedups)` || || '''`mod_wsgi`''' || `3.4 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})` || || '''`MySQL`''' || `server: ""5.1.71"", client: ""5.1.71"", thread-safe: 1` || || '''`MySQLdb`''' || `1.2.3c1` || || '''`Pygments`''' || `1.4` || || '''`Python`''' || `2.6.6 (r266:84292, Nov 22 2013, 12:16:22) ` [[br]] `[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)]` || || '''`Python`''' || `2.6.6 (r266:84292, Nov 22 2013, 12:16:22) ` [[br]] `[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)]` || || '''`pytz`''' || `2010h` || || '''`pytz`''' || `2010h` || || '''`setuptools`''' || `0.6` || || '''`setuptools`''' || `0.6` || || '''`Subversion`''' || `1.7.4 (r1295709)` || || '''`jQuery`''' || `1.7.2` || ==== Enabled Plugins ==== || '''`AutocompleteUsers`''' || `0.4.2dev-r0` || || '''`CKIntegration`''' || `1.1dev` || || '''`GridModify`''' || `0.1.6dev-r0` || || '''`IniAdmin`''' || `0.3-r0` || || '''`LoomingClouds`''' || `0.12r1` || || '''`TicketCalendarPlugin`''' || `0.12.0.2` || || '''`TracAccountManager`''' || `0.5dev-r0` || || '''`TracAnnouncer`''' || `1.0dev-r0` || || '''`TracCAS`''' || `2.0.1` || || '''`TracCustomFieldAdmin`''' || `0.2.8-r0` || || '''`TracDragDrop`''' || `0.12.0.11-r0` || || '''`TracPermRedirect`''' || `3.0` || || '''`TracSubcomponents`''' || `1.2.0` || || '''`TracTags`''' || `0.6` || || '''`TracTicketCharts`''' || `0.2dev-r0` || || '''`Tracticketstats`''' || `3.0.0dev-r0` || || '''`TracUserManagerPlugin`''' || `0.5dev-r0` || || '''`TracWorkflowAdmin`''' || `0.12.0.2` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/web/main.py"", line 497, in _dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/web/main.py"", line 214, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.6/site-packages/Tracticketstats-3.0.0dev_r0-py2.6.egg/ticketstats/ticketstats.py"", line 119, in process_request last_num_open = get_num_open_tix(db, last_date, milestone) File ""/usr/lib/python2.6/site-packages/Tracticketstats-3.0.0dev_r0-py2.6.egg/ticketstats/ticketstats.py"", line 237, in get_num_open_tix ORDER BY tc.time"""""" % milestone_str, args) File ""/usr/lib/python2.6/site-packages/Trac-1.0.1-py2.6.egg/trac/db/util.py"", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) File ""/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py"", line 173, in execute self.errorhandler(self, exc, value) File ""/usr/lib64/python2.6/site-packages/MySQLdb/connections.py"", line 36, in defaulterrorhandler raise errorclass, errorvalue 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 '== 'status' \n ORDER BY tc.time' at line 4"") }}}" defect closed normal TracTicketStatsPlugin normal fixed tuhui@… 1.0