OperationalError: no such column: remaining_time

[bjdiedering@…]

How to Reproduce

While doing a POST operation on /ticket/2, Trac issued an internal error.

I just created a task. In the next screen, I clicked Edit to change the Type from Task to Requirement. On submitting this form, the error came up

Request parameters:

{'__FORM_TOKEN': u'1b9b0da61198570d28c04836',
 'action': u'leave',
 'cnum': u'1',
 'comment': u'',
 'field_description': u'In de rapportage berekening nieuw cijfer. Er is nu al een berekening gemiddelde van all onderzochte bedrijven. Daaronder moet komen het gemiddelde van alle bedrijven.\r\n\r\n 1.       met zelfde gemeentelijke omvang  \r\n\r\n 2.       in dezelfde provincie\r\n',
 'field_drp_resources': u'',
 'field_remaining_time': u'',
 'field_reporter': u'bjdiedering',
 'field_sprint': u'',
 'field_summary': u'In de rapportage berekening nieuw cijfer',
 'field_type': u'requirement',
 'id': u'2',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2009-06-16 13:45:06+00:00'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.31 Safari/530.5

System Information

Trac	0.11.3
Python	2.4.3 (#1, May 24 2008, 13:47:28) [GCC 4.1.2 20070626 (Red Hat 4.1.2-14)]
setuptools	0.6c5
SQLite	3.3.6
pysqlite	2.3.3
Genshi	0.5.1
mod_python	3.2.8
Subversion	1.5.5 (r34862)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 435, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/agilo-0.7.3.2_r1335_20090220-py2.4.egg/agilo/ticket/web_ui.py", line 202, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 508, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/usr/lib/python2.4/site-packages/trac/ticket/web_ui.py", line 1014, in _do_save
    cnum=internal_cnum):
  File "/usr/lib/python2.4/site-packages/agilo-0.7.3.2_r1335_20090220-py2.4.egg/agilo/ticket/model.py", line 646, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/usr/lib/python2.4/site-packages/trac/ticket/model.py", line 273, in save_changes
    (self[name], self.id))
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: remaining_time

[Christian Boos]

AgiloForScrum issue.