start milstone: TypeError: a float is required

[shlomi]

How to Reproduce

While doing a GET operation on /burndown, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'selected_component': u'All Components',
 'selected_milestone': u'audio-sprint-1',
 'start': u'Start Milestone'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 (.NET CLR 3.5.30729)

System Information

Trac	0.11.4
Python	2.4.3 (#1, May 24 2008, 13:47:28) [GCC 4.1.2 20070626 (Red Hat 4.1.2-14)]
setuptools	0.6c11
SQLite	3.3.6
pysqlite	1.1.7
Genshi	0.5.1
mod_python	3.2.8
Subversion	1.6.6 (r40053)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.4-py2.4.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "build/bdist.linux-i686/egg/burndown/burndown.py", line 166, in process_request
  File "build/bdist.linux-i686/egg/burndown/burndown.py", line 233, in start_milestone
  File "build/bdist.linux-i686/egg/burndown/dbhelper.py", line 96, in get_startdate_for_milestone
TypeError: a float is required

[Christian Boos]

PluginIssue (​TracHacks:ScrumBurndownPlugin)

[anonymous]

Just need to modify table 'Milestone' :

ALTER TABLE milestone CHANGE due due BIGINT( 20 ) NULL DEFAULT NULL; ALTER TABLE milestone CHANGE completed completed BIGINT( 20 ) NULL DEFAULT NULL;

/!\ Pay attention here to set the default value of started to something other than NULL !

ALTER TABLE milestone CHANGE started started BIGINT( 20 ) NULL DEFAULT 0;

Then it works for me. Hope it will help.

[rolechka@…]

In the sqlite it is quite difficult because there are no ALTER COLUMN in sqlite: ​http://stackoverflow.com/questions/4007014/alter-column-in-sqlite

May be there is some other way to fix this trouble? Thank you very much!!