OperationalError: no such column: remaining_time

[dinis@…]

How to Reproduce

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

I have installed the Agilo plugin for Trac and it comes out with this error each time I try to update a task from ticket type task to any other ticket type

Request parameters:

{'__FORM_TOKEN': u'df00906ee156b1119e97553f',
 'action': u'leave',
 'cnum': u'6',
 'comment': u'',
 'field_description': u'Test full description',
 'field_drp_resources': u'',
 'field_remaining_time': u'',
 'field_reporter': u'dinis@thepieguide.com',
 'field_sprint': u'',
 'field_summary': u'Test summary',
 'field_type': u'story',
 'id': u'747',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2009-02-20 15:52:54+00:00'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6

System Information

Trac	0.11.3
Python	2.4.3 (#1, Aug 11 2006, 14:21:53) [GCC 3.3.5-20050130 (Gentoo 3.3.5.20050130-r1, ssp-3.3.5.20050130-1, pie-8.7.7.
setuptools	0.6c3
SQLite	3.3.5
pysqlite	2.3.1
Genshi	0.5.1
mod_python	< 3.2
Subversion	1.3.2 (r19776)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11.3-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.3-py2.4.egg/trac/web/main.py", line 205, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11.3-py2.4.egg/trac/ticket/web_ui.py", line 182, in process_request
    return self._process_ticket_request(req)
  File "/var/lib/trac/pie/plugins/agilo-0.7.3.1_r1274_20090203-py2.4.egg/agilo/ticket/web_ui.py", line 202, in _process_ticket_request
  File "/usr/lib/python2.4/site-packages/Trac-0.11.3-py2.4.egg/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-0.11.3-py2.4.egg/trac/ticket/web_ui.py", line 1014, in _do_save
    cnum=internal_cnum):
  File "/var/lib/trac/pie/plugins/agilo-0.7.3.1_r1274_20090203-py2.4.egg/agilo/ticket/model.py", line 646, in save_changes
  File "/usr/lib/python2.4/site-packages/Trac-0.11.3-py2.4.egg/trac/ticket/model.py", line 273, in save_changes
    (self[name], self.id))
  File "/usr/lib/python2.4/site-packages/Trac-0.11.3-py2.4.egg/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-0.11.3-py2.4.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/usr/lib/python2.4/site-packages/Trac-0.11.3-py2.4.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: remaining_time

[Emmanuel Blot]

Remove the Agilo plugin or report the error to the plugin maintainer.