ticket,summary,type,release,owner,status,created,modified,_description,_reporter
10916,No Wiki activity shown,defect,1.0,,new,2013-03-08T11:46:05+01:00,2020-05-06T02:05:20+02:00,"The Stractistic page does not show the data for wiki activity. I can see the graph and table but there is no data in it even if I edit/create a wiki page. If the mouse is over the graph a ""tooltip"" whith the value '''undefined''' is shown.

Other plugins I've installed:
 - !TracAccountManager
 - !TracKanbanBoard
 - !TracSubTickets
 - !WorkflowEditor",anonymous
8780,Commit history not showing with bazaar repository,defect,0.11,,new,2011-05-10T08:55:23+02:00,2020-05-06T02:05:20+02:00,"Currently using the bazaar repository for source code.
And I would like to use this plugin also.
If you look at the screen shot it's not able to count commits.",jpcurrey@…
6923,[Patch] Trac 0.12 compatibility,enhancement,0.12,,new,2010-04-03T17:46:25+02:00,2020-05-06T02:05:20+02:00,"This is a patch to get the !StractisticsPlugin working with trac 0.12.
It fixes the time stuff for the [http://trac.edgewall.org/changeset/9210 microsecond timestamp feature] in trac 0.12.

have fun

best regards

Mario",Mario
5666,Destroyed Menu with combined MenusPlugin,defect,0.11,,new,2009-08-12T16:14:46+02:00,2020-05-06T02:05:20+02:00,"Due to the many used plugins the mainnav got longer and longer...
so we decided to install the MenusPlugin. Therefore we disabled some entrys like Blog and included them into own Entrys like TeamTools where Blog and Discussion are included.

When we installed the StractisticsPlugin we also disabled the main entry and included the stats into our parent ticket-entry.
until here everything works fine.

but if i click on the stats, all disabled entrys disapeared... so that i just have ""  * Timeline * Roadmap * Browse Repository * View Reports"". 
Thats pitty because the Stractistics plugin is really nice, but we won't click the 'back'-button of my browser everytime...

ps: here an extract of my mainnav-section:

{{{
blog = disabled
discussion = disabled
tools = enabled
tools.hide_if_no_children = true
tools.label = Team Tools
tools.href = /blog
tools.order = 60
tools.parent = top
tool_blog = enabled
tool_blog.href = /blog
tool_blog.label = Blog
tool_blog.order = 1
tool_blog.parent = tools
tool_blog.perm = BLOG_VIEW
tool_discussion = enabled
tool_discussion.href = /discussion
tool_discussion.label = Discussion
tool_discussion.order = 2
tool_discussion.parent = tools
tool_discussion.perm = DISCUSSION_VIEW

}}}


is there any way to see all of my custom mainnav?

",webmaster@…
3917,Custom stylesheet and header is ignored by Stractistics Plugin,defect,0.11,,new,2008-10-16T13:10:39+02:00,2020-05-06T02:05:20+02:00,"I have an installation of Trac and I have created a custom stylesheet which is pulled in by the site.html file. I also include a custom header which is a navigation bar. This all works fine for other plugins such as the blog, tags, etc, but the Stractistics plugin seems to revert to the basic stylesheet and page layout.

To test this try modifying the site.html file in the trac environment, or alternatively install the NavControl plugin that allows you to hide or rename buttons. Then click on Stractistics and you'll see that the buttons change back to the default.",anonymous
3518,Commits per month,enhancement,0.11,,new,2008-08-07T21:01:03+02:00,2020-05-06T02:05:20+02:00,"When trying to see a chart for a long period of time, the lines tend to be have a lot of ""spikes"", which makes the chart difficult to read.

I think it would be tremendously useful to be able to configure the X axis, and aggregate date by month, trimester, semester, etc. Some precision will be lost this way, but I believe the chart will become much more readable in some situations.",filipecorreia
3088,Error in MySQL Query Syntax,defect,0.11,,new,2008-05-28T08:21:00+02:00,2022-09-12T16:44:06+02:00,"Trac detected an internal error:

{{{
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 ')\n     GROUP BY r.author \n     ORDER BY commits DESC \n     LIMIT 5' at line 3"")
}}}

Most recent call last:
{{{#!logtalk
    * File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"", line 417, in _dispatch_request
      Code fragment:
       412. try:
       413. if not env and env_error:
       414. raise HTTPInternalError(env_error)
       415. try:
       416. dispatcher = RequestDispatcher(env)
       417. dispatcher.dispatch(req)
       418. except RequestDone:
       419. pass
       420. resp = req._response or []
       421.  
       422. except HTTPException, e:
      Local variables:
      Name	Value
      after 	[u' except RequestDone:', u' pass', u' resp = ...
      before 	[u' try:', u' if not env and env_error:', u' raise ...
      dispatcher 	<trac.web.main.RequestDispatcher object at 0x2aaad0d9ab10>
      e 	<_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>
      env 	<trac.env.Environment object at 0x2aaaccfc4ad0>
      env_error 	None
      exc_info 	(<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>, ...
      filename 	'/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py'
      frames 	[{'function': '_dispatch_request', 'lines_before': [u' try:', u' ...
      has_admin 	True
      line 	u' dispatcher.dispatch(req)'
      lineno 	416
      message 	u'ProgrammingError: (1064, ""You have an error in your SQL syntax; check ...
      req 	<Request ""GET u'/stractistics'"">
      resp 	[]
      tb 	<traceback object at 0x2aaad0d82c68>
      tb_hide 	None
      traceback 	'Traceback (most recent call last):\n File ...
    * File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"", line 197, in dispatch
      Code fragment:
       192. req.args.get('__FORM_TOKEN') != req.form_token:
       193. raise HTTPBadRequest('Missing or invalid form token. '
       194. 'Do you have cookies enabled?')
       195.  
       196. # Process the request and render the template
       197. resp = chosen_handler.process_request(req)
       198. if resp:
       199. if len(resp) == 2: # Clearsilver
       200. chrome.populate_hdf(req)
       201. template, content_type = \
       202. self._post_process_request(req, *resp)
      Local variables:
      Name	Value
      chosen_handler 	<stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0>
      chrome 	<trac.web.chrome.Chrome object at 0x2aaad0d9a790>
      err 	(<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>, ...
      handler 	<stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0>
      req 	<Request ""GET u'/stractistics'"">
      self 	<trac.web.main.RequestDispatcher object at 0x2aaad0d9ab10>
    * File ""build/bdist.linux-x86_64/egg/stractistics/web_ui.py"", line 116, in process_request
      Local variables:
      Name	Value
      config 	{'wiki_ignored_authors': [], 'repository_ignored_authors': [], ...
      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>
      elem 	('User reports', 'user_reports')
      links 	[('Project reports', '/stractistics/project_reports'), ('User reports', ...
      module 	None
      req 	<Request ""GET u'/stractistics'"">
      self 	<stractistics.web_ui.StractisticsModule object at 0x2aaad0d80cd0>
      strac_ref 	'/stractistics'
    * File ""build/bdist.linux-x86_64/egg/stractistics/global_reports.py"", line 31, in global_reports
      Local variables:
      Name	Value
      config 	{'wiki_ignored_authors': [], 'repository_ignored_authors': [], ...
      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>
      end_date 	datetime.datetime(2008, 5, 28, 11, 9, 29, 652479)
      req 	<Request ""GET u'/stractistics'"">
      start_date 	datetime.datetime(2008, 3, 5, 11, 9, 29, 652479)
      weeks_back 	12
    * File ""build/bdist.linux-x86_64/egg/stractistics/global_reports.py"", line 64, in _repository_activity
      Local variables:
      Name	Value
      AUTHORS_LIMIT 	5
      WEEKS_NUMBER 	12
      config 	{'wiki_ignored_authors': [], 'repository_ignored_authors': [], ...
      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>
      end_date 	datetime.datetime(2008, 5, 28, 11, 9, 29, 652479)
      ignored_authors 	''
      req 	<Request ""GET u'/stractistics'"">
      start_date 	datetime.datetime(2008, 3, 5, 11, 9, 29, 652479)
      weeks_back 	12
    * File ""build/bdist.linux-x86_64/egg/stractistics/global_reports.py"", line 113, in _most_active_repository_authors
      Local variables:
      Name	Value
      AUTHORS_LIMIT 	5
      authors 	[]
      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>
      end_date 	datetime.datetime(2008, 5, 28, 11, 9, 29, 652479)
      ignored_authors 	''
      map_rows 	<function map_rows at 0x2aaad0d855f0>
      sql_expr 	'\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
      start_date 	datetime.datetime(2008, 3, 5, 11, 9, 29, 652479)
    * File ""build/bdist.linux-x86_64/egg/stractistics/util.py"", line 117, in execute_sql_expression
      Local variables:
      Name	Value
      cursor 	<trac.db.util.IterableCursor object at 0x2aaad0d9e6a8>
      db 	<trac.db.pool.PooledConnection object at 0x2aaad0d82440>
      map_rows 	<function map_rows at 0x2aaad0d855f0>
      sql_expr 	'\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
    * File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"", line 51, in execute
      Code fragment:
        46. # -- In case of SQL errors, uncomment the following 'print' statements
        47. # print 'execute', repr(sql)
        48. if args:
        49. # print repr(args)
        50. return self.cursor.execute(sql_escape_percent(sql), args)
        51. return self.cursor.execute(sql)
        52.  
        53. def executemany(self, sql, args=None):
        54. # print 'executemany', repr(sql)
        55. if args:
        56. # print repr(args)
      Local variables:
      Name	Value
      args 	None
      self 	<trac.db.util.IterableCursor object at 0x2aaad0d9e6a8>
      sql 	'\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
    * File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"", line 51, in execute
      Code fragment:
        46. # -- In case of SQL errors, uncomment the following 'print' statements
        47. # print 'execute', repr(sql)
        48. if args:
        49. # print repr(args)
        50. return self.cursor.execute(sql_escape_percent(sql), args)
        51. return self.cursor.execute(sql)
        52.  
        53. def executemany(self, sql, args=None):
        54. # print 'executemany', repr(sql)
        55. if args:
        56. # print repr(args)
      Local variables:
      Name	Value
      args 	None
      self 	<trac.db.util.IterableCursor object at 0x2aaad0d9ea28>
      sql 	'\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
    * File ""/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py"", line 163, in execute
      Code fragment:
       158. self.errorhandler(self, TypeError, m)
       159. except:
       160. exc, value, tb = exc_info()
       161. del tb
       162. self.messages.append((exc, value))
       163. self.errorhandler(self, exc, value)
       164. self._executed = query
       165. self._warning_check()
       166. return r
       167.  
       168. def executemany(self, query, args):
      Local variables:
      Name	Value
      ListType 	<type 'list'>
      TupleType 	<type 'tuple'>
      args 	None
      charset 	'utf8'
      db 	<weakproxy at 0x2aaace3f8d08 to Connection at 0x2aaabcc7dfe0>
      exc 	<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>
      exc_info 	<built-in function exc_info>
      query 	'\n SELECT r.author AS author, COUNT( r.author ) AS commits \n FROM ...
      self 	<MySQLdb.cursors.Cursor object at 0x2aaad0d9b190>
      value 	<_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>
    * File ""/usr/lib64/python2.4/site-packages/MySQLdb/connections.py"", line 35, in defaulterrorhandler
      Code fragment:
        30. cursor.messages.append(error)
        31. else:
        32. connection.messages.append(error)
        33. del cursor
        34. del connection
        35. raise errorclass, errorvalue
        36.  
        37.  
        38. class Connection(_mysql.connection):
        39.  
        40. """"""MySQL Database Connection Object""""""
      Local variables:
      Name	Value
      error 	(<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>, ...
      errorclass 	<class _mysql_exceptions.ProgrammingError at 0x2aaace3e24d0>
      errorvalue 	<_mysql_exceptions.ProgrammingError instance at 0x2aaad0d82518>

File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"", line 417, in _dispatch_request
  dispatcher.dispatch(req)
File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/web/main.py"", line 197, in dispatch
  resp = chosen_handler.process_request(req)
File ""build/bdist.linux-x86_64/egg/stractistics/web_ui.py"", line 116, in process_requestFile ""build/bdist.linux-x86_64/egg/stractistics/global_reports.py"", line 31, in global_reportsFile ""build/bdist.linux-x86_64/egg/stractistics/global_reports.py"", line 64, in _repository_activityFile ""build/bdist.linux-x86_64/egg/stractistics/global_reports.py"", line 113, in _most_active_repository_authorsFile ""build/bdist.linux-x86_64/egg/stractistics/util.py"", line 117, in execute_sql_expressionFile ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"", line 51, in execute
  return self.cursor.execute(sql)
File ""/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py"", line 51, in execute
  return self.cursor.execute(sql)
File ""/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py"", line 163, in execute
  self.errorhandler(self, exc, value)
File ""/usr/lib64/python2.4/site-packages/MySQLdb/connections.py"", line 35, in defaulterrorhandler
  raise errorclass, errorvalue
}}}

{{{
System Information:

User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
Trac: 	0.11rc1
Python: 	2.4.3 (#1, Mar 14 2007, 19:01:42) [GCC 4.1.1 20070105 (Red Hat 4.1.1-52)]
setuptools: 	0.6c8
MySQL: 	server: ""5.1.22-rc-log"", client: ""5.0.22"", thread-safe: 0
MySQLdb: 	1.2.1
Genshi: 	0.5dev-r852
mod_python: 	3.2.8
Subversion: 	1.4.2 (r22196)
jQuery:	1.2.3
}}}",abidoon@…
2967,Would like to apply a filter to the ticket stats,enhancement,0.11,,new,2008-04-29T08:36:11+02:00,2020-05-06T02:05:20+02:00,"I would like to be able to apply a filter(s) to the ticket stats.  For example, it would be nice to be able to get the tickets stats for just those of type 'defect' and/or component 'abc'.",anonymous
2952,Author names missing in tables,defect,0.11,,new,2008-04-25T08:41:52+02:00,2020-05-06T02:05:20+02:00,"With Trac 0.11b2, STractistics works great on my system (Linux, Python 2.4.4, Opera 9.50b2) -- except that the tables for repository and wiki activity lack the names of the respective authors in their header fields (the cells are there, but there's no text).  See the attached screenshots.",gomar@…