ticket,summary,type,release,owner,status,created,modified,_description,_reporter
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"")",defect,0.12,,new,2011-12-17T16:39:48+01:00,2018-09-21T19:28:27+02:00,"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"")
}}}",laurynas.riliskis@…
10963,Milestone names with diacritics raise exceptions,defect,,,new,2013-03-21T23:29:19+01:00,2018-09-21T19:28:27+02:00,"This change solves the issue:
[https://github.com/filipefigcorreia/sumstatsplugin/commit/086ea407 086ea407]",Filipe Correia
10879,Change heuristic to determine the start date of a milestone,defect,,,new,2013-02-18T13:33:52+01:00,2018-09-21T19:28:27+02:00,"For the first milestone, consider the [http://trac-hacks.org/browser/sumstatsplugin/0.12/sumstats/web_ui.py#L260 start date] on the date of the first ticket of that miletone instead of the current date.",Filipe Correia
10899,Bug on query results,defect,,,new,2013-03-01T19:46:48+01:00,2018-09-21T19:28:27+02:00,"I think I've found a bug in Sumstats. 

I'm using !SumStats in conjunction with the track-backlog and [VisualizationPlugin#Burndownchartonmilestonepages VisualizationPlugin].

I've got a milestone (let's call it ""milestone1"") with some tickets, and when I call the `.../sumstats/query` URL I get the results I expected: http://pastie.org/6361592.

However, if I create a new milestone with a due date in the future, I start getting a ""zeroed"" response: http://pastie.org/6361594

Any idea of what might be happening? Might it be some misconception on my part of how it is supposed to work? 

Thanks.

",Filipe Correia