id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release 9622,"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 ')' at line 1"")",laurynas.riliskis@…,,"The error occurend then I selected to list completed milestones ==== How to Reproduce ==== While doing a GET operation on `/roadmap`, Trac issued an internal error. ''(please provide additional details here)'' Request parameters: {{{ {'show': u'completed'} }}} User agent: `Mozilla/5.0 (Ubuntu; X11; Linux x86_64; rv:8.0) Gecko/20100101 Firefox/8.0` ==== System Information ==== || '''`Trac`''' || `0.13dev-r10883` || || '''`Babel`''' || `0.9.4` || || '''`Docutils`''' || `0.6` || || '''`Genshi`''' || `0.6` || || '''`mod_wsgi`''' || `3.2 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})` || || '''`MySQL`''' || `server: ""5.1.52"", client: ""5.1.52"", thread-safe: 0` || || '''`MySQLdb`''' || `1.2.3c1` || || '''`Pygments`''' || `1.1.1` || || '''`Python`''' || `2.6.5 (r265:79063, Jun 25 2011, 08:36:25) ` [[br]] `[GCC 4.4.4 20100726 (Red Hat 4.4.4-13)]` || || '''`setuptools`''' || `0.6` || || '''`Subversion`''' || `1.6.11 (r934486)` || || '''`jQuery`''' || `1.5.1` || ==== Enabled Plugins ==== || '''`NavAdd`''' || `0.1` || || '''`Trac-jsGantt`''' || `0.9-r10876` || || '''`TracAccountManager`''' || `0.3.2` || || '''`TracListOfWikiPagesMacro`''' || `0.4` || || '''`TracSumStats`''' || `0.9.0` || || '''`WikiTableMacro`''' || `0.1-r10442` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""/usr/lib/python2.6/site-packages/Trac-0.13dev_r10883-py2.6.egg/trac/web/main.py"", line 478, in _dispatch_request dispatcher.dispatch(req) File ""/usr/lib/python2.6/site-packages/Trac-0.13dev_r10883-py2.6.egg/trac/web/main.py"", line 198, in dispatch resp = chosen_handler.process_request(req) File ""/usr/lib/python2.6/site-packages/Trac-0.13dev_r10883-py2.6.egg/trac/ticket/roadmap.py"", line 436, in process_request stat = get_ticket_stats(self.stats_provider, tickets) File ""/usr/lib/python2.6/site-packages/Trac-0.13dev_r10883-py2.6.egg/trac/ticket/roadmap.py"", line 293, in get_ticket_stats return provider.get_ticket_group_stats([t['id'] for t in tickets]) File ""/usr/lib/python2.6/site-packages/TracSumStats-0.9.0-py2.6.egg/sumstats/web_ui.py"", line 133, in get_ticket_group_stats for group in self._get_groups(ticket_ids): File ""/usr/lib/python2.6/site-packages/TracSumStats-0.9.0-py2.6.egg/sumstats/web_ui.py"", line 32, in _get_groups self._update_group(group, ticket_ids) File ""/usr/lib/python2.6/site-packages/TracSumStats-0.9.0-py2.6.egg/sumstats/web_ui.py"", line 45, in _update_group group['total'] = self._get_total(group, field, ticket_ids) File ""/usr/lib/python2.6/site-packages/TracSumStats-0.9.0-py2.6.egg/sumstats/web_ui.py"", line 124, in _get_total cursor.execute(query) File ""/usr/lib/python2.6/site-packages/Trac-0.13dev_r10883-py2.6.egg/trac/db/util.py"", line 66, in execute return self.cursor.execute(sql) 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 ')' at line 1"") }}}",defect,new,normal,SumStatsPlugin,normal,,database api string interpolation,,0.12