ticket,summary,type,release,owner,status,created,modified,_description,_reporter
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
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
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
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@…