ticket,summary,type,release,owner,status,created,modified,_description,_reporter 11628,"""hours remaining"" can not show",defect,,Sam Bloomquist,new,2014-03-17T03:34:09+01:00,2014-03-17T03:34:09+01:00,"when use ScrumBurndownPlugin the ""hours remaining"" is wrong ",anonymous 11342,Scrum burndown as macro,enhancement,,Sam Bloomquist,new,2013-10-07T14:17:27+02:00,2013-10-07T14:17:27+02:00,It would be nice if you could make a ScrumBurndown macro out of this to allow users to place burndowns everywhere in trac.,anonymous 8789,TypeError: 'NoneType' object is not subscriptable,defect,0.12,daan,new,2011-05-11T22:58:46+02:00,2011-05-12T00:10:07+02:00,"==== How to Reproduce ==== While doing a GET operation on `/burndown`, Trac issued an internal error. I downloaded and installed the plugin via easy_install and giving the SVN location as specified on the page. This is what I did: {{{ C:\>easy_install http://trac-hacks.org/svn/scrumburndownplugin/ Downloading http://trac-hacks.org/svn/scrumburndownplugin/ Doing subversion checkout from http://trac-hacks.org/svn/scrumburndownplugin/ to c:\docume~1\admini~1\locals~1\temp\easy_install-aonx7g\scrumburndownplugin Processing scrumburndownplugin Running trunk\setup.py -q bdist_egg --dist-dir c:\docume~1\admini~1\locals~1\tem p\easy_install-aonx7g\scrumburndownplugin\trunk\egg-dist-tmp-vk_ngq zip_safe flag not set; analyzing archive contents... Adding tracburndown 1.9.2 to easy-install.pth file Installed c:\python27\lib\site-packages\tracburndown-1.9.2-py2.7.egg Processing dependencies for tracburndown==1.9.2 Finished processing dependencies for tracburndown==1.9.2 C:\>trac-admin C:\trac\poc upgrade Attempting to create the burndown table Attempting to modify the milestone table Upgrade of the Burndown plugin failed Error message: (1264, ""Out of range value for column 'due' at row 1"") Upgrade done }}} As you can see after running my environment upgrade I encountered this issue shown above. When I tried to use the plugin via Trac get: TypeError: 'NoneType' object is not subscriptable. Please see below for environment setting and python traceback. I have also attached my log file. Please advise. Request parameters: {{{ {} }}} User agent: `Opera/9.80 (Windows NT 5.2; U; en) Presto/2.8.131 Version/11.10` ==== System Information ==== || '''`Trac`''' || `0.12.3dev-r10683` || || '''`Babel`''' || `0.9.5` || || '''`FullBlog`''' || `0.1.1-r9430` || || '''`Genshi`''' || `0.6` || || '''`mod_wsgi`''' || `3.3 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})` || || '''`MySQL`''' || `server: ""5.5.11"", client: ""5.1.50"", thread-safe: 1` || || '''`MySQLdb`''' || `1.2.3` || || '''`Python`''' || `2.7.1 (r271:86832, Nov 27 2010, 18:30:46) [MSC v.1500 32 bit (Intel)]` || || '''`RPC`''' || `1.1.2-r9970` || || '''`setuptools`''' || `0.6c11` || || '''`jQuery`''' || `1.4.4` || ==== Enabled Plugins ==== || '''`duplicateticketsearch`''' || `1.0.1` || || '''`estimatorplugin`''' || `0.2.5` || || '''`timingandestimationplugin`''' || `1.1.3b` || || '''`tracburndown`''' || `1.9.2` || || '''`tracdiscussion`''' || `0.8-r9877` || || '''`tracexcelviewer`''' || `0.1` || || '''`tracfullblogplugin`''' || `0.1.1-r9430` || || '''`tracsectioneditplugin`''' || `0.1.1` || || '''`tractags`''' || `0.6` || || '''`tracvote`''' || `0.1.3` || || '''`tracwysiwyg`''' || `0.12.0.3-r9676` || || '''`tracxmlrpc`''' || `1.1.2-r9970` || ==== Python Traceback ==== {{{ Traceback (most recent call last): File ""build\bdist.win32\egg\trac\web\main.py"", line 517, in _dispatch_request dispatcher.dispatch(req) File ""build\bdist.win32\egg\trac\web\main.py"", line 238, in dispatch resp = chosen_handler.process_request(req) File ""build\bdist.win32\egg\burndown\burndown.py"", line 172, in process_request data['burndown_data'] = req.hdf['burndown_data'] = self.get_burndown_data(db, selected_milestone, components, selected_component) File ""build\bdist.win32\egg\burndown\burndown.py"", line 205, in get_burndown_data cursor.execute(sqlBurndown, (selected_milestone['name'], comp['name'])) TypeError: 'NoneType' object is not subscriptable }}}",chowell@… 8342,Burndown chart displaying null data,defect,0.11,daan,new,2010-12-28T15:49:28+01:00,2010-12-28T15:49:28+01:00,"Using Scrum Burndown plugin 1.9.2 on trac 0.11.5 with timingandestimationplugin 0.9.0 we have the following problem (see attached image). In the Sprint I see both active and closed tickets and those tickets have set Estimated Hours, Total Hours (when finished), and Percent Complete, as well as other fields. Is this a bug or is there a setting we're missing?",cto@… 7026,Milestone complete button missing,defect,0.11,daan,new,2010-04-23T20:21:22+02:00,2010-04-23T20:21:22+02:00,"The burndown plugin is installed and working ok with our Trac 0.11.6 installation (using the patch outlined here http://trac-hacks.org/ticket/4504). I can start a milestone, and the graph displays ok. However, there is no ""Milestone complete"" button. My user account has BURNDOWN_ADMIN permissions, so it should be there I would think.",guy 6478,Burndown Chart Not Displaying,defect,0.11,daan,new,2010-01-22T10:44:16+01:00,2010-01-22T15:13:26+01:00,"I can not get any Burndownchart to display. The milsestone is started. The report states ""Current effort remaining: 0 hours"" and the area where the chart should be displays a narrow area with numbers -51200 -38400 -25600 -12800 I get the following in my debug logs: {{{ 2010-01-22 10:36:29,041 Trac[main] DEBUG: Dispatching 2010-01-22 10:36:29,067 Trac[chrome] DEBUG: Prepare chrome data for request 2010-01-22 10:36:29,073 Trac[session] DEBUG: Retrieving session for ID 'fredrik' 2010-01-22 10:36:29,138 Trac[tande_filters] DEBUG: self.billing_reports= set([9, 10, 11, 12, 13, 14, 15, 16, 17]) 2010-01-22 10:36:29,139 Trac[ticket_webui] DEBUG: TicketWebUiAddon executing 2010-01-22 10:36:29,139 Trac[ticket_webui] DEBUG: TicketWebUiAddon not the correct template 2010-01-22 10:36:29,836 Trac[main] DEBUG: Dispatching 2010-01-22 10:36:29,841 Trac[chrome] DEBUG: Prepare chrome data for request 2010-01-22 10:36:29,846 Trac[session] DEBUG: Retrieving session for ID 'fredrik' 2010-01-22 10:36:29,851 Trac[tande_filters] DEBUG: self.billing_reports= set([9, 10, 11, 12, 13, 14, 15, 16, 17]) 2010-01-22 10:36:29,852 Trac[ticket_webui] DEBUG: TicketWebUiAddon executing 2010-01-22 10:36:29,852 Trac[ticket_webui] DEBUG: TicketWebUiAddon not the correct template }}}",anonymous 6233,needs_upgrade logic is flawed,defect,0.11,Sam Bloomquist,new,2009-11-19T11:24:52+01:00,2009-11-19T11:24:52+01:00,"The logic of the [source:scrumburndownplugin/trunk/burndown/burndown.py burndown.py] environment_needs_upgrade is flawed. If the `burndown` table does not exist, but the `milestone` table has a `started` field (created by an other plugin), the `needsUpgrade` is set to `False` See attached patch for improved logic",hans.bogaards@… 6200,TracBurnDown does not work with custom workflow,defect,0.11,daan,new,2009-11-13T10:35:34+01:00,2009-11-13T10:35:34+01:00,"'''Problem''': [http://trac-hacks.org/wiki/ScrumBurndownPlugin TracBurnDown] does not work with custom workflow because burndown.py compares the status with a fixed set of values. '''Solution''': Follow the assumptions in [http://trac.edgewall.org/wiki/TracWorkflow TracWorkflow] and include every ticket that is not closed. Patch from [http://people.debian.org/~jps/squeeze preliminary Debian package] attached. ",Jens Peter Secher 5891,Method to recover from Milestone renaming,defect,0.11,Sam Bloomquist,new,2009-09-29T03:16:10+02:00,2009-09-29T03:16:10+02:00,"It was decided to rename all our milestones and components mid-sprint. This appears to cause the burndown charts to cease to exist. I opened up the sqlite3 file and changed the burndown table entries to match the new names but the burndown chart page is still blank. I restarted Apache, still no joy. After reviewing the database tables, I'm not sure what else to fix. Everything matches the enum's but the charts are still not built. Can the charts be recovered? Any ideas on a work around? ",Jhon Honce 5590,Burndown table not getting updated for certain milestones,defect,0.11,Sam Bloomquist,new,2009-07-30T11:38:26+02:00,2009-07-30T11:38:26+02:00,"I installed the latest burndown plugin & observed that burndown graphs are displaying only for couple of milestones & not for other milestones. I checked the sqlite database at back end & observed that entries are not present for other milestones. What could be reason for this?",amith 5583,No graph when no components are defined,defect,0.11,daan,new,2009-07-29T13:17:57+02:00,2009-07-29T13:17:57+02:00," If there are no components defined there will be no burndown visible. That's very surprising and difficult to figure out without looking at the code. Would be nice to have a fix for that. Code (burndown.py), problem marked by XXX: {{{ def update_burndown_data(self): db = self.env.get_db_cnx() cursor = db.cursor() # today's date today = format_date(int(time.time())) milestones = dbhelper.get_milestones(db) components = dbhelper.get_components(db) for mile in milestones: if mile['started'] and not mile['completed']: # milestone started, but not completed XXX PROBLEM>>> for comp in components: XXXXX HERE: WHAT IF NO COMPONENTS?? XXXXX sqlSelect = ""SELECT est.value AS estimate, ts.value AS spent ""\ ""FROM ticket t ""\ }}} Thanks!",forum-mail@… 4925,ScrumBurndownPlugin integration with TracHoursPlugin,enhancement,0.11,daan,new,2009-04-15T16:40:51+02:00,2009-04-15T16:40:51+02:00,The ScrumBurndownPlugin should integrate with the TracHoursPlugin method of doing time tracking instead of only working with the TimingAndEstimationPlugin.,anonymous 4667,Burndown only shows 2 days and not the days of sprint,defect,0.11,Sam Bloomquist,new,2009-02-20T00:30:59+01:00,2012-02-01T02:46:13+01:00,"Hello I've just installed the timeandestimating pluging and then the scrumburndownplugin. Then I've done estimating the tickets of milestone ""Sprint 1"". When I go to the burndown chart, it shows remaining hours and only 2 days of the sprint. Should the chart not show all days of sprint? ",cmenzi@… 4603,Burndown and roadmap differs in amount of work remaining,defect,0.11,daan,new,2009-02-10T14:09:18+01:00,2009-02-18T11:24:26+01:00,"I don't know if this is by design or so, but I've got 360 hours remaining on a milestone in the roadmap, and only 89 hours showing by the burndown chart. I've looked at the burndown table and am thinking that it might be out-of-date somehow. Can I force a rebuild somehow, to see if that's the case? (Great plugin btw! :)",Marcus Lindblom 4517,Change method for computing burndown,defect,0.11,daan,new,2009-01-26T11:05:58+01:00,2009-02-10T17:17:26+01:00,"Opening ticket after discussion started here : http://stuq.nl/weblog/2008-12-25/scrum-burndown-plugin-191-released#comment-5468 The plugin currently calculates burndown as 'hours estimated for ticket - hours spent on ticket'. Per Scrum best practices, burndown should be only the 'estimated hours', and should not involve the actual hours spent on the task.",adean@… 4413,Collecting data for milestones that were not yet started,enhancement,0.11,daan,assigned,2009-01-09T10:54:32+01:00,2009-01-15T10:59:24+01:00,"With the implementation of ticket #1462 we can now set a new start date for a give milestone, which is great, but I'm now not sure how should the chart behave when this feature is used... I tried defining a start date for a milestone that has started a few weeks ago, and was expecting to see a chart for this entire period when selecting the right milestone on the burndown tab. However, what happens is that the chart for this milestone keeps being displayed as it was started today, even though it does contain some previously closed tickets. I think I understand why this happens (please confirm): the chart data is actually stored as we go adding time and closing tickets, so even if we change the start date, the 'historical' data as registered by the ScrumBurndownPlugin won't be affected, and the plotted chart will be the same. In spite of this, I still wish I could see the burndown for milestones that have started before the plugin was in use, and even for milestones that have already been closed, as it may allow to better understand the project's work-cycle, and better plan for the future. My suggestion (not sure if this is even doable) is that the chart is plotted on the fly, from the TimingAndEstimationPlugin data (estimated hours and total hours) and from the ticket data (which milestone does it belong to, when was it added and when was it closed), instead of keeping historical data specific for ScrumBurndownPlugin. Something that may become an issue with this approach is that tickets that are removed or added after the milestone's start date won't be reflected on the burndown chart (btw, this was also an issue discussed in ticket #1292). However, maybe it's not that bad to allow modifying a chart on a past time-frame; after all, if we think of a milestone as a sprint, adding and removing tickets should be avoided as much as possible, so, when it does happen, it is probably to correct some misuse of trac, and make it reflect what really happened. ",Filipe Correia 4408,Chart line precision (dealing with fractions of an hour),defect,0.11,daan,assigned,2009-01-09T06:53:29+01:00,2009-01-15T11:19:10+01:00,"Although one of my milestones has still half an hour to go, the burndown line is already touching the bottom of the chart (pls see the attached picture). At first, I though it might had something to do with issue #3490 of the TimingAndEstimationPlugin, but i've fixed that one (by upgrading pysqlite) and haven't seen any change on the chart, so it might not have anything to do with it.",Filipe Correia 4381,UnicodeDecodeError with Trac-0.11,defect,0.11,daan,assigned,2009-01-05T15:41:27+01:00,2012-02-01T05:50:46+01:00,"I have installed the ""Timing and Estimation Plugin"" without any problems and everything was working. After installation of the ""Scrum Burndown Plugin"" I see this error, when I click on the ""Burndown"" menu entry: {{{ Traceback (most recent call last): File ""/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/api.py"", line 339, in send_error 'text/html') File ""/usr/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/chrome.py"", line 726, in render_template stream.render(method, doctype=doctype, out=buffer) File ""build/bdist.linux-i686/egg/genshi/core.py"", line 179, in render File ""build/bdist.linux-i686/egg/genshi/output.py"", line 61, in encode File ""build/bdist.linux-i686/egg/genshi/output.py"", line 311, in __call__ File ""build/bdist.linux-i686/egg/genshi/output.py"", line 753, in __call__ File ""build/bdist.linux-i686/egg/genshi/output.py"", line 592, in __call__ File ""build/bdist.linux-i686/egg/genshi/output.py"", line 707, in __call__ UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 1155: ordinal not in range(128) }}} As you can imagine, with this error, the plugin is useless for us... Btw, trac default character set is UTF-8 (we use German Umlauts).",oliver.mueller@… 3723,Ideal burndown line,enhancement,0.11,daan,new,2008-09-15T11:29:23+02:00,2008-10-21T18:04:49+02:00,"Would be great having an ideal-burndown line being plotted. Something similar to what agilo does (http://media.agile42.com/content/Burndown_Chart_of_Agilo_for_Scrum.png), but not requiring all of agilo's other features, which, i believe, aren't really needed (at least, for me they aren't). ",Filipe Correia 1626,Allow filter milestones in burndown chart,enhancement,0.10,daan,new,2007-06-07T12:17:43+02:00,2008-10-17T08:45:51+02:00,"I't would be nice if we can exclude some milestones in the burndown chart's combo. It's necesary when we have a lot of finished milestones.",jmnavarro@… 1249,Let the whole timeline be shown,enhancement,0.10,daan,new,2007-02-25T10:42:28+01:00,2010-05-04T17:12:24+02:00,"It would be great if we could see the whole timeline from the very beginning so that we would always see what we're approaching to (in terms of # of days). In other words, the whole X-axis should be shown from the very beginning so that we would always know if our work efforts are close to the ideal or not.",tote 637,Have a capacity line in the chart when the due date of a milestone is set,enhancement,0.10,daan,new,2006-08-22T11:58:30+02:00,2008-10-17T08:48:27+02:00,"Hi, I made some additions to your ScrumBurndownPlugin in order to support a capacity line. It draws an additional line when the milestone due date is set. (calculate the difference between start and due date, and adds the line with a seperate array of points) [[BR]] If you're intrested I can provide a patch. (this will include some additional fixes, like setting the current_estimate to 0 when a ticket is closed (in the burndown_job) and not displaying a chart when there is no data. ",Olger Warnier