We are using TRAC as our SCM and project management tool. There are a lot of nice plugins to integrate in the project, and one of them is the ScrumBurndownPlugin, which makes it possible to perform SCRUM @ my company.
But by installing the plugin, I was receiving this error:
Traceback (most recent call last): File "\trac\web\main.py", line 513, in _dispatch_request dispatcher.dispatch(req) File "\trac\web\main.py", line 235, in dispatch resp = chosen_handler.process_request(req) File "\trac\ticket\roadmap.py", line 591, in process_request return self._do_save(req, db, milestone) File "\trac\ticket\roadmap.py", line 673, in _do_save milestone.update() File "\trac\ticket\model.py", line 1004, in update @self.env.with_transaction(db) File "\trac\db\api.py", line 77, in transaction_wrapper fn(ldb) File "\trac\ticket\model.py", line 1014, in do_update self.description, old_name)) File "\lib\site-packages\trac\db\util.py", line 65, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "\lib\site-packages\MySQLdb\cursors.py", line 166, in execute self.errorhandler(self, exc, value) File "\lib\site-packages\MySQLdb\connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue DataError: (1264, "Out of range value for column 'due' at row 1")
It seems that the ScrumBurndownPlugin, which adds the started column by re-creating the whole table milestone, unfortunately changes column types with int types instead of bigint. So I fixed it by performing this query:
ALTER TABLE `milestone` CHANGE `due` `due` BIGINT( 20 ) NULL DEFAULT NULL
For more details, go here ...