OperationalError: no such column: estimatedhours

[selenwall]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__EDITOR__1': u'wysiwyg',
 '__EDITOR__2': u'wysiwyg',
 '__FORM_TOKEN': u'975e1be6d7f232707beb9378',
 'action': u'leave',
 'cnum': u'1',
 'comment': u'',
 'field_description': u'We are now running Trac, but are any other more suitable/easy to use issue management systems.\r\n\r\nPricing might be an issue too, as reference XP-dev cost 6$ a month.\r\n\r\nSome requirements (at least for me),\r\n\r\n * Milestones\r\n * Backlogs\r\n * Discussion forum\r\n * Blog',
 'field_keywords': u'',
 'field_rd_points': u'0',
 'field_reporter': u'selenwall',
 'field_sprint': u'',
 'field_story_priority': u'Linear',
 'field_summary': u'Evaluate issue management systems',
 'field_type': u'story',
 'id': u'3',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2012-09-25 19:13:46.167600+00:00'}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/536.26.14 (KHTML, like Gecko) Version/6.0.1 Safari/536.26.14

System Information

Trac	0.12.3
Trac	0.12.3
Agilo	0.9.7
Babel	0.9.6
Docutils	0.8.1
Genshi	0.6
GIT	1.7.10.3
mod_wsgi	3.3 (WSGIProcessGroup traclocal WSGIApplicationGroup %{GLOBAL})
Pygments	1.4
pysqlite	2.6.0
Python	2.7.3 (default, Aug 1 2012, 05:25:23) [GCC 4.6.3]
Python	2.7.3 (default, Aug 1 2012, 05:25:23) [GCC 4.6.3]
RPC	1.1.2
setuptools	0.6
setuptools	0.6
SQLite	3.7.9
Subversion	1.7.5 (r1336830)
jQuery	1.4.4

Enabled Plugins

agilo	0.9.7
BreadCrumbsNav	0.3dev
ComponentDependencyPlugin	0.1
TicketImport	0.8.2
TicketSidebarProvider	0.0
timingandestimationplugin	1.2.7
TracAnnouncer	0.12.1dev
TracBurndown	1.9.2dev
Tracchildtickets	2.4.5
TracDiscussion	0.8
TracGit	0.12.0.5dev
TracHoursPlugin	0.5.2
TracIncludePagesMacro	0.1
TracMasterTickets	3.0.2
TracTocMacro	11.0.0.3
TracWikiToPdfPlugin	2.3.1
TracWysiwyg	0.12.0.4
TracXMLRPC	1.1.2
TracXPDev	1.0

Python Traceback

Traceback (most recent call last):
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/web/main.py", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/web_ui.py", line 169, in process_request
    return self._process_ticket_request(req)
  File "/srv/trac-deploy/plugins/agilo-0.9.7-py2.7.egg/agilo/ticket/web_ui.py", line 225, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/web_ui.py", line 541, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/web_ui.py", line 1238, in _do_save
    cnum=internal_cnum):
  File "/srv/trac-deploy/plugins/agilo-0.9.7-py2.7.egg/agilo/ticket/model.py", line 808, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/model.py", line 289, in save_changes
    @self.env.with_transaction(db)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/ticket/model.py", line 335, in do_save
    % name, (self[name], self.id))
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/util.py", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 78, in execute
    result = PyFormatCursor.execute(self, *args)
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 56, in execute
    args or [])
  File "/opt/trac/current/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
OperationalError: no such column: estimatedhours

Note: This happened when I just wanted to modify a created Ticket, and there were no field for "estimated hours"… at all!

[Remy Blank]

PluginIssue (AgiloForScrum).