TRAC: DataError: (1264, "Out of range value for column 'due' at row 1")

Submitted by Jochus on Mon, 06/09/2010 - 00:31 | Posted in: Java

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 ...

Add new comment

The content of this field is kept private and will not be shown publicly.

Full HTML

  • Lines and paragraphs break automatically.
  • You can caption images (data-caption="Text"), but also videos, blockquotes, and so on.
  • Web page addresses and email addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <bash>, <cpp>, <css>, <html5>, <java>, <javascript>, <php>, <sql>, <xml>. The supported tag styles are: <foo>, [foo].
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.