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\", line 513, in _dispatch_request
  File "\trac\web\", line 235, in dispatch
    resp = chosen_handler.process_request(req)
  File "\trac\ticket\", line 591, in process_request
    return self._do_save(req, db, milestone)
  File "\trac\ticket\", line 673, in _do_save
  File "\trac\ticket\", line 1004, in update
  File "\trac\db\", line 77, in transaction_wrapper
  File "\trac\ticket\", line 1014, in do_update
    self.description, old_name))
  File "\lib\site-packages\trac\db\", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "\lib\site-packages\MySQLdb\", line 166, in execute
    self.errorhandler(self, exc, value)
  File "\lib\site-packages\MySQLdb\", 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.


  • 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].
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.